I have a .net application already that does quite a bit of reporting and I'd like to incorporate RS into it. Currently, I have a DetailReport.aspx page that displays results using Office Web Components. I'd like to replace this page with reports from RS. When I try to view reports using...more >>

I'm very new to Reporting Services, so I have a basic question. Once I have designed a report in Report Designer (generated an RDL file), without deploying it to the Report Server, is it possible to view this report somehow given this RDL file alone? ...more >>

I hope someone can answer my question. I'm wondering is there a way in RS to put group items in a specific order. For example, I have a field I group on and the items are A/B/C/D/E but I want to see the items in this order D/A/C/B/E. I was able to do this in Crystal Reports and was hoping I...more >>

Hi, We've a RS separated in two machines (Services and Databases). This database was moved tho a new blade server with Win2003 Server and MS SQL Server 2000 Standard and now whe need to move RS to this machine. Move database its easy... but not the services. We try to install it, but s...more >>

Hi Everyone, I'm having an issue with a row of data missing when exporting to CSV. The report structure is as follows: Group 1 Header - Grouping on State (Displays the State) Group 2 Header - Grouping on Customer ID (Displays a summary for each customer) Detail Row - <This Row has Been R...more >>

I'm trying to install RS in a server but show me this message: A database with the specified name (ReportServer) already exists and is not a valid report server database. You must either remove the existing database or select a new database name. What i should do??? Thanks. -- Carlos...more >>

Hi, how can i set the width of a textbox dynamically ? Ex: The text box has to expand in width to fit the availble data. It shouldnt word wrap. ex: hello how are you NOT hello how are you...more >>

I've had good luck with driving reports with cascading parameters and parameters with defaults. So far though, I've been unable to combine these concepts. Using the example mentioned in BOL, I'd like to have a division parameter choice drive a department parameter dropdown. When the depar...more >>

Does sql 2005 reporting services still require you to host reports off IIS? Or can you embed them into an app similar to crystal reports? For instance, i need a reporting service that works disconnected. I'm planning on making an application that uses a locally stored sql server express 20...more >>

For report design, either Visual Studio .net or Visual Basic .net is required. Since one costs much more than the other why would I buy Visual Studio and not Visual Basic is I only need it for SQL Reporting Services? - Max...more >>

hi, How can i change the color property of the line in the line chart. For bar charts and all i go to series style and change it. but for line chart, default comes to green - and i would like to change it to red. thanks ...more >>

Hello world, I have some reports that run fine when I use the "Render this report with the most recent data" selected, but when I want to create a Snapshot it fails to produce a snapshot. It also depends on how much data I select via the parameters. If I want a small result set it works, but i...more >>

I'm using SSRS sp2 and have a report which has a table which spans the width of the report. I set the 'KeepTogether' property on this table to True, but I have detail rows from this table spanning 2 pages. I thought this prop would keep them together and force a pagebreak before. There's on...more >>

I know that at the server level you can suppress the export types that appear in the export format list control when a report is rendered. Some of my reports need to only display a subset of the server defined export types. An example would probably best help in my issue... I need to display...more >>

I am using Sql reporting services 2005 April ctp. How to report neatly the deeply nested xml structure? Unable to find any samples to generate report directly from xml or dataset. Is there any provision given for this in sql reporting services 2005?...more >>

I am trying to create a simple chart that displays just the data points and "hide" the line. Scatter chart does not appear to be the right choice for this. Is there a way to create a line chart and then hide the line so that only the data points themselves are visible? JH...more >>

Hi all, I have a report which has a column on which font color is defined with expression to show red if it's negative and Black if positive. This expression is also defined on several other columns. When I export to excel, this one column just turns red, with all cell fonts are red whether...more >>

Hi, I looked at SQLRS a while ago and liked it but never had a use for it. I'd now like to use it again and so have completely reinstalled a Win2K test server with SQL2K Standard Edition, works ok, have other dbs on it. Setup IIS, works ok, accesses dbs in SQL2K. Installed Reporting Services ...more >>

I am looking to export data into a .csv file and have it exported based on subscription details. I have successfully been able to perform the above, the issue is that it is being exported in Unicode instead of ASCII, I know how to specify ASCII by placing &rs:Command=Render&rs:Format=CSV&rc...more >>

Hi, Anyone know how I can make reports render properly using Firefox? When I look at reports, they are all squashed up in side a 4 cm tall iframe. TIA TonyG...more >>

Hi there, I want to create a "big report" including a lot of subreports.. but I want the user can select the reports to show in the "big report" from a list of existing reports (generally graphs reports). Each user of the application will have his "big report" configurated as he want, and the ...more >>

Hi , I can't find a possible way of doing this at present If I have a Table element containing 3 columns, how can I get it to display the following way? Is it possible? If I get 10 rows, I want 5 rows in each of the following. If there are say 7 rows, I'd want 4 ros on the left and 3 ro...more >>