Does anyone know how to create a sub-report on a BAQ report? I read that you can create an RDD and link two BAQs, but when a user opens the report, it shows the client screen instead of a kinetic screen (this is an issue; we do not use the client, also cloud-based, and my understanding is that it is going away in six months). Is it possible to use the kinetic browser screens?? I would love to build more complex reports that include sub-reports, but I have not been able to figure out how. Any help would be greatly appreciated
I’m assuming you’re creating an RDD filled with BAQ report data sources (because you can have many) and then the subreports would have one of the BAQ datasources right?
Mr. Nathan: you can add multiple BAQ’s to a single RDD.
I found that I like providing the filtering parameters for each baq in the BAQ and then mapping them later in the RDD.
You can “Link” the two BAQ’s in the RDD - however (not sure if this is still true but it used to be true) Epicor will create the SSRS Select query based on the Alphabetic sort of your BAQ names. So OrderDtl will be the main and first BAQ and OrderHed will be second because of Alpha sorting.
I do not do that anymore and I just create the filtering for the BAQ in the BAQ and then tie them together in the RDD Criteria Set.
The RDD report is MUCH more powerful - but tricky to Setup, Program, Backup, Transfer. Ouch that was alot.
