ReportParam in SSRS

[ckrusen (Calvin Krusen)]

See:

Report Parameters Help

You don’t need to add anything to the RDD, because the CallContextBPMData table is inherent to all RDD’s. We don’t use CC’s so I did a test with another form - the Material Transaction Detail. While this has a start and End date, I can add a date field and limit the report to only show records between the native Start date and My date. [image] Then in the Report’s RDL I changed the query for the main table (PartTran in my case) [image] And added the Query field to the dataset’s properties…

That example actually adds fields that filter the data retrived by the RDL. You only need to include the CallContext table.

Basically 2 setps:

1. Customize the form and and a text box bound to CallContextBPMData.Character01

2. Then in the RDL, add to the dataset’s query expression:
   + " JOIN CallContextBPMData_" + Parameters!TableGuid.Value + " T2"
   And add the Character01 query field to the dataset.