Hi all, I’m working on replacing some outdated crystal reports inside of Epicor. I think I’ve finally got my BAQ the way I want it, and the performance (so far) seems to be miles ahead of the current crystal report I want to move away from. Now that I think I have the BAQ where I want it, I was l…

Have you looked into the BAQ Designer’s Option Fields when running the report?

I’m looking at that now, is it possible in the options field to allow a drop down? [image] Or would that require the filter / sort? Edit: I want to filter based on BudgetCodeID, but I’m only showing FiscalPeriod/Year [image]

Yeah, this thing so far has been a bit of a pain, mostly moving away from Crystal. I’ll have to do some searching as I will need to learn about creating the RDD from scratch and whatnot.

Some thoughts and a question. There are BAQ Reports There are Reports based on a BAQ These are not the same thing. BAQ Report Designer is an easy way to make a BAQ Report. I don’t think you can do parameters with that, though. [image] But if you create a Report Data Definition, you can base it…

So I created my RDD and added criteria prompts; [image] I created a report and report style: [image] In menu maintenance, it seems to be changing my URL [image] What setup do I need to do so that I can test the report and passing in parameters?

I don’t really understand the URL bit. For a different report, mine looks like this: [image] You don’t need a customization, but the title bar sure is ugly if you don’t. Unless there is an easy step I am missing.

Alright; so starting from the beginning: Here are the BAQ parameters, in the designer the BAQ runs with no issue: [image] Report Data Definition Criteria Set/Prompts created [image] Report style created: [image] Menu maintenance setup: [image] I’m able to navigate to the menu and attempt to…

I think you picked the wrong “Report…” in menu maintenance. I think you referenced the BAQ Report and not the RDD version.

That’s all I’m seeing, maybe I missed something in the setup? [image]

How do I pass BAQ Parameters into a custom SSRS report?

Epicor ERP 10

gpayne (Greg Payne) August 21, 2020, 4:38pm 4

@AaronGDL I just did my first passing of BAQreport parameters and it will likely be by last. My intent going forward is to follow the technique below to create it from scratch so it is more like a system report.

Topic		Replies	Views
Option Field Dropdown Selection in Report Designer from BAQ Parameters Epicor ERP 10 customization	3	1805	January 5, 2023
BAQ Report Parameter - Help Needed Epicor ERP 10 baq , ssrs , reports	13	7529	February 25, 2021
How to create custom SSRS report that takes BAQ parameter as RDD Criteria? Epicor ERP 10 ssrs	2	2003	May 5, 2021
BAQ Parameters Not Working on SSRS Report Epicor ERP 10 baq , ssrs , reports	11	3341	January 7, 2021
BAQ Report works but SSRS Report throws error Epicor ERP 10 baq , ssrs , reports	20	1612	March 17, 2023

How do I pass BAQ Parameters into a custom SSRS report?

Related topics