web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS chart/report when...
Microsoft Dynamics AX (Archived)

SSRS chart/report when run in AX displays no data even though the table is being populated with records from the RDP class

(0) ShareShare
ReportReport
Posted on by Kauto 2,699

Hi

Hoping someone can point me in the right direction - I've developed a new SSRS report, built the RDP class, added a table which I have set to Regular to watch data flow.  SSRS report is formatted in VS as a bar chart, when I open the design in VS and preview I can see the data coming through and the preview chart looking correct.

I have added the reporting project to the AOT and deployed the SSRS report both from the AOT and via management shell.

I have built a simply controller class to run the report, the report runs, the data table is populated with exactly the data I expect everything works except the report which displays the message NO DATA AVAILABLE with the heading of the formatted chart above it.

Can someone please help me on this as I have tried everything - other SSRS reports work fine in my environment except this one, all CIL is fine, code is compiled correctly etc etc  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,710 Moderator on at

    Try restarting SSRS service .

  • Kauto Profile Picture
    Kauto 2,699 on at

    Hi

    I tried restarting the SSRS server as well it made no difference - has anyone experienced this issue, the report is working fine in preview mode in visual studio, the data source table contains all the records I would expect, the report launches but it is like there is no link between the generating report and the datasource

  • Suggested answer
    BrandonSA Profile Picture
    BrandonSA 1,673 on at

    Hi Kauto

    One other thing I can think of is cache.

    Usually, the formula I use for absolute cache clearing is:

    -ensure system compiles without errors, and CIL is compiled properly

    -clear usage data

    -delete report from sharepoint

    -stop AOS

    -stop reporting services

    -restart AOS

    -restart reporting services

    -delete AUD files

    -redeploy report

    However, this works 99% of the time.

    About twice in my career I've had it that the no matter how much you're working on the report, it isn't writing back to the AOT. Rather, it's writing back to a cached file in your User folder.

    To check this, I'll make a random change to the report, like draw a very noticeable line across it, then I'll deploy it, and run it. If I don't see it, I know I'm looking at the wrong version of the report.

    I then have to right click on my project, open the folder that the report is stored in, delete it, and reopen the report from the AOT. I lose my changes, but then at least it starts behaving properly.

    This probably isn't your problem. But when I've tried everything with SSRS, this is the last straw I've ever had to clutch onto.

  • Kauto Profile Picture
    Kauto 2,699 on at

    Hi

    I've tried everything above and it still won't display my bar chart in the report.

    It will display the report title, I can change the text in this, add to AOT from VS, redeploy the SSRS via the AOT, run my controller class and the report will generate the data in staging, display the changed report title but won't return any data or display the chart.

    I actually deleted the report in VS and recreated it from scratch with the same behaviour - I am badly stuck here.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans