SSRS Reporting - SQL based

(0) Share

Report

Posted on by RobertDavid

Hello All,

I'm a newbie to D365FO and my organization is in the middle of implementation project for D365FO online. We are migrating from AX2009 where I have to migrate all of our existing SSRS reports that were created using SSDT.

Microsoft documentation refers to FetchXML-based SSRS reports and not T-SQL based reports for D365FO online. My staff is skilled in T-SQL and not FetchXML query design.

Question: Can I continue to create T-SQL based SSRS reports for deploying outside of D365 production environment or do I now have to re-train everyone on FetchXML querying? What are my options?

Thanks for any feedback.

Robert M.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You should use AX tools to develop reports (which stores reports in packages together with other AX code, they get deployed in deployable packages as any other AX elements, you can use AX queries, AX business logic, the framework will generate dialogs in AX for you and so on).

A brief introduction can be found in documentation under Create reporting solutions.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

If you are saying you have been creating reports which are not done via the AX report development techniques but are completely independent and stand-alone SSRS reports, the bad news is that you should stop right away with creating new ones and customizing existing ones, since you can throw them all out for the new version.

As mentioned above, there is no direct access to the D365fF&O Production databases. You have to rely on the reporting techniques offered by the platform, follow the link that Martin has provided.

Was this reply helpful? Yes No
RobertDavid on at

Like (0)

Report
Copy link

Link copied!

Thanks for the update Vilmos. Any good tutorials you care to recommend? My team has no skills in FectXML only T-SQL.

RM

Was this reply helpful? Yes No
RobertDavid on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin. It looks like my team has a long learning curve ahead since we rely heavily on querying SQL databases with T-SQL as datasets for SSRS, PowerPivot, Power Query and Power BI.

I am told by Microsoft consultants that D365FO comes with an Entity Store separate from Production database. Can we create reports against that database instead of Production?

RM

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you want to use PowerBI, use PowerBI - but your question was about SSRS.

In fact, the Entity Store is used by Microsoft exactly for PowerBI reports (and Cortana). It's an analytic database based on aggregate measurements; if you mean simply a copy of some data in another database, search for BYOD (Bring Your Own Database).

Was this reply helpful? Yes No