Using SQL RS 2000 My report runs fine in the designer but when deployed to the server it will only display the first page. When move to page 2 or the last page it gives the error: "An unexpected error occurred in Report Processing. (rsUnexpectedError) " Also, the report calls a subreport ...more >>

I have a report with 3 parameters (Run Date, Branch, and Account Manager #). We are using this report to show 3 different views (Corporate, Branch, and Account Manager) and want to hide/disable the parameters that are not required. If the user wants to view the Corporate View, only the Run D...more >>

here is what i did, from either Report Manager or SQL Server Management Studio i created a folder, then i move the reports to this folder, but from Microsoft Visual Studio, as long as i deploy the project, it still save my moved reports outside of the folder i created. i wonder how do i let the ...more >>

Can I place the same report in two folders, but only have one report in the SQL database? So I only have to upload one....more >>

What is the function to check if a string is inside another string? Thanks! For example: string to search for is "test" string to be searched is "this is a test" the return value should be true because "test" is in "this is a test". ...more >>

I'm creating a report using an MDX query. The query looks similar to this SELECT { [Measures].[Act], [Measures].[PL] } ON COLUMNS, { [Product].[BU Product Cat].[Product1], [Product].[BU Product Cat].[Product2] } ON ROWS FROM [Cube] The result I get in RS is: [Measures].[Act] [...more >>

I've got this iif statement =iif(Fields!Month.Value =13,"YTD",MonthName(Fields!Month.Value)) in a matrix header field that has the month numbers in it. it will display ytd if i drop the month name function but with the monthname in it throws an error. Also theres a warning that says [rs...more >>

Is Report Manager designed to be accessed over the Internet, and if so, is there a forms based login that can be enabled? -- Chris, SSSI...more >>

I want to make certain parameters in my report multi-valued; however, for some of those parameters, possible values include commas, as such: Value 1: a,b,c Value 2: 1,2,3 Reporting Services uses a comma as the delimiter, so the parameter list that gets passed into the stored procedure is...more >>

Can I save a report file (.rdl) from SQL 2005 report services to be compatible with a SQL 2000 report server? I'm currently having problems, file will not upload and my admin is telling me it a version problem. The report definition is not valid. Please verify that the report definition ...more >>

I moved a couple reports that have multiple pie charts from Crystal to RS...The problem is the text in the Category groups is extremely long and needs to be seen in its entirety through the use of labels. I can't figure out a way to wrap the text so that you can read the entire thing...even a w...more >>

I setup Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service identity, Web service identity, database setup, they all working fine. When I click on [Inititialization] I get this error ------------------------------------------------------------------------------...more >>

I'm very new to Reporting Services, but I'm hoping I can get a pointer in the right direction here. I have MOM 2005 generating performance statistics that I can view and subscribe to via RS 2000 IIS website. When I'm setting up a subscription, I have the option of specifying the Begin Date and E...more >>

Hello, I have a version of SQL2000 Developer Edition installed on my box. Now I need to install the RS2000 Developer Edition, but I can't find it anywhere on MS site. (It is supposed to be free). I found the Evaluation Version which I installed, but I have to know how I can get the Develope...more >>

All, I am a newbie and in working on an existing report, I inadvertantly deleted the only detail row. I was able to get the report working, but I had to use a group header as a detail row (fortunately I had a unique value column), because I could not see how to add a detail row. MS is very ...more >>

i am using SQLserver2005, after i deployed the project, from http://localhost/reports i can see everything, but for the other user they see only "home" title, i created user role for browse, is there anything missing from my steps? ...more >>

When running a data driven subscription, the status column reported "X number of records processed: X errors" I've checked every log I know to find details on the errors to no avail. Does anyone know where they are? -- John Shahan...more >>

I'd like to create a report parameter to allow the user to enter only a partial field using wildcard(s) in SRS. The list is lengthy and the user does not always know the full name to enter. Is this possible? Thanks, Karen...more >>

Hi, I've converted a serie of reports from 2000 to 2005 and in the process, the border around the body of the report isin't displayed anymore in the html (if I export to PDF, I can see my border). I've tried to reconfigure it but that didn't work either. If I create a new report with ju...more >>

I installed SSRS 2005 on Vista Beta 2 build 5384 and when I try to browse to the /Reports folder, I get the following error: Access to the path 'Global\CLR_RESERVED_MUTEX_NAME' is denied. Any Ideas?...more >>

I'm setting up a new computer and first installed SQL 2k, VS2003 and SSRS 2K. Everything is OK so far. Then I installed VS 2005, and then SQL 05 and SSRS 05. I created a new Named Instance (since the 2K instance is the default one) called MSSQL05. Everything seemed to install OK in the new...more >>