I have developed and tested few reports using SQL Server 2000 Reproting Service. Now I want to deploy it with my Web Application Setup. Please advice how can I do that. I don't have access to remote server as it is on their local intranet. Client simply don't want us to access their machines. ...more >>

I installed Reporting Service 2000 Developer version on WinXP Pro with SP2 and SQL Server Developer with SP3. At the end of installation process, starting ReportServer service, it failed, the erroe message was: "Service 'ReportServer'(ReportServer) failed to start. Verify that you have su...more >>

I installed de trial version of SQL Server 2005 Workgroup, then created a small report using a Oracle Database. In Visual Studio the report previews fine but after being deployed to SSRS i't tells me that the data extension is not registered. Is this a trial version issue or is the Oracle su...more >>

Hello, We are trying to avoid the login pop-up when using the report viewer control from an internet facing solution. Sorry it is long, but here is the scenario. ServerA (the webserver, windows 2000 server, v1.1 framework) is serving a legacy ASP application that we have added an ASP.NET ...more >>

Hello, we defined a drillthrough action in AS to display some detail-information: If we browse a cube inside Management Studio and do a right click on a corresponding value, the defined action shows up in the context menu, so we can display a list with the details. Now we want to have the s...more >>

We are in the process of converting all of our crystal reports to ssrs 2005. We have out first report ready and wanted to go through the deployment from "dev to test" and then "test to prod". The reports are all called via a web application. A few issues. a. How do I deploy the report so...more >>

Hello! I'm collecting performance counters from few servers. They are collecting every 10 minutes. After that i need to create day-report.But when i put "processor use" on Y and time on X, on X i've got a forest of small dates. I need only fuul hours (8, 10, 12 etc). How can i do this? I;m t...more >>

hi, all I have one report like this: Students Scores For Class 1 StudentID StudentName Age Score........ ........ Average:....... Students Scores For Class 2 StudentID StudentName Age Score........ ........ Average:....... .... For this report, I need to show StudentID Stu...more >>

Hi, I want to use a table from one db and do an inner join on a table which is present in the other Db. Is it possible to do this in reporting Services? And if yes, then how? Thanks -- pmud...more >>

This is my first stab at this. I have a simple report that returns a few columns from a database no sp no expressions just a select statement. There are two tables that have the same field name and the dataset can’t seem to distinguish between them it returns the first field into both colu...more >>

Hi all. We're currently using SRS 2000 on SQL Server 2000. Is there a separate SRS2005 download, or is this a part of the SQL Server 2005 download? We want to test out the new features of SRS2005 without having to install SQL Server 2005. Marlon ...more >>

hi, I am working on some report page which will be access via URL. And I found some old reports URL look like this: .....&rs:Format=HTML4.0&rc:Parameters=false&UserID:isNull=True.... What does the UserID:IsNull=True means? Is this right format for SSRS2005? Thanks ...more >>

I created some reports in Visual Studio and the reports run fine. I deployed them with no errors, but when I try to open them up in IE, the browser automatically closes after clicking on the report. If I try to open up the reports in Firefox, they work. Any help would be greatly appreciat...more >>

I have a parameter in my SQL report which is a system account number. This account number often contains non-URL friendly characters (i.e. '<', '>', ';', ' ' , etc...). How can I create some type of substitition function to work around this issue? I reall need to pass the parameter through ...more >>

I wrote a simple function to call a stored procedure in the code tab of the report property. I did not write any custom assembly or dll. Code is below: public function Prepare(Office as integer, Dt as date) Dim oConn As New system.data.SqlClient.SqlConnection("Connection String Here") ...more >>

In SQL 2005 Reporting Services, on the page that you use to set a schedule for a subscription, there is an option to run a report once. Is there a way through the web service interface to invoke this specific schedule? Do you use the NoRecurrence object? (The options are: Hour, Day, Weekly,...more >>

I would like to create a report that would group the items by their price. For example, I would like a group for all of the items that are between 0-50 and then 51-100 (and so on). Does anyone know an easy way for doing that using Visual Studio? ANY information is appreciated. Thanks in adva...more >>

I'm new to reporting services and have a problem that I need help with. Is there a way to set Dataset priority? My problem is this. I have two datasets on my report that produce data to display. Dataset1(DS1) is a Stored procedure that returns a recordset. DS2 is also a procedure that ret...more >>

Hi, I am facing problem during passing the parameters in MDX query. I need tp pass two parameter in my dataset, but not sure whether I am writing correct query or not. as I am getting error during parsing the query. here the query SELECT { [Measures].[SAT ARR], [Measures].[SAT Warranty A...more >>

Hi, Any expert can help me on this ??? I am integrating my application with MS RS 2005 using URL access method and programatically construct the url link so that when user click on it, the report is rendered straight without asking to select parameter values . I have 4 parameters needed ...more >>

I have deployed a report which accepts a from and to date parameter, the report links to another report based upon the contents of the cell which is selected and passes the cell content and the 2 date parameters to the next report. Now this is all fine however when the date is passed to the...more >>

XP SP2 Sql2005 Developer RS2005 http://localhost/reports Produces: The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. --------------------------------------------------------...more >>

Hello, For some reason, over the last few weeks, my reports are not being emailed out. Against the reports, it reports an SMTP email error. Can somebody point me to the correct location in SQL Reporter 2003 to change the SMTP address please. Many thanks ...more >>