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