Adding parameters to RNI report options

[ckrusen (Calvin Krusen)]

See the following:

Report Parameters Help

Try the following: Customize the Credit Card Report form, adding a date control. Bind it to CallContextBPMData.Date01 Nothing need to be done in the RDD In the copy of your CC Report RDL, edit the Query expression for dataset CreditTran. Add the highlighted parts below: [image] The RDD will use the native date from the form to limit the lower (oldest date), and the additions to the Query expression limit the upper end date. I haven’t tried the above - as we don’t process credit cards. …

For multiple values, either add multiple fields on the form, and to the RLD query (Using logic to AND /OR them, while ignoring blanks).

Or make it a text field that you enter as a comma separated list. and use the the SQL IN operator. This requires you enter the list very specifically.

" WHERE T2.CustID IN (" + T2.Character01 + ") "

And the format of the text field would need to be like:
'ACME123','WID-234'