Reporting sevices of Nav 2009 is On Web

pravin_crystal

Hello Friends,

I want to use reports in my website. I know reporting services of SQL Server and Navision RTC but I want to use RTC reports those are already designed by the Microsoft.

I am able to view the designed the report design in Visual Studio but I am not able to view this report into my own website using the MicrosoftReportViewer control.

Kindly give me solution.
Clearly tell me whether I am on the correct track or not.
And what are the other ways to display(RTC reports) into browser and how?


Regards,
Pravin

apanko

pravin_crystal wrote:

And what are the other ways to display(RTC reports) into browser and how?

http://blogs.msdn.com/nav-reporting/arc ... rvice.aspx

kine

As you can see, reports in RTC are not reports which are created through SQL Reporting Services. RTC is only using client side rendered reports based on Reporting Services definition, but it is nothing connected to SQL Reporting Services. The way how to display the data is through PDF and webservices as drescribed on the MSDN.

generic

This is what I'm thinking. NAV report contains the RDL. The datasource is an xml file.
You could write a sql statement that would generate the XML File. I believe in RTC when you run the report you can hit Ctrl+Shif+F12 to see the source xml structure.

So if those two things are provided to reporting services, the data source and the RDL, reporting services could be used to run the reports.
It won't run the business logic.

I know I'm simplifying this.

kine

NAV contains RDLC (C as Client) - it means it is some subset of RDL.

Biggest problem is the part

It won't run the business logic

because the business logic generates the XML with data... and to simulate this, best is to run the report through WebService... 8)

generic

Can you pass filters from a record into webservice so that a report can print based on filters?

pravin_crystal

Yes ,

I would like to generate report that works same as RTC report which is having parameters for filtration.


Regards,
Pravin

clausl

You are running the code from a codeunit, and can therefore use all the AL you would like.

Simple example:

AL Codeunit function:
PrintReportWebService(Text[50] customerNo)

begin
rec.SetFilter(No, customerNo);
Report.SaveAsPdf(111,'c:\somewhere.pdf', rec);
// and all the other stuff you need
end;

Regards,
Claus