I have built a baq that has a parameter for a date field that is plugged into a subquery. When I create the BAQ report and add an option field for reportparam_date01 and run the baq report I get no results back. What steps am I missing to link the parameter in my baq to the parameter in the baq repo…

BAQ Report has been surpassed by creating it through a RDD. See this below thread for more information. [image] Is there a way to add table or BAQ to a BAQ Report ERP 10 First consider the BAQ Report functionality dead, its not dead but there is no reason to ever use BAQ …

Is the field a custom field or a standard field on a table in the BAQ? If you open your .rdl in a text editor like Notepad++, you can add the field under your SQL select statement under the BAQReportResult dataset. You then also want to make sure that you add it as a field option in the fields sect…

I see you are talking about the actual parameters in a BAQ that you can add. I haven’t done it personally, but it is probably similar. Edit: You may need to add the table onto the SQL statement. Alternatively, I sometimes will create a new BAQ Report with that query, download a fresh copy of the s…

@cfinley , Hey, I’m trying to recreate what they did and I’m not getting the parameter field to pull in. I created a new RDD and pulled in my baq. Then I added a criteria set and linked it to the criteria on the baq. Once that is done is where I start to struggle. I cannot make a new report in repor…

When you initially create the RDD with the BAQ inside of it, there should be entries in the below screen assuming you have parameters inside of your BAQ. Click the checkboxes on all the parameters you want to show on the print screen and select the control type. This will automatically create the Fi…

@cfinley , How did you make those criteria mandatory? That option is greyed out for me. [image]

@cfinley , That fixed that issue. I am still unable to create a report. I followed the instructions listed here: https://help.epicor.com/erp/102700/enu/standard/snm_enu.htmVersion=3.2.700.0#Imp_Reporting/BAQCreateReportCriteriaSet_AddMapping.html and receive the error below: [image] I put in a …

After you click new report in report style, you cant save the record? is that the issue? Or is that when you try to run the report?

I can save it. I just can’t download, upload, or sync dataset.

Have you tried creating a blank report in report builder and saving it to your desktop under a folder with that exact path? Create windows folder structure to mirror the one you entered in the report style screen. Desktop > reports > customreports > randomfoldername > {report will be saved here} I…

BAQ Report Parameter - Help Needed

Epicor ERP 10

cfinley (Chance Finley) February 25, 2021, 6:07pm 8

You have to set the parameters as mandatory inside the BAQ

BAQ Report - No Records Selected

Topic		Replies	Views
BAQ Parameters Not Working on SSRS Report Epicor ERP 10 baq , ssrs , reports	11	3348	January 7, 2021
How do I pass BAQ Parameters into a custom SSRS report? Epicor ERP 10 e10 , baq , ssrs , reports	12	6242	August 24, 2020
Option Field Dropdown Selection in Report Designer from BAQ Parameters Epicor ERP 10 customization	3	1816	January 5, 2023
Adding parameters to an existing BAQ Report Epicor ERP 10 baq , reports	4	705	September 17, 2021
Passing Report Parameters to a BAQ Report Epicor ERP 10 baq , reports , baqreport-parameter	10	7722	October 28, 2020

BAQ Report Parameter - Help Needed

Related topics