Just installed SP1 last night. Today I don't have a "Select All" option anymore. Anyone else notice this and or have a way to make it so I can have a "select all" option on multi-value parameters? Bug or decision to decrease functionality? Thanks! Benjamin Chan...more >>

Hi I am getting some results from stored procedure. Name Value1 Value2 Value3 Total North 1 2 3 6 North 4 5 6 15 South 5 ...more >>

I'm deploying some reports to a customer box and am having some quirks in getting the right permissions to the data source. Instead of going into detail about my specific problem (which I don't think I can even give a good description of since I can't see what groups the accounts I'm using are m...more >>

Just some info here. I created a very simple report against a stored procedure. The sp ran in about 1 second in SS Management Studio. When running the report it took at least 30 seconds. When I went back to the Data Tab and ran the procedure, it also ran for what seemed to be at least 30 ...more >>

I have a report that has many columns. When the report is fully expanded you can see all 75 columns. When I run the report in the report viewer the report is a total of 8 pages. When I export to .pdf the report is 45 pages long with over 30 blank pages. Is there anything I can do to get it...more >>

I have a simple matrix that uses the group visibility based on toggle. when hidden, the data is not visible but the group row is. how does one suppress the group row when its data is hidden? currently, there is a great deal of white space on this report when all groups are hidden....more >>

I have a report using a single table. I set the table border to solid for left, right, top and bottom. Currently the report is printing in 2 pages. On the first page the table doesn't show the bottom border. It does show on the second page. I'm guessing is only placing the bottom border at the...more >>

I want to know if this is possible. I have a Matrix that could have 5 to 100 columns in it. Each column will have 5 rows. A B C D E F G H 1 X X X X X X X X 2 X X X X X X X X 3 X X X X X X X X 4 X ...more >>

hi, Is it possible to programmatically set default parameter to a report while deploying it or after deploying it. It is possible to set it using report manager web application. But I want to set it programmatically, preferably while deploying the reports. Please help, regards, SAchin ...more >>

Hi, In reporting services 2000 we had provision to pass report parameters to Render Stream method. Now i am not able to do this in Render Stream method of report execution api in RS 2005. I need to get the stream in the form of html based on the parameters passed (e.g;in RS 2000 i used to do ...more >>

I am trying to add a second data set to a report to drive a dopdown for a selection parameter. The parameter is for user id to filter the report. I have done this many times on other reprots with no problem - that is why it is so frustrating :( After adding the dataset I can execute it just...more >>

Hi everyone! I'm trying to get my Reporting Services reports to display in a sharepoint site. Sharepoint and reporting services are set up on two different computers. When I set up the rs explorer web part, it just displays "Retrieving data..." and nothing happens. In the rs report view we...more >>

Hi, I have a requirement where in I need to render a report from a query that returns about 1,500,000 odd records. The report is a simple tabular report. SSRS 2005 fails. The same report is generated easily by Crystal report. How do I get the SSRS to generate the report ? Kind Regar...more >>

I must make many report in my project. All the reports must have header of company name and footer of page number. Can I desgin a template custom report, then all reports in my project are inherited from it? ...more >>

I use the new feature of VS2005 to develp LocalReport. I have set the DisplayName of a LocalReport like this: ReportViewer1.LocalReport.DisplayName = sDisplayName; It will change the top node of the Document Map. How can I bring the DisplayName into the report, for example I want t...more >>

I am getting the following error: Error 2 An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server. C:\Documents and Settings\Administrator.WILLCARE\My Documents\Visual Studio 2005\Projects\Willcare\Willcare\Report2.rdl 0 0 I am trying to des...more >>

Hi, I have problem with &rs:Parameters=false it's not working if reports in a iframe; same url working well on a normal page; any trick? here is my url: http://localhost/ReportServer?/BASE/Opened Incidents By Severity - Chart and Graph&rs%3aCommand=Render&rs%3aformat=HTML4.0&rc%3aParameters=...more >>

I have a report that I show a bill of material based on a selected parent. I have about 17,000 parents to select from. When I use "available values from query" the current behavior on the report is a drop down box where I can choose between all 17,000 where at least for large collections I'd...more >>

I have RS2k on SQL2k for several months with no issues, all users can access reports for which they have been granted access. I have one new user lately that has not been able to access a report that he has been granted access to. He clicks the link to the report server http://servername.d...more >>

Hi I am having 2 Tables and 2 Datasets in the report and depending up on the Report parameter value either of the dataset should execute and the data should be displayed in the related tables and other table should not be seen. Is it possible to do in this way??? Thanks ...more >>

We are starting to have a lot of reporting services servers : MOM, CRM, Project Server. I was wondering if I could use a single Reporting Server to host all my product instead of having 3 reporting server. Thanks for any help. Jean-Philippe ...more >>

Hello, I use render() method to generate and write reports to MHTML rendering extension. When report generating time is more than ~100 seconds the exception appears ( I write this exception to the event log) try { result = rs.Render(…..); } catch (Exception e) { e...more >>

To my horror I have discovered that you can not specify a provdier that is anything other than SQL Data Provider in a report model project. Here's my problem. I'd like to provide one set of models for my schema and be able to dynamically change the connection string using a DPE that we have de...more >>

Hi We are facing following issue in SQL Server Reporting Service 2000. We are generating report in excel format using reporting service. We are unable to format the column width and height based on the content. We tried couple of option like CanDraw and CanShrink, but it did not work. We ...more >>

I just setup a new dev machine and am running sql 2k + ssrs, VS2003, sql 05+ ssrs and VS 2005. I hae a VS2003 SSRS Project and it builds fine on the old PC. SSRS 2k appears to run fine on the new maching, but when I go into this VS2003 project (it was copied from the old machine) and build i...more >>

Has anybody managed to get Overlapping Report Items to display properly in Internet Explorer or some other browser? (Ignoring Microsoft's statement that overlapping items are not supported in HTML) Extensions or additions to the Rendering Extension, or any other suggestions would be welcome. ...more >>

Is that possible to do that?? Coz I use BSM to export a scorecard to RS and It becomes 2 seperate dataset. I just wanna know if it's possible to combine those 2 dataset easily?/ thanks ...more >>

Hi, In SQL server, I can use select dateadd(d, -1, getdate() ). How to do in reporting ? i.e. correct statement for dateadd(d, -1, Parameters!FromDate.Value) Thank You! Tony...more >>

Hi, I get the following error: a.. The path of the item '/StatistiekenSites/Sites_BezPerSitePerJPerM_I&year=2006&site=/sites/FTP/Site+Pictures' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for ...more >>

Hey, I've got a problem - got Start and End date parameters in my report and on my dev box they show up in Australian format as it should be but on the production server it's in American format! What do I do? I don't really want to try setting dates as strings... Installed SP2, it had no effe...more >>

How do I pass the report dataset to functions in my custom assembly? I have a function which generates a dynamic image base on some data and I would like to pass the dataset of the report to the function. /Sune ...more >>

Is it possible to create an mdx query using parameters? For example, in a SQL query I'm using in Reporting services, I might do this: SELECT * FROM dtav_ServiceFacts WHERE ServiceInstanceHost = 'BizTalkServerApplication' AND ServiceInstanceState = @state And then SQL...more >>

Hi, I am having trouble using groups within list region. My list is working as is but I want it to be displayed for each group and a group within a group. But I am having trouble defining the group. There is a "group on" field and on the left side pane it list Constants, Globals, Parameters...more >>

Hi. IM trying to send a scheduled excel report to some emails but when he runs it tells me that the emails are not valid.. Any help? i can put any email? Thanks ...more >>

I notice that the charts included in the reports run via Management Studio (e.g. the Data Files Space Usage pie charts) look considerably better than the ones I put in a Report Server report. The charts I've used, e.g. an exploding pie (3d) look very jagged, including all text, whereas in t...more >>

where is the export to rtf as promised on the microsoft reporting services 2005 site?...more >>

If you format a number in SRS to a percentage using P0 format then export to excel it left aligns the percentage and reads it as text. Is there anyway to export to excel and it automatically reads it correctly as a percentage? ...more >>

Ha...please any help..why "=" don't work.!!!!!!!!!!!!!!!!!!!!!!!! -----------------The expression =IIF(First(Fields!customer_id.Value, "customer_list") = "BBY", "BBY", "Other") ------------------------- (First(Fields!customer_id.Value, "customer_list") is "BBY", but textbox always show "...more >>

I am trying to use conditional expressions within a report field to change the background color depending on the value of one of the fields in the report. Within the properties for one of the report items, I click the background color item and then choose the expressions and that brings up ...more >>

Is there a way to share the dataset with the other reports once it was created in once of the reports in the same project? Right now, we are copying the same dataset from one to the others... Brian...more >>

I have a data-driven subscriptions that runs to render over 7000 reports to TIFF format on a file share. These reports are then compiled into larger sets for printing and delivery. My question is - once I get this DDS started, how do I stop it should there be a need (such as data source no...more >>

Hi, I am facing a problem using temporary tables in SQL Server stored procedures when using them in SQL Server Reporting Services. It gives an error while fetching fields when creating a dataset in report designer of MS Visual Studio.Net 2005. Has anybody else faced the same problem? R...more >>

Hi All, I have a report with two parameters. Date1 and date2 and both are of type datetime. when I select a date greater than 12/05/2006 the report fails stating "the value provided for the report parameter Date2 is not valid for its type". Now date1 has 01/05/2006 and date2 has 31/05/20...more >>

I'm looking for a good, focused Reporting Services 2005 training course to take that will teach my coworkers and me the finer points of how to fully utilize RS2k5 to deploy robust, informative, interactive reports for our customers. I have a little experience with RS2000, but my coworkers have...more >>

How can I resolve the matter of not being able to save a report using Report Builder? ERROR: The permissions granted to user REPORTSERV\ittemp are insufficient for performing this operation...more >>

RS2005 I have a legend that I designed which has 11 textboxes surrounded (enclosed) within a rectangle that I use on reports for documentation purposes. It renders perfectly fine in preview and exports to pdf fine but it is not rendering on the server correctly and that is not acceptable to ...more >>

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) " The RS log shows it to be failing her...more >>

I am using the following format to display a percentage: ##.##%;(##.##%);"-" It works fine for numbers like 15.34% but when the percent is a whole number like 4% it does not display 4.00%. Can anyone help me with this format? Thanks in Advance OS...more >>

I am thinking of switching my current method of creating invoices to sqlserver's Reporting Services. I'd like to hear for those of you who are using Reporting Services for this purpose. Please tell me of your experiences. -- thanks (as always) some day i''m gona pay this forum back for a...more >>

Hello, I would appreciate if someone can advice me: We are planning to migrate from Reporting Services 2000 (on old server) to new server with RS2005. There are a lot of reports, few datasources and very complex security on folder and report levels. As I understood all reports should be ...more >>