Hi guys!
I'm trying to create a custom role center for a customer and one of the requirements for the role center is to contain a SSRS report showing some business data.
I was appointed a custom SSRS report that was develop by another vendor and was asked to make a new design within the report because we should use the business logic that was already written to collect the needed data.
I got my auto design prepped and can see the data when put in the report parameters inside Visual Studio:
I deploy the report onto the report server from the AOT and I cleared the reporting server cache, restart the SSRS service, redeploy the report once more, just to make sure that nothing was out of sync.
Learn from earlier experiences I test run the report from the Report Manager (SSRS) and fill in the report parameters and can see the data:
I created a new menu item for the report so I could use it later on my role center. I test run the report from inside the standard AX client by opening the menu item from the AOT and fill in the report parameters and can see the data:
Lastly I want to test my SSRS report from the EP site before using the time to add it to the role center and therefore visits the SRSReportViewer.aspx page on EP and fills in the querystring so I get the full toolbar shown. I fill in the report parameters and executes the report but the the chart area returns "empty":
Something that caught my eye was that the image for "show / hide parameters" was showing. I digged into that and tried to find something similar on google / bing, but was only able to find one post with the same issue and there was no solution posted.
Conclusion from my point of view:
- The report auto design is working
- The report data provider class is working
- The report is deployed to SSRS
The service account on the SSRS instance is the same as the registered Business Connector Proxy account inside AX.
The SharePoint service account running the WebApplication in question is the same as the registered Business Connector Proxy account inside AX.
Any ideas?
