Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 - EP - SSRS - ...
Microsoft Dynamics AX (Archived)

AX 2012 - EP - SSRS - Chart area empty

(0) ShareShare
ReportReport
Posted on by Motz Jensen 190

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?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX 2012 - EP - SSRS - Chart area empty

    In Solution Explorer, right-click the SampleChartReport project, point to Add, and then click Report.

    In Model Editor, right-click the Report1 node, and then click Rename.

    Type ColumnChartReport as the name.

    Expand the ColumnChartReport node if it is not already expanded.

    Right-click the Datasets node, and then click Add Dataset.

    Select the node for the dataset.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX 2012 - EP - SSRS - Chart area empty

    You could try this and see if it works. Instead of using the SRSReportViewer, did you try using the classic SSRS Report view using the Report server url . 

    Format: http://<yoursever>/<path to the report server url>/<path to RDLC>&rc:Parameters=Collapsed

    I got the same problem in the past when we were trying to create a Dashboard with multiple SSRS parts connected to a filter which wouldnt show up the image. We couldnt get far in fixing it but this worked like a charm for us. Infact this was much customisable through the query options in msdn (https://msdn.microsoft.com/en-us/library/ms152835.aspx) (check out the html viewer commands) . 

    You can add this URL directly to your rolecenter or as a webpart to your Sitepage and embed in the rolecenter. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans