.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

I need syntax help going from a URL to a Report Service Report

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Here is the syntaxt I have tried.  It takes me to the Root folder page on the server,  how do I get to the report itself from an html link http://server.net/SSRS_Reports?/Folder1/Folder2/ReportName&rs:Command=Render&rc:LinkTarget=blank Thanks Dave  

View Complete Post

More Related Resource Links

Include a Crystal Report in .NET Web Service for Dynamic In-Memory-Only DataSet



I would like to use Crystal Reports in a .NET web service.  Ultimately I would like to convert my report document to a PDF and then return the PDF as a byte array. 

My .NET DataSet is generated dynamically at run-time.  It consists of four related tables.  Since my DataSet does not have a physical datasource, I created an XML Schema file.  I then added the XML Schema file to the web service project with Add Existing Item. 

A solution for working with a dynamic in-memory DataSet exists for ASP.NET web sites and client-based forms.  I tried to use this method as it is published.  When that didn't work I tried creating the report and XML Schema directly in the web service project, but that also didn't work.


The problem is apparent when you try to set the datasource.......the code bombs on the call to SetDataSource(DataSet) with the message
ex = {"The data source object is invalid."}

Crystal Reports would save me a lot

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

Issues in GetItemDataSources web service call in 2008 Report Server R2

Hi, I'm using Reporting Services web services endpoint ReportService2005.asmx with 2008 report server R2 and I'm facing some issues in getting the data source names for a report definition using the GetItemDataSources web service. The problem is that the data source names returned are different from the names of the actual data sources on the report server. The report has the following data sources: 0 1 _0 _A Data Source And the names returned by the GetItemDataSources for 2008 report server R2 is: AutoGen_0 AutoGen_1 AutoGen__0 AutoGen__A Data_Source When I make the same calls using a 2005 report server, the names returned are the same as that in the report definition. To summarize, only numeric data source names are changed to "Autogen_<number>"(eg. Autogen_0), data source names beginning with "_" are changed to "Autogen_<data source name>"(eg. AutoGen__A)  and spaces are replaced by an "_".   What is the problem for the data source names returned for 2008 report server R2? Or has there been any change in the way in which report server stores the data source names? Thanks, Kulbhushan Singhal.  

Report Manager Security: If a user login to Report Service than he should be able to see only a fold

Report Manager Security: If a user login to Report Service than he should be able to see only a folder for which he has role assing and rest of the folder should be hidden for him. How this security i can achive with c#

Report Service Design Questions


Hey all,

after 3 weeks working with SQL and RS i'm done.

Now i've got some problems with the design..


my first question;

There are several pages saved in a PDF, and I've created a header. Now I need to get an issue where the header only is viewed on the first page. But if I select in properties "Print options" it works only for the first and last page but i need it also between.


my second question;

In my report is a tablix where i need "break page". But if i select "start" or "start and end" it display the first page without the tablix (header and footer displayed) and if select "end" it wont work.


my third question;

I need to show another Tablix on every page. how can i do that?


Regards Patrick

One who can read, have a clear advantage!

Error in initialization of the report service


I installed the evaluation version of SQL Server 2005 to my Windows XP machine. Everything has worked well. Now I have problem. I installed the reporting service to test the web reporting.

In the Report service configuration manager  I get three errors:

The Web Services Identity indicator is red and pushing Apply button gives the error:ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B

Pushing Initialization button gives the message: There was an error while switching panels. The most likely cause is an error retriewing WMI properties. the exeception details are: An error occured when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running and then try the operation. Execption 800706B3.

Server Status Indicator is also red. Pushing the Start Button gives the following message: System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess. ServiceController. WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

SQL Report Service List data into columns



I showing my data in Report builder in LIST control. e.g I have 3 fields to show data in field (Name, Country, Age). currently its show data in one column I want to break data into newsletter column style.Is their any option in list two show data columns wise also

Currently:                                             but I want show data in Newsletter-style columns Like

-----------page---------------                     ------------------------------------page------------------------------

name,country,age                                     name,country,age                        name,country,age

-----------page---------------                 &n

Valid Credentials for Report Execution Web Service


I've had an application running for some time which accesses reports via the reportingservices web service.   Recently I had a request to directly stream the reports for download rather than viewing them through the report viewer.  I facillitated this using the reportexecutionservice web service and in testing, everything went fine.  When deployed however, the downloads mysteriously failed to occur.

The issue traced to a 401 unauthorized error, which implies my network credentials were rejected.   Easy, right?  Well, the problem I'm having is that I'm using the same credentials for both the reportingservices web service and the reportexecutionservice web service and I had expected that what was sufficient for one was sufficient for the other. 

The credentials I'm passing are for a user which is a member of the SQLServerReportServerUser group on the machine hosting the web service.  Is this insufficient to run the reportexecutionservice, and if so, what do I need to do to adjust the security permissions of this user to grant them access to reportexecutionservice?

Generating SSRS report by taking data both from sql server and web service.



In my report, i need join data from both sql server and web service and display that on ssrs report.

is this possible in ssrs ?


Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



How can you debug a report data source that is an XML web service?


I have a report that is using an XML web service as it's datasource.  I would like to know what parameter 

values the report is passing to the web service. 

I tried the following debugging process but it did not work.

1.  Set the Reporting Services Project as the Starting Project.

2.  Set the report as the startitem in the project's startitem property.

3.  Set a breakpoint in the web service.

4.  I started the debugging which opened the report.  I put in a parameter value and ran the report.

But the debugger did not stop at the breakpoint.  What am I doing wrong?

How can I know what parameter values are being passed to the web service?





Trying to make a SQL Server Reporting Service 2008 report public for basic users


Hey.  I'm somewhat new to SSRS 2008 and I've built two datasources connecting to "HumanResources" and "HumanResourcesDev5" databases on a single server.  Both of those datasources have been changed from a Windows NT login clone to a preset login for a temp account that we have for testing called "Test2".  I have opened my created datasets and verified that when they open they ask for the password for the new credentials that I have set for the datasources.  After verifying this and the connection I re-opened the reports that I made within Report Builder (not Report Designer a VS extension) and verified all of the dataset and datasource information.  These reports and report parts get saved to the http://localhost/Reports folder within the server.  I have published the report parts to the /Report Parts folder within the localhost. 

This is where I begin to have issues...

When someone uses the reports that I have generated through report builder and link to them on our sharepoint site when a person without an actual account on the SQL server tries to view them they cannot because they do not have sufficient permissions.  And what I noticed is that it still tries to use their Windows NT credentials rather than the temp account (Test2) that we have created which is why they

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend