Hi, how can I change the line color in line charts ? Ritchie...more >>

On a Win2003 machine with a SQL 2005 server instance (SQL2005) with RS when I try to connect to Reporting Services using SSMS, I get an error "Cannot connect to MYMACHINE\SQL2005. The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)" When I try...more >>

Hi! I've used multi valued parameter in my report , and i want to show the names of some Employers in my report and i must select their names from combobox(multi value parameter), i've written a where in my dataset (where EmployerID in (@Employer)) but i have this error: [the report parame...more >>

I have a report that ties to a subreport. I can pass many parameters to that subreport template and retrieve the results. I can change the titling in the sub report on what parameters are passed (if one parameter value is passed). I created a dataset based off the parameters then simply ...more >>

Is there a series of webservice calls one could make to clean up the .RDL's on the server older than a day or is there a stored prodecure i can write like "delete from catalog where name = 'Cusomer Report'"? I can't seem to find a programmatic way of deleting RDL's but if there is a Manual wa...more >>

Hello Group, our company had a database on SQL Server 2000 Standard as the source for a Report Server 2000 Standard. Well, the source databases had to be moved to a brand new server. As it happened, the SQL Server 2000 on the new server is Enterprise. Now, the report server will not work...more >>

Hi all, I have a report which takes in a name as the parameter. When I run the report from the server manually using the name Monzón it works fine. But when that same report runs as part of a data driven subscription, the report comes out blank. The data source is a sql table. Any ideas...more >>

How do I setup multiple columns in a report? For example: How would I take a report that has 1 table with 1 column. Currently this one column is written vertically down from top to bottom over 10 pages. If I repeat the column multiple times on the same page I can cut the report down to 2 pages...more >>

I am designing a report and am getting an error when I run this calculation in the row. Here is my expression; "=iif(Fields!Hours.Value > 0 and Fields!SUM.Value > 0, Fields!SUM.Value/Fields!Hours.Value,0)" Basically, I am doing a divide calculation of two columns, but sometimes there is a...more >>

Hi guys, I have a report which need to have dotted line in the headers for example. id name -- ------ 1 2 I used TextDecoration but only underline, overline, linethrough are available. so that didn't work. I tr...more >>

Him I know a lot of people suffer this issue in the past... but in my case it's really hard to reproduce the session timeout error. everything works fine, the user can see the reports etc... this can works fine for days. and suddenly a user can receive the timeout error, and only when he tr...more >>

Hi, I have to build a report whose content is very complex and comes from multiple tables. I think the best possible way is to write custom code(assembly). Is it possible to return a data set using custom code assembly and assign it to report ? Please help. -- Thanks RK ...more >>

I have a problem with setting titles in the REPORT (not Page) header of the MRS report. The report is to be used/exported in Excel. For that reason, the ONLY way I found to be able to get titles to repeat on every page is if I make them part of the REPORT header. (This report will be used i...more >>

Has anyone successfuly renamed a SSRS 2005 server? I tried this: http://technet.microsoft.com/en-us/library/ms345235.aspx to no avail. The SSRS service is running, I just can't connect to it using MSIE (http://localhost/reports or http://localhost/reportserver) or Management Studio. ISS is up ...more >>

I have a query with a year parameter that works fine, but when I make the year a multivalued parameter, i am getting an error that reads: query execution failed for data set 'dataset1'. incorrect syntax near ",". Any ideas why it won't let me make the year a multivalued parameter?...more >>

Have trend chart with lines for monthly costs for individual assets. I need to add another line for the total each month. When I add a new Value to sum the costs, I get duplicate lines on the chart. What am I doing wrong? TIA Dean ...more >>

I'm using SQL Server Reporting Services and need to generate a report listing addresses. I have to accomodate two address lines. How can I set it up so that if there is no second address no blank line appears on the report...more >>

Cannot find the report manager. I tried starting the Report Manager from the start menu on the server and received this error "Page cannot be displayed". I then tried from the authoring comupter start menu and got the same message. I then tried to deploy a report to the site and received an...more >>

Hi! I don't know how to have check box in reporting services. ...more >>

I have made a report using Business Intelligence Development Studio in SQL2005. When I deploy that report the report server, I got the error: **************************************************************************************************************************** A connection cannot not be m...more >>

I just added a new detail row and have an enourmous amount of space in between data. How do I decrease the space? Is does not do this on other rows. Thanks, Ryan...more >>

I am building a report and would like only certain data to show in a cell. For instance I have 8 pay codes in my select statement, but would like to show just 4 of them in the detail section. I don't want to limit my select statement to just the 4 because I need the other 4 in another cell o...more >>

I have a table, single table no grouping. The table can be empty, meaning will not turn any results due to the condition in the query not being met. In the report, if the table is empty, I want the row to display something like "everything's OK". I was trying to create an Expression for a ...more >>

I'm trying to recreate something that I could do in Crystal Reports and have hit a wall with Report Designer. I want to create two (or more) header rows and two (or more) detail rows with each column width different from the column width from the row above (or below). I found how to add mor...more >>

My report has two fields that are only visible if the report is for the company "HOOSIER". so in the two fields I wonted to hide I did this: Visibility-->Hidden-->=iif(Fields!AgencyCode.Value = "HOOSIER","false","true") Why does this generate an error? The Hidden expression used in textbox...more >>

Hi, I am using a Main report page which has different subreports and depending on some data selection, I will show different sub reports. But when I am using a line diagram in a sub report, this report will show all the time. The same visible expression works fine on a sub report, which h...more >>

Can the Sql 2005 Reporting Services be used on a Sql 2000 database? I may have legacy requirements. I would like to create a data source that was based on an Sql 2000 db. Thanks, Marc...more >>

Hi, I need to change the height of a row at runtime, anyone knows how can I do it? Thanks for your help. ...more >>

I have implemented the FormsAuthentication security sample extension provided by Microsoft. It works OK and users have to log in to get access to the http://myserver/Reports pages. However when they try to run reports, they are asked to log in again for each report they wish to run. As fa...more >>

Hi, Is it possible to have report parameter of string type displayed as a text box instead of dropdown ? This will enable the user to type-in the parameter value rather than choosing one. I have one more question. Is report parameter of type String always displayed as a drop down list ? Can I...more >>

Scenario: Several hundred reports using DatasourceA. A new datasource DatasourceB is created which point to a different server. Question: How do you change all the reports to use DatasourceB without going to each report property? Can you do this with an update statement? I have zero ...more >>

SSRS 2005. When I create a report in Report Builder from a model, I can add a title to the report, but it doesn't repeat on subsequent pages. How can I get it (or something) to repeat at the top of every page? Thanks Vern...more >>

I have several hundred reports that I need to change the Datasource to point to another server. Without going one report property at a time and changing the datasource, is there a way to run an update statement on ReportServer database to use the new target server for the said reports? If runn...more >>

I have data that represents the expiration of contracts such as: Company ContractDate _________ Company1 2005-05-29 00:00:00.000 Company2 2006-02-18 00:00:00.000 Company3 2005-11-15 00:00:00.000 Company4 2005-10-06 00:00:00.000 Company5 2005-10-02 00:00:00.000 I...more >>

On my report, when a bound date field is null I get the value 1/1/0001 to print on my report and I don't know why. I am using FormatDateTime(Fields!DateField.Value,2) for short date. Thanks. David ...more >>

Very new at this. In report manager, we do not want the general user to be able to create new folders, select a new data source, upload a file or be able to see the details (which would allow them to move or delete). How do I control this? Thanks, ChrisG ...more >>

Hi, I'm looking to implement Reporting Services for the first time and have a couple quiestions, which I hope someone can answer for me. Or database is SQL Server 2000, currently with sp1. We do have a license for SQL Server 2005 but our business application does not support it yet. So...more >>

I am attempting to figure out how to provide Reporting services to users. This is my first attempt at this and I have been unable to find anything on this specifically and hope some can point me in the right direction. I have anonymous access disabled on IIS 6.0 and have enabled Integrated ...more >>

We have developed a custom asp.net 2.0 RoleProvider to Authorize access to different areas of our web app so that administrators of our application could control access rather than IT staff. The custom RoleProvider reads user and role information from a SQLServer 2005 Database. We are not u...more >>

I've got a multi-value parameter in my report that I want to compare to a field in a textbox and return a string. Using IIF(Fields!field1.value=Parameters!Parameter(0),true,false) will compare field1 to the first item in the parameter, but how can I get it to compare to any of the values in...more >>

Can't seem to figure out how to create a staggered, multi-row header and details like below. Header Last Name First Name DOB City Detail Doe John 1/1/80 San Francisco Is this possible? Thanks. ...more >>

I want to put many data regions (tables) in a report each associated with a distinct dataset. When I drag a table from the Toolbox I get a plain 3x3 grid where I have to manually enter each header, detail, and footer. This is tedious with up to 12 columns or data elements per dataset. When you...more >>

After redeployment en recreation of the SRS virtual directories and application pool. I connected via the Report Services Configuration Manager to the existing SRS database. Wthin the Report Services Configuration Manager everything looks okay and is shown as configured (green check mark). C...more >>

Hi experts I am working on sql server reporting services 2005. And i want to know one thing. I have one solution in SSRS 2005 report designer and currently i m dploying each and every report to their respective folders. But now i have to deploy all the reports again on some new server. So is t...more >>

Issue: Page breaks in the following kind of reports are ignored : Reports having matrix controls Sub-reports having conditional visibility Scenario: What happens is that if a letter has 3 pages then in report viewer it is showing all the 3 pages in 1 page itself. But it would actually ...more >>

Hi, I have a requirement in my project which specifies that when the user clicks on the drill down(or a cell), the report should show new columns which basically describes the details of the drilldown action. Is it possible to show new columns on drill down ? Currenlty Iam using Jump to Repor...more >>

We have a Small Business Server 2003 with Sql Server 2000 running Reporting Services for internal clients. Everything was working fine until earlier today. I was trying to get one of our Macintosh clients to be able to get thru our proxy server and I read a post about setting up Basic Authent...more >>

Hi everyone, Im using SSRS 2000 and I was wondering is there a way to create a click button??? I have 2 reports linked with hyperlinks but I wanted to make it look more presentable. So, instead of just clicking on the words, if I had a box that looked like a click button would be more presentabl...more >>

I'm publishing reports in PDF, providing users with URLs like http://<server>/reportserver?/<reportname>&rs:Format=PDF&rs:Command=Render In some circumstances, I'd like the PDF to open directly in the browser without a prompt, but these always ask if I want to Open or Save the file, directl...more >>

I have a stored procedure that a report uses. When I run this sp in management studio it takes about four and a half minutes to run. When I run the report, the report takes more than 15 minutes to generate. Any idea why there is such a large difference in the time it takes to run the sp vs ...more >>

Hello, I have a problem on running one particular stored procedure. It takes less than 1 second when I run this stored procedure using SQL query analyzer. However, when I run the same stored procedure using Reporting Services, it takes 3,4 minutes to execute. This stored procedure returns 5...more >>

Is there anything in the API that would support this, or would it have to be done surreptitiously in the database? Thanks, Bill Mell ...more >>

Hi, From the SSRS 2005 report manager interface we are able to export the reports to excel 2003. The same reports when we try to export with excel 2007 installed, are not getting exported. Just a blank web page pops up. Could anyone provide a solution for this? AND Do we need sql server...more >>