After upgrading to SQL Reporting Services SP2, we now get an error every time we try to run any of our reports. The error is"An unexpected error occurred in Report Processing. (rsInternalError) Index was outside the bounds of the array."Anyone have any suggestions?I looked in the Report Server ...

I have report parameters configured to use date pickers...but they don't show up when I run the report. I see the date picker controls when I preview the report in design mode, but they don't show when I open the report in a browser. Any thoughts?It could be unrelated, but the error I get ...

All,I'm looking at the possibility of allowing only certian tasks and reports to be available to users. I want the user to only have so much control...but would like them to be able to run reports, subscribe to reports and be able to use the query builder. We don't want the user to see all of ...

I have a matrix, I need to get the value from a cell in a similar matrix to use as a divisor to show a percentage in another matrix. I know one can access the value of a text box, but when I tr to do tis with a matrix cell I get an out of scope error. Any ideas? Thanks Bob

All,Is there a way to have a report header show up before I enter report parameters? When I link to a report I am prompting the user to enter parameters...but the report header isn't showing up until I enter the paramenters and 'view report'. I want the header to show up before I enter the ...

Hi, We are planning to install SQL 2000 for reporting on our data warehouse. Can anyone advise on the problems on moving from SQL 2000 to SQL 2005 at a later stage. My Questions:1) Is SQL-2000 for Reporting Services going to be obsolete soon and loose support. 2) What is the cost of upgrading ...

Hi all,Am having a problem processing reports using Report Builder. Have created the Data Source, DSV and Report Model and deployed them (following Report Builder walkthrough instructions in BOL). Building the report through the Report Builder app is also no problem. However when I try and ...

I have a very simple report with two non-queried values in my param list and the multi-select params box checked. The dataset only has two records, represeneted by the two params. The report always returns both records in VS and report manager whether I select one param, both, or the "select ...

I have a data driven subscription that is set up to email and uses a sql statement to generate the delivery settings and report parameters for each recipient (so each person does not reveive one email per row in the result set). I'm told that this is a good work around for creating a ...

Some of our reports use a stored proc as the source for base data. The proc contains RAISEERROR statements to handle error scenarios. Is there a way in which I could display the message that is output from the RAISEERROR statements in the report? Thanks

I have a full install of the June CTP on a brand new Win2K3 server.When I attempt to add a data source to my report project, the list of possible data sources is:Microsoft SQL ServerOLE DBMicrosoft SQL Server Analysis ServicesOracleODBCXMLThat's it. SSIS is not on the list (neither is SAP ...

I looked at RS a couple years back, around the release of SP1. The biggest issue I had was the lack of Aggregates of Aggregates. This still seems to be the case in RS 2005, is that correct? So help me with a work around. In a Matrix report how can I? Have a calculation (Aggregate) that ...

Hi All,I'm new to reporting services and I need some help. I've created a list which contains a photo and user name. Currently, it displays all the information I want however, the list expands down the page in one column. I would like it to expand across the page horizontally (4 columns) and ...

I wanted to create a column which was one field divided by another field, and then sort on it. I started with Fields!FG.Value)/Fields!ADU.Value but of course when ADU was 0 it caused an error. then I went to =iif( Fields!ADU.Value =0,0,(Fields!FG.Value)/Fields!ADU.value) but sadily it ...

I'm converting Crystal reports to RS reports. One of the reports has a group header "underlaid" with the detail rows, with the effect that it appears to actually be on the detail row, like this :Column 1 Column 2 Column 3-- -- --xxxxxxx xxxxxxx xxxxxxxxxxxx xxxxxxx xxxxxxx xxxxxxx xxxxxxx ...

I am using SQL 2000 reporting and I have 3 report parameters (2 of them dates). Is there a way with the included report viewer (from the sql reporting samples) to allow the date input parameters to be date pickers? Thanks

In a SQL Server Reporting Services Table(2005), I wish to subtract the current row's value from the previous row's value in a 'Remaining' field which works with the following code=Previous(Fields!Remaining.Value)-Fields!Remaining.ValueBut now I wish to subtract the current row's...

I have a full install of the June CTP on a brand new Win2K3 server.When I attempt to add a data source to my report project, the list of possible data sources is:Microsoft SQL ServerOLE DBMicrosoft SQL Server Analysis ServicesOracleODBCXMLThat's it. SSIS is not on the list (neither is SAP ...

Hi.Is it in anyway possible to only add borders to left and right sides of a column in a bar chart. I can see in the xsl definition schema that style does allow left, right, top, bottom tags. But if i replace the <Default>4.5pt</Default> with left, right, top and bottom and ...

Hi All, I want to display date as Jan01,2005 to Jan02,2006... plz send me Expression for thsi one..

Hi We are planning to install the Reporting Services, but have been given a very negative feedback by some companies which planned to move to this. The type of uncertainities that are coming through are:1) product may either undergo a signifcant change2) lose support Can anyone help me with ...

Hi, Can you tell me if having SQL Express as your database will provide suffient licensing rights to use Reporting Services 2005? Thanks,

The help “Advanc<st1:reference data=' ed ' w:st="on">ed Textbox Properties (D<st1:reference data=' ata ...

The que<st1:reference data=' st ' w:st="on">stion is “how to populate the <st1:reference data=' co ' ...

I have really two questions to ask, I am writing my own front end and using WebServices to extract the information I need from the Reporting Server. I have all the Catalog information and it works well. But how do I get the Subscriptions information out? I would like to pull out the information ...

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized. at ...

I installed the SQL Server 2005 June CTP. I created a datasource named Datawarhouse. I went into the Report Builder and created a report and could actually run the report successfully. When I saved the report & ran it I got the following error: An error has occ urred during report ...

Hi Can some one help me please ? I am using matrix table and i need to do total column wide say example priority 1 priority 2 P 3 $ 100 $ 500 $ 200 $ 1000 $ 1000 $ 1000 - TOTAL HOW DO I GET THIS TOTAL FOR each column -- Thanks in advance

I've created a simple report (June CTP) based on a paramaterized stored procedure using integrated windows security. When I preview the report in the designer, I get results as expected. Deployment to the web server was successful. After entering paramaters and clicking [View Report], the page ...

I am reusing a reportviewer object in a webpage to render one of two reports based on what's passed on the query string. Let's call them Report A and Report B. Report A is the default, Report B is my problem.Report B is only displaying a maximum of approximately 33 records on -any- iteration...

"WHERE (Month(Parking.VIODATE) = (@CurrMonth)"...OLEDB does not understand this SSRS parameter. I need to feed an answer into SSRS SQL via a variable some way that OLEDB understands. Also SSRS SQL does not understand ACCESS SQL params like ..[Enter month here:].....

Hello,I am a newbie to sql server 2005 Reporting services. After installation of sql server 2005 beta 2, I tried typing http://localhost/ReportServer to check if the reportserver is working correctly, but I am getting this error message: The report server cannot open a connection to the report ...

Plz Its Very Urgent to me.... 2007-02 2007-03 2007-04 Location Ave/Day(X1) Ave/Day(X2) % Change Ave/Day % Change ALBANY, NY 0.21 0.35 65.59% 1.20 238.18% %Change=X2-X1/X1*100

When I add a reference to my custom assembly to the report and try to preview it I get the following error message:Parameters ErrorThe report references the code module ‘Employee, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null’, which is not a trusted assembly.OK I have modifed the ...

I'm trying to display an image that has been returned from an external assembly, but am having no luck at all.Essentially, I have a utility class that goes to a resource file and pulls out a JPG and returns it. I have set the value property of the image control on the report to hit this ...

I have installed sql server 2005 with reporting services on windows xp.After that when i go to Reporting Servcies Configuration i get follwoing error,A WMI error has occurred and no additional error information is available.details,ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error...

Is there any way to deploy a report to the server and not have to reconfigure its reference to its shared data source?For instance, if in the development environment my report is pointing to a data source called "MasterDB", and i deploy the RDL file to the server which has a data source called ...

I have set the Interactive Height in my SQL report to 11 inches. I have also set a page break to occur after each group in my report. When I run the report in SQL Reporting Services the only page breaks that occur are the ones after each group. The Interactive Height setting is not causing page brea...

Hi Every oneI have problem in using page footer field from the storeprocedure. I have a procedure and defined two fields one is page header and page footer. When I drag and drop them repective area it displaying error message you can't use fields for header and footer than how can I use them ...

I have a grouping on my table for sales manager. I have the goals as a max on the report due to duplicates in the data. How do I sum this max so I can get a grand total for all managers. I tried doing a sum(max()) but this gave me an error that you cannot nest aggrigates

I am trying to create a report that will pull the data based on a parameter. The parameter needs to me numeric and multi value. Here is my sample sql statement:select sum(Rooms) as Rooms, sum(Revenue) as Revenue, Month(RoomDate) as Month, Year(RoomDate) as Yearfrom bookingwhere bookingtypeid in (...

Hi,can anyone tell me if it is possible to mix text and Expressions in a report cell? I am grouping a simple report by a Username column and I wanted to put some text at the beginning of each group that said something like:The following gorup is for <username here>But the only way I can ...

Hi, In my excel sheet(out put of sql server reporting services)i do have so many groups with totals and sub totals.i need to get the formula behild each cell.Means if i click any cell,it has to display what are the columns included for sum or avg... in fx column on the top of excel sheet.Let me know...

My customer wants to be able to mark any given row in my Report as VIEWED or REVIEWED. I don't know how to update a field in my database table from SQL 2005 Reporting Services. I can write VB.NET Code or call a Stored Procedure to do the update, but I don't know how to provide User Interacti...

I have a test report, unformatted the value one of my fields is -29.5600When I apply the format: FormatCurrency(Fields!Paid_Amount.Value) the value shows as -($293056). Another sample is -62.2400 which converts to -($626224).It seems the leading digits are being repeated for some reason. I've ...

I must be missing something really obvious, but, how can I specify whether a report (.rdlc) if being designed for landscape or portrait paper? It would be nice to have some sort of mark on the guides or the grid to show where the edge of the selected paper type is. Regards Graham

Hi, I am pretty new to the Microsoft Reporting services. I wanted to know if this is possible to design in the reporting server.I have a requirement to take the number of groups in my report as input. So if there are two groups I will have two columns and if I have three groups I will have ...

CategoryA Description Value Type nbbnbnb jjhdjh hde hjhjjhwjh jdjj j j jjnjnj Description Value Amount hbsjbj bj hbhjb $23.45 hsdhsbdh bnnbnb $57.89CategoryB Description Value Type vvvvbvbvb mmkmhh gfjh hhjjkjkjkh uiuiuyjh ytyuy Description Value Amount hbhghgbj huyuyjb $40.89 hsdrerrtdh ...

I have a little Problem with Snapshots from the Reporting Manager.I have a big Report with a lot of Parameters and I need a daily snapshot.For the snapshot I have to set all parameters. In this case I set them to get the whole query, so I can change the Parameters later and it still can use the snap...

I'v reinstalled RS, then I configuret it. But when I want to open a report raise this error An error has occurred during report processing. (rsProcessingAborted) The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Any Ideas Thanks in advance