Here I am again with more struggles. I am creating a report that is filtered by site. In the BAQ, after defining parameters I have a dropdown box of the custom fields I create. [4] [3] The BAQ is filtered by these fields just fine, and I can select from all 3. The problem comes from the Report …

I have not tried doing this through RDD, also have not built a criteria set. This is new territory to me, so I’ll use that shared thread as reference. Thank you

The term “BAQ/RDD” is a little misleading. I like “Advanced BAQ Report” better. Once you get the hang of it (and it is tricky), you’ll like it over the flat BAQ Report.

Option Field Dropdown Selection in Report Designer from BAQ Parameters

Epicor ERP 10

ckrusen (Calvin Krusen) January 5, 2023, 8:05pm 2

You should not predefine the parameters in the BAQ if something else (like the Report form) is going to do it.

I’d Add a filter to the Report from as that will do what you want. It will require going to a second sheet.

~~I don’t know of a way to have the predefined values of the BAQ paramter passed to the report form.~~ Did you make criteria Sets?

Edit

Maybe this post will help:

Topic		Replies	Views
How do I pass BAQ Parameters into a custom SSRS report? Epicor ERP 10 e10 , baq , ssrs , reports	12	6194	August 24, 2020
BAQ Report Parameter - Help Needed Epicor ERP 10 baq , ssrs , reports	13	7494	February 25, 2021
How to create custom SSRS report that takes BAQ parameter as RDD Criteria? Epicor ERP 10 ssrs	2	1985	May 5, 2021
RDD report with User Parameter Kinetic ERP reports	3	2208	April 7, 2022
RDD Report Criteria is greyed-out Epicor ERP 10 baq , ssrs	25	5102	September 22, 2021

Option Field Dropdown Selection in Report Designer from BAQ Parameters

Edit

Related topics