Share
ReportHi, new to the forum!
A little background, since I don't know the correct AX terminology... I have developed a suite of SSRS reports hosted by the SSRS report server, accessed via IE9 currently, touching Dynamics AX 2009 only to the extent that the report data source is the AX SQL database, and a link to the top-level report manager URL is on the AX users' home form in AX. However, we need to upgrade to IE11 and that is posing printing problems for SSRS reports, so we have decided to integrate these SSRS reports into AX such that they are presented through what I imagine is AX's built-in browser control.
So, we have a group of forms, buttons and menu items, including 'Output' menu items where the ObjectType is 'SQLReportLibraryReport' and the Object is the report name. The report's RDL file is located in the Dynamics AX / Builtin folder along with AX's standard SSRS reports components. This all appears to work fine on our test system for the reports we have 'deployed' (uploaded to Builtin) so far, with one exception, and here's the problem.
I have a Purchase_Order report RDL, accessible through its Browser role security only to the Purchasing department, with a visible 'Hide Financials' parameter defaulting to False. I have an SSRS 'Linked report', called Purchase_Order_Stores, linked to that, where the 'Hide Financials' parameter is hidden and defaults to True, with Browser granted to a group to which all users belong. So, everyone can see / print a PO but without the pricing details, while only Purchasing can see the full PO. This behaves as expected when a user browses to the Builtin folder through IE, and the Purchase Order behaves as expected when triggered through the AX menu item. When the linked report is triggered through its AX menu item, I get an error:
SRSReportView error id 3: Cannot find report Purchase_Order_Stores on the server under the path /Dynamics AX/Builtin Reports.
If I delete the linked report and upload the RDL with a name of Purchase_Order_Stores and set the data source and parameter details correctly, the report executes as expected. But, if possible, I would like to define what is really the same report RDL as a linked report such that, when the RDL gets modified, I do not have to remember to upload multiple copies.
Is AX only capable of executing actual RDL files, and not linked reports? Is there some other method / setting to use when executing a linked report? Any help gratefully received.
Cheers
Mark
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
5
