We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

110141 Jul 21,2013 07:10 PM UTC Dec 1,2014 03:33 PM UTC WinRT 7
loading
Tags: SfReportViewer
noor
Asked On July 21, 2013 07:10 PM UTC

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 [Syncfusion]
Replied On July 23, 2013 09:43 AM UTC

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
Replied On July 25, 2013 06:43 AM UTC

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 [Syncfusion]
Replied On July 25, 2013 07:33 AM UTC

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
Replied On July 25, 2013 10:48 AM UTC

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 [Syncfusion]
Replied On July 25, 2013 12:08 PM UTC

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
Replied On November 27, 2014 08:56 AM UTC

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 [Syncfusion]
Replied On December 1, 2014 03:33 PM UTC

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;