Pass RDD Criteria data to SSRS Report

[ckrusen (Calvin Krusen)]

That other topic was about adding a value to pass to the SSRS report. For either just displaying in the report or for having it actually affect the data used by the report.

I’m guessing you have a value that a user enters into a “built-in” control that is used by the RDD as criteria. And that you want that value entered to be available in the SSRS. Like to display in the header, so as to show the parameters used.

So you want to copy the value of that built-in control to the CallContextBPMData. Then in the RDL, just add the CallContextBPMData_GUID table to the query expression. Or add it as a separate dataset if you don’t need to use it in the main dataset.

edit

Does the RDD version of a BAQ Report not have the BAQReportResults “table”?

Edit #2

The following is from a topic related to accessing RDD based criteria:

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." …