This article troubleshoots an error that occurs when running reports from a staging database connection.
When the user runs a report from a staging database connection, they receive the following error message. However, when running the report from a regular connection, there is no issue.
Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at OneStop.Framework.Render.ReportJob.AddMessage(String message, Exception ex) at OneStop.Controls.Publisher.JobHelper.ExecuteConnections(IEnumerable`1 connections, ProgressFunction fct) at OneStop.Controls.Publisher.Controls.DistributionTarget.Render(JobHelper jh, IEnumerable`1 entries, ProgressFunction reportProgress)
Filters don't have single quotes in the Layout Editor.
Apply single quotes around filters in the Layout Editor
Report Designer 4.x