SfReportViewer to render SSRS reports. what value should go to ReportServerUrl ReportServiceURL parameters

[noor]

Hi,
I have been trying ReportViewer control to render SSRS report.
I am following the code sample for this
there is one line i don't get
 timer = new DispatcherTimer();
                    timer.Interval = new TimeSpan(0, 0, 10);
                    timer.Tick += timer_Tick;
                    this.reportViewer.ReportPath = @"/SSRSSamples/Territory Sales";
                    this.reportViewer.ReportServerUrl = @"http://76.74.153.81/ReportServer";
                    this.reportViewer.ReportServiceURL = @"http://ssrs.syncfusion.com/ReportSampleService/ReportingService.svc";
                    this.reportViewer.ProcessingMode = ProcessingMode.Remote;
                    this.reportViewer.ReportServerCredential = new System.Net.NetworkCredential("ssrs", "RDLReport1");
                    this.reportViewer.RefreshReport();
                    timer.Start();
                    this.reportViewer.RenderingBegin += reportViewer_RenderingBegin;
                    this.reportViewer.RenderingCompleted += reportViewer_RenderingCompleted;

                    this.reportViewer.ReportLoaded += (sen, arg) =>
                    {
                        List<DataSourceCredentials> crdentials = new List<DataSourceCredentials>();

                        foreach (var dataSource in reportViewer.GetDataSources())
                        {
                            DataSourceCredentials credn = new DataSourceCredentials();
                            credn.Name = dataSource.Name;
                            credn.UserId = "ssrs1";
                            credn.Password = "RDLReport1";
                            crdentials.Add(credn);
                        }

                        this.reportViewer.SetDataSourceCredentials(crdentials);

ReportServerUrl  is obvious no doubt in it
what value should i pass to ReportServiceURL.
do i need to write some sort of wcf service for this.
It would be better if you reply me with some more clearer sample.

[Ragavan G]

Hi  Noor,

 

Thanks for your interest in syncfusion products .

 

Questions :        

 

what value should i pass to ReportServiceURL.
do i need to write some sort of wcf service for this.

 

 Answer :

 

 If you are using RDL report ReportingService needed for retrieve the data source and export the Reports. For RDLC reports ReportingService needed for exporting functionality alone.  Because we have to do some image related process with visual tree to export few ReportItem elements, but that is not supported in this platform itself.

 

We have deployed the Service project in our Samples Server and find the URL in following code snippet.

 

this.reportViewer.ReportServiceURL = @”http://ssrs.syncfusion.com/ReportSampleService/ReportingService.svc”;

 

We have created sample WCF application for your requirement . Please find from following location

 

Location : http://www.syncfusion.com/uploads/user/directTrac/110599/ReportingServiceApplication-817847897.zip

 

 

Also Please refer following online documentation to create Syncfusion ReportService.

 

http://help.syncfusion.com/UG/winrt/default.htm#!Documents/gettingstarted27.htm

 

Please let me know if you have any questions .

 

Thanks ,

Ragavan

[noor]

Hi Raghavan,

thanks for the reply, one more doubt where do i need to host this service, iam trying to fetch SSRS reports, so do i need to publish and host this service to machine where i have my sqlserver installed. Iam still confused how this works under the hood

thanks
-noor

[Ragavan G]

Hi Noor ,

 

Thanks for tour patience .

 

You can publish the service in your local machine and you can use it , Not needed to deploy in SQL Server machine .

 

Thanks ,

Ragavan G

[noor]

Hi Ragavan,

I have my service running on local machine but unable to render the report.
Attached you can find the xaml file and its code behind.
Iam unable to figure out where iam going wrong
can you plz get me through this.

thanks
-noor

Performance Reports_f749be79.zip

[Ragavan G]

Hi Noor,

 

Thanks for your patience .

 

This issue may cause due to sending large amount of data to service . Make sure enabled large amount in your WCF service application .

 

Please refer this online document for this section “How to send large amount of data in WCF service .”

http://help.syncfusion.com/UG/winrt/default.htm#!Documents/howto1.htm

 

If still face any issue we request to create incident in  DirectTrac  and follwup your queries .

 

Thanks ,

Ragavan G

[Chong Yee Mei]

Hi  Noor,

 

Thanks for your interest in syncfusion products .

 

Questions :        

 

what value should i pass to ReportServiceURL.
do i need to write some sort of wcf service for this.

 

 Answer :

 

 If you are using RDL report ReportingService needed for retrieve the data source and export the Reports. For RDLC reports ReportingService needed for exporting functionality alone.  Because we have to do some image related process with visual tree to export few ReportItem elements, but that is not supported in this platform itself.

 

We have deployed the Service project in our Samples Server and find the URL in following code snippet.

 

this.reportViewer.ReportServiceURL = @”http://ssrs.syncfusion.com/ReportSampleService/ReportingService.svc”;

 

We have created sample WCF application for your requirement . Please find from following location

 

Location : http://www.syncfusion.com/uploads/user/directTrac/110599/ReportingServiceApplication-817847897.zip

 

 

Also Please refer following online documentation to create Syncfusion ReportService.

 

http://help.syncfusion.com/UG/winrt/default.htm#!Documents/gettingstarted27.htm

 

Please let me know if you have any questions .

 

Thanks ,

Ragavan

Hi,

I too have the same issue. How do I know what is contained in the Service? I tried downloading from the link Ragavan provided, but only to get the usual "Access Denied". Help!

[Anandakumar S]

Hi Chong,

Sorry about the inconvenience caused.

We have prepared a WCF ReportingService application and uploaded the same for your reference. It can be downloaded from the following location.

http://www.syncfusion.com/downloads/support/directtrac/128616/ReportingService-103750469.zip

Please let me  know if you have any questions.

Regards,

Anandakumar S