In addition to the previously requested feature: [image] Dashboard Pass Silent Parameters to BAQ Feature Requests and Suggestions A Feature asked for ages; never delivered by Epicor yet it seems like a simple one… In a Dashboard allow Passing in Parameters to the BAQ Befor…

Like I said, it’s been a while, but you set up your BAQ to have a parameter (through Actions/Design Parameters menu item). You then set up the filter: [image] The “SQL” generated by BAQ from the Phrase Builder looks like this: … normal SQL stuff … where (Tip.TipNum = @MyTipNum) Search for “Add…

It’s been a while since I worked on reporting so most of those neurons have died. Maybe I’m misunderstanding, but I’m pretty sure you can use the user supplied values from the report UI to filter your BAQs. I know I tested passing an Order Number and having it only return the appropriate orders in t…

Filter is post, it probably grabbed all your orders from SQL and then filtered? Im more thinking run the BAQ with the Order # specified What do you put into your BAQ, or do you join on a special table that houses those variables SELECT * FROM Erp.OrderHed WHERE OrderNum = [?something] Right now w…

[image] Dashboard Pass Silent Parameters to BAQ Filter is post, it probably grabbed all your orders from SQL and then filtered? Im more thinking run the BAQ with the Order # specified And you think that’s bad for Haso, imagine the Cloud Users!

Jeff! Where have you been hiding! I dont know why I kept doing BAQ Reports still… This works almost as identical as a BAQ Report. I do recall you mentioning it before. Shame on me. [image] [image] Little bit harder to setup because you have to create a RDL from Scratch but in this one I just used…

I thought we agreed we would never to use “Sync Dataset”. :frowning: If you build your RDD and then create your style in Report Style Maintenance, you can just do a Action\Create SSRS Report and it will create you the template report just like in BAQ Report. Plus, you get all the data columns are m…

Don’t forget you can use this for the “Electronic Compliance” reports as well. Build a couple BAQs, map them to XML, JSON or CVS output. Sweet!

Nice! I tried it in 400.10 got some Template Missing Error, but works fine in 500. Probably screwed up the TemplateReport.rdl or something :slight_smile: [2019-10-17_2052]

If you need to get this to work for earlier versions, back to 10.1.600 (I think), you could try copying the ReportTemplate.rdl from your 500 CustomReports area. The file should be there so something probably just got mixed up. Also check out the code in the *.rdl created by Report Style Maintenance…

[image] Dashboard Pass Silent Parameters to BAQ The methods help get criteria parameter values. Aha!! Found it in the Global Code, ok that makes it much easier than adding the XML Values to SELECT :heart: :smiley: [image]

So does this mean you are planning to withdraw the request for BAQ Report enahncement? Honestly one of my personal if I ever have time, is to gut BAQ report - keep the elements but have it do the RDD creation using the elements you have discovered here. I’d rather just get rid of it but it has been…

BAQRpt & QuickSearch Pass Silent Parameters to BAQ

Feature Requests and Suggestions

Mark_Wonsil (Mark Wonsil) October 17, 2019, 9:49pm 4

And you think that’s bad for Haso, imagine the Cloud Users!

Topic		Replies	Views
Dashboard Pass Silent Parameters to BAQ Feature Requests and Suggestions	63	22145	February 18, 2020
Dashboard Pass Silent Parameters to Updatable BAQ Kinetic ERP baq	5	1439	September 8, 2023
Possible solution for silent BAQ parameter passing (working now) Kinetic ERP baq , kinetic , baq-parameter , application-studio	30	9039	November 7, 2023
Passing Parameter/Filter in Dynamic Query Epicor ERP 10	27	23298	October 19, 2018
Thoughts on Approach to "Pass Parameters Silently" on Dashboard Epicor ERP 10 e10 , customization	10	2872	January 5, 2023

BAQRpt & QuickSearch Pass Silent Parameters to BAQ

Related topics