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

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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)
  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    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/.../

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 686 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 447 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans