How to get BAQ parameter in SSRS report?

[ckrusen (Calvin Krusen)]

Have you looked at the fields in the BAQReportParameter_GUID table? Fields like BAQReportParameter.Option01 will hold the values from the options created when you made the BAQ Report.

See:

BAQ Parameters Not Working on SSRS Report

You can edit the query expression for the BAQReportResult to join the Rpt Parameter table, like: ="SELECT T1.[PartTran_TranNum],T1.[PartTran_TranDate],T1.[PartTran_TranType],T1.[PartTran_PartNum],T1.[Calculated_TranDateYearPrior], T2.Option01 " + " FROM dbo.[BAQReportResult_" + Parameters!TableGuid.Value + "] AS T1" + " JOIN dbo.[BAQReportParameter_" + Parameters!TableGuid.Value + "] AS T2 ON 1=1" edit Just to be clear. I had to: Add the "AS T1" to the query’s original FROM clause Add "T1." …

Note: these options are from the BAQ Report Builder, not params setup in the BAQ itself.