Report in Dynamics 365 Not showing data

(0) Share

Report

Posted on by NKS

I created a report in VS which has multiple tables. Most of the tables are generated using FetchXML. There's only one table that uses SQL statements to generate data. When I preview the report in VS, it brings up al the data. When I add the report to D365, it shows the data generated through FetchXML but not the one through SQL. Can anyone help with this please? Thanks!

I have the same question (0)

All responses (2)

Answers (0)

prt33k 6,907 on at

Like (0)

Report
Copy link

Link copied!

Are you using on-prem? Is this report hosted on the SSRS server?

Was this reply helpful? Yes No
NKS 15 on at

Like (0)

Report
Copy link

Link copied!

Yes it On premise.. it’s not hosted/deployed on the SSRS server..

If I take the table generated by SQL and add it to a new report and add the sql as data source, then upload the rdl file to d365, it brings up the data.. Just not when I use it with tables with fetchxml and upload rdl file to d365..

Was this reply helpful? Yes No