web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Old Nav SSRS on SQL vi...

Small and medium business | Business Central, N...

Suggested Answer

Old Nav SSRS on SQL view - recreate in Business Central SaaS

(0) Share

Report

Report

Posted on by kjjson

We have helped a client migrate from a very old version of Nav to Business Central online. They have a very complex report that was built in SSRS based on a complex SQL view that was built years ago. Is there a best way to go about re-creating that type of report in Business Central? I have the SQL view that the report is built from. Would it be best to build this report into Power BI, and is it necessary to build a query in AL and then expose it as a web service, or can someone give me a direction to go?

Thanks,

Kevin

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 152 on at

Like (0)

Report
Copy link

Link copied!

I think you’ve mentioned a number of good points worthy of serious consideration. To add to the mix this blog could be helpful: demiliani.com/.../

If the SQL view is heavy on performance for instance off setting it to another DB may help long term performance.

Comments on query object performance: docs.microsoft.com/.../optimize-sql-query-objects-and-performance

If you can convert the sql view to a query object you can then build a report off of the query: thinkaboutit.be/.../

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,005 Super User 2026 Season 1

#2

YUN ZHU 1,148 Super User 2026 Season 1

#3

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans