RDD report with User Parameter

[vfeldt (Valorie)]

I followed the suggestions in this thread and have successfully made several label reports using RDD and SSRS Reports for the shop floor to print box labels and the like for specific jobs types.

Exact steps for making an RDD based Report that uses BAQ's ("Advanced BAQ Reports")?

No I did not … (I knew it was something simple!!) And one thing that I didn’t realize… Since the Criteria Set is tied to the Style, selecting a different style on the report form , changes the criteria displayed. [ReportCriteria]

I’ve also created BAQ Report Designer reports with option fields and passed those along to the report design.

BAQ Report Designer Parameter

EDIT: Some steps in this post are not required. See Post 14 for an update Try using another option field on the BAQ Report Designer for your input param, but with NotEquals. This will ignore this value when selecting the records. And you can reference the value the user entered in the BAQ Report. Here’s some picts in case that wasn’t clear… BAQ includes a column of type text with a width at least as wide as your input text: [image] The BAQ Report includes an Option field using that colu…

Now I need a label that will have BAQ parameters (OrderNum/OrderLine parameter input by user) to pass to the report but also an Option field for the user to type in a quantity that will print on the label. I can’t quite wrap my brain around doing both. If I create an RDD/SSRS report, how to I create an input field for the user to enter that will pass along to the report design when it’s not a BAQ Report Design?

[vfeldt (Valorie)]

I have resolved this on my own. It must be obvious to other but just in case.

I added another parameter to the BAQ then created a calculated field that references the added parameter. So when the BAQ runs the user is asked to input the quantity to reference the parameter. The parameter can then be included in the RDD and the SSRS report.

[ckrusen (Calvin Krusen)]

Glad you figured something out. If it gives you problems look at the following:

BAQ Report Designer Parameter

EDIT: Some steps in this post are not required. See Post 14 for an update Try using another option field on the BAQ Report Designer for your input param, but with NotEquals. This will ignore this value when selecting the records. And you can reference the value the user entered in the BAQ Report. Here’s some picts in case that wasn’t clear… BAQ includes a column of type text with a width at least as wide as your input text: [image] The BAQ Report includes an Option field using that colu…

[vfeldt (Valorie)]

Thanks Calvin! I’ve read many threads from you with solutions to similar problems you always seem to have an answer and it is much appreciated!