Share
Report
280Hi all
Running AX 2012 R3 CU9.
Running an SSRS report which currently deals with multiple data sets in one report. (Works orders, Bill of materials, routes and one other.) Currently it is using an RDP class to achieve this. It works fine when you input a works order ID, and it prints all the information from those data sets solely about that works order.
However, there is now a need for the report to take multiple works orders in its query parameters and group them with page breaks. I am not sure how to do this as there is several tables on the report, all with technically unlinked data sets. How would I detect where the page break is supposed to go? How do I group by ProdTable.ProdId on all the associated tables at once?
I was looking into SSRS "lists" to cover this requirement, but it looks like lists are for having multiple standalone objects that all use the same dataset?
I also looked into building a query which would gather all the data, but SalesLine > BomTable and SalesLine > ProdRoute are both 1:many joins, and it would result in a lot of duplicate data to be filtered out - especially if it's being run on several production orders at once.
Is there a way to efficiently tell my report to group by this field, even when the report has multiple data sets?
Thanks very much in advance,
Luke
All responses (
Answers (
