I have a drill down report which I have specified in the action with the second report name and also specified the parameters to pass to that report. I am using store procedure for the reports. When click on the first report to open the second report, it comes back with an error saying "Proced...more >>

Hello, I am deploying reports via the web service. I create a folder, then create a data source. Once I create a report, I make a reference to the data source created and change the reports invalid data source to the reference. When I did this with a data source with credentials stored o...more >>

I need to have MSSRS send emails to external email addresses. Our Exchange Server requires email to be authenticated. I am using SMTPAuthenticate value of 2. My MSSRS server is in a different domain than my Exchange Mail server. Currently I am testing before deployment into the field and my s...more >>

I have a report that I want to pass the parameter of the cell clicked on to an asp.net page. This is the best that I came up with so far: http://local/page.aspx?ID= & =Fields!activity_id.Value Of course, this doesn't work and I have not been able to find a good example of this. Is there...more >>

All, I work for a partner, and we use MOM 2005 in a "managed services" scenario to monitor client environments, and are attempting to develop client-facing sites within Sharepoint portal to display various reports and alert information. This effort spawned the following question: What...more >>

Hi, I hope than somebody can explain me why the report order on the reporting services desing (Visual Studio), is differen than the query sort order. Normal SQL Query 1) AA 2) AB 3) A1 4) 1A Visual Studio Report Design 1) 1A 2) A1 3) AA 4) AB Can some body help me to change tha...more >>

I'd like currency format of $#,### but when i specify that, I dont get any values for 0 I just get a $ which is somewhat expected. If I specify C, I get the cents, which I dont care about. Anyone knowhow I might achieve C currency format, that doesnt include cents, but displays 0 when t...more >>

How can I locate Query Analyzer for SQL Server 2005?...more >>

This was working before but all of a sudden when I try to access reports server http://myserver/reports/ I get the following error: Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\global.asax" is denied. Please help.. ...more >>

I'm pulling reports from rs web services to implement my own custom security. I used the following DeviceInfo element to determine where to render the image (i use imageRender.aspx to write the stream to an image). <DeviceInfo><HTMLFragment>True</HTMLFragment><StreamRoot>imageRender.aspx?image...more >>

I have created a SQL report that uses 2 parameter fields: 1. StartDate a date-time field (in the form of MM-DD-YYYY e.g. 03-01-2005 for March 1, 2005) 2. EndDate a date-time field (in the form of MM-DD-YYYY e.g. 09-27-2005 for September 27, 2005) In my report I have a logo in the page h...more >>

I have a Time and Billing OLAP cube which I'm running RS against. I'm stumped on a date issue. How can I run a report which selects the last 7 days worth of data and rolls forward each week? I've tried using an MDX query with the Tail funtion. This pulls the last date which has data in i...more >>

I have a SPROC that returns any number of vehicle options for a specific vehicle. I want to display the information in a multi-column fashion like this... 4speed Auto Windows Floor mats Radio Bucket Seats Wheels NOT like this 4speed Auto Windows ...more >>

How can I dynamically remove a table row if a value is blank? (i.e. Address 2 is blank)...more >>

I am running the following command >rsactivate -c "d:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" And I get the following error message: Failure starting the web service: Unable to connect to the database (-2147159543) 0X80070569 Any id...more >>

What I'd like to do is apply an expression for a bunch of cells thats not dependant on the underlying data... for cell bgcolor I'd like it to basically say if value != 0, bgcolor is gray or something so for bgcolor I pick expression and would like to say IIF(this.Value = 0,"White","Gray"...more >>

While testing the latest RC1 SRS software and trying to get report drill down in a chart working, I found that it was not working as expected. I thought that this might be a Dundas issue, but has since learned that this is a MS issue. I understand that MS is aware of this and I strongly be...more >>

Hi, From my own PC, I have created a report in Report Builder (RB) that has a SQL server database as a data source, and when I go to run it (in either RB or Report Manager), I get the following message: - "Cannot create a connection to data source 'dataSource'. (rsErrorOpeningConnection)...more >>

I cant believe why we cannot export to html without refering back to the server. PDF and Excel or fine..but why they cant do a simple html export... they put all that meta tag to make the export not working... When I save the report as "Web Page, Complete", I get the following four lines ...more >>

Let me set this up for you. I am utilizing forms authentication for Reporting services. But I want to do more. As you already know, after the user goes thru the UILogon.aspx page, a ticket is created and placed in the cookie called "sqlAuthCookie". This cookie (ticket) is used for authorization ...more >>

I am installing Reporting Service to my computer. (OS: Windows XP) And get an error message (1603) during the step of configuring sql server. Error message: MSI (s) (2C:1C) [15:21:53:395]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI71.tmp, Entrypoint: Write_sqlScript <Func ...more >>