SQL Server Reporting Services and NAV

gadzilla1

Hello,

I was wondering if anyone out there has any tips, dos/don'ts regarding using SQL Server Reprting Services and NAV together.

Also, I was searching for some sample SQL Server Reporting Services reports for NAV and could not find them. Does anyone have a link?

Thanks and have a great day!

gad1

kine

Link is e.g. there:
http://blogs.msdn.com/clausba/archive/2 ... 67113.aspx

kriki

[Topic moved from Navision forum to SQL General forum]

defiant701

Hi,

the samples are based on direct access to NAV tables/views. If you have more than one database(e.g differnt localized versions) with variant setup you should use a staging area between (use SSIS projects) and make your own ETL workflow.

Also from my experience I could say that it is better to create and use views instead of tables, otherwise your SQL statements might be tricky.

BR
defiant701

gadzilla1

Thanks everyone for the posts! I will take all advice into account moving forward.

Have a great day. gad1