Profit and Loss via Reporting Services

JT

Good afternoon all (well in australia anyway),

Using Navision 4 SP3 on SQL 2005.

I have been asked to create a Profit and Loss report in Reporting Services (so that non Navision users can run this report rather than having to run via Navision).

After something like

GL Account MTD MTD Diff $ Diff% YTD YTD Diff $ Diff%
Actual Budget Actual Budget

Has anyone done this before in SQL Reporting services?

If so do you have any hints/tips and I am trying to imagine how to achieve it and coming up with blanks.

Thanks

James

kriki

[Topic moved from Navision forum to SQL General forum]