KBA-01594: Tracing Report Filters

Question:

How do I trace report filters?

Answer:

When you open the Report, enter *ShowDiag in any of the plain text filters for the report.  If the report you are working on only has drop down or lookup-validated filters, then you cannot enter *ShowDiag!   First open the “Projects Nearby” report and put *ShowDiag into its ‘Located Near’ filter. Then run your report. You will see output similar to the following for your filters, underneath the PDF view:

DIAGNOSTIC INFO
16:13:51.09: Report Parameter [pProject] set to ”
16:13:51.09: Report Parameter [pProject] set to ‘012009INT022’ (from Filter)

16:13:51.09: Report Parameter [pVendor] set to ‘%’ (from Filter)

16:13:51.09: Report Parameter [GroupBy] set to ‘0’ (from Filter)

16:13:51.09: Report Parameter [pStatus] set to ‘*’ (from Filter)

16:13:51.09: Report Parameter [pSubcontract] set to ‘%’ (from Filter)
16:13:51.09: Report Parameter [pFApproved] set to ”

16:13:51.09: Report Parameter [pTApproved] set to ” (from Filter)

16:13:51.09: Report Parameter [pOpenLiens] set to ‘False’ (from Filter)

16:13:51.09: Report Parameter [pShowDetail] set to ‘True’ (from Filter)
16:13:51.09: Filter Item Value Changed – pStatus, Idx=3
16:13:51.09: Report Parameter [pStatus] set to ‘I’ (from Filter)

Additional Comments:

*ShowDiag remains in effect until the application is recycled or you specify *ShowDiagF as the value of a plain text filter.

Hint: one common issue is GUIDs not being “valid” after the transition through the API.  Consider casting your GUIDs to VARCHAR(40)


KBA-01594; Last updated: September 18, 2017 at 12:35 pm;
Keywords: SSRS Report troubleshooting