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

(0) Share

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 (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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