How can one add headings to the Row fields in a Matrix report? One is easy (you just add it to the top left cell), but what if you have more than one field in the Row area? Much appreciated! ...more >>

Hi Using Visual Studio 2003... So I've got a report with just under 21000 lines of XML in the RDL file. Then I make a typo in an expression and get a non-specified build error. To work out where the error was I commented out the xml using the <![CDATA[ **XML ROWS HERE** ]]> I then d...more >>

Hi all. Have a report with 2 parameters StartDate and SessionName. Both are non-query based. So, the user runs the report and has to enter values in both fields in order to run the report. I would like to have by default to have the report run all values like as in (select * from etc) and th...more >>

Can datasets associated with a report be referenced in custom code? If so, how? I've tried referencing them like one does in expressions in the report, e.g., Fields!Personal_Amt_Paid.Value, but this does not work. I get the error "There is an error on line 6 of custom code: [BC30469] Reference t...more >>

Have a report that requires a @StartDate parameter. This will equal a ActualDateTime fields in a table. I have the following code listed in my where clause and (tvo.ActualDateTime = @StartDate) but keeps getting throwing an error when i test. As we are in New Zealand our date format i...more >>

I am trying to install Microsoft Reporting Services on my computer and getting the following error. "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 25619." Can someone help what could be the cause ...more >>

I have a project that we need to dynamically output a PDF document. The format I have it in now is PDF. I want to be able to bring this PDF into the Visual Studio report designer as a starting point. I will the drop report parameters on to the report to add the dynamic data. Is there any way I...more >>

I want to connect to table of AS400 with a parameter(THE NAME OF TABLE IS AVP.M002) The following sentence execute correctly. SELECT * FROM LIB01."AVP.M002" WHERE CDTAB= '007' How will be the string with the parameter: Parameters!ParmCDTAB.Value I was trying with the string , but it doesn'...more >>

Hello, Is Reporting Services compatible with SQL Server 2000 Personal Edition? Thanks, Howie ...more >>

Hi All, I am looking for some articles/documentation/process that describe how to upgrade from evaluation edition to standard edition of Reporting Services. Or if someone has had experience with this, please share. If someone can point me in the right direction that would be great. TI...more >>

Looking for a way to reset a parameter when the 'View Report' button is pressed. As it works out of the box, when you change a parameter and hit 'View Report', the parameter retains that value after the report is generated. What I need is for the parameter to reset to default after the report is...more >>

Hello, I've done quite a bit of reporting services programming... and I know this is possible... I'd like to simply hide two textboxes based ont he value of a selected parameter value. I've set expression value for visibility and tried various different versions of this: ...more >>

I have figured out how to call a report and pass parameters via a URL, but I get the dreaded Open/Save prompt. Is there any way to bypass this and just open the PDF file? Also, is it even possible to simply print the report with the user's default printer when a button is clicked? I am usin...more >>

I am trying to place a background image on a report based on a database field called watermark. I have not found a way to create an expresion or code that would allow me to display this background image on some pages based on the water mark field. Is it possible to do this? ...more >>

need help (links/documentations/tips) on how to migrate from reporting services 2000 SP1 to SSRS 2005 - June CTP, the June CTP documentation steps are somehow not working in my case. I will be migrating RS 2000 (on a test box with all default configuration and two test reports one for Northwin...more >>

I am copying the question from another member as it is exactly my problem: We have an extranet application (internet users) written in ASP using VB COM. All the security of what reports users can see is handled through this application. Is there anyway we can link RS reports using a URL? In...more >>

I'm building a report using the matrix control. I have financial data in different line items (Salary, Rental Expense etc) that needs to be shown by month (so the columns have months). I have it pretty much working but can't figure out how to sum up the numbers in each column at the bottom s...more >>

How do I include a Word document in my report?...more >>

Does anyone know how to run reporting services so it can change the From address for each report it sends. I need to use mutiple From addresses depending what the report is....more >>

I've just completed a new installation of MSRS to a WIN 2003 server. I can connect into http://reportserver/reports without any issues. However, anyone not part of the Admin group on the box gets an NT authentication box and even after entering a valid user name/password, gets a access denie...more >>

Hay! My report i so width that i only want to print it out in Landscape(not Portrait). So wat to do when i want to print it out from the report manager(from IE) or when i export it to pdf?...more >>

How can I add headings to a Matrix, but have them appear above the "Rows" region (as opposed to appearing above the "Data" region). For some background: My report lists persons names in the Rows and dates in the Columns, and the Data region is blank. This allows people to sign at their name fo...more >>

Hi, Is it possible to include "Table of contents" within a report using reporting services? Sapnil ...more >>

Hello, I have VS.NET 2003 Enterprise Edition running on my system, but it doesnt have the option to create Business Intelligence Project. Does not this option come with it? When I checked with Add/Remove options, I didnt find it though. Ann ...more >>

Hi all, Quick Question- Is it possible to have two websites on the same report server for reporting services? Example: I have one website, lets say for internal reports (employee time, job info etc.) and another one for customer info (how a customer product is coming along, how many produc...more >>

Hi all, I have an ASP.NET page which I want to use to be able to upload *.rdl documents to the report server "on the fly". When I call the webservice via some code in my ASP.NET webpage I receive the following error "The request failed with HTTP status 401: Unauthorized." Any ideas more t...more >>