Reports

Strange credential behavior with SSRS
Something strange is happening when I try to authenticate. Domain is xyz.com main AD Server is xyz03mn SQL and SSRS server and backup AD is xyz03sql I am working from my development computer logged into the domain xyz.com on the lan everything is fine I can see the domain shares and get email, work with the sql... 11 Jun 2008 17:57

Snapshot viewing is not working corrrectly
Hi all, I'm trying to migrate ssrs 2000 to ssrs 2005, but I found out a bug for viewing snapshots generated. Basically, I'm using URL Access to get a report, but the url below is not working for ssrs 2005. Does anyone know how I can fix this problem? http://localshot/ReportServer?/Member&rs:Snapshot=2008-06-... 11 Jun 2008 14:53

Can you disable auto run of Report when you go to the view tab
Bruce, I've tried your solution. I'm not very clear on the settings for this hidden parameter and I can't get it to work. What you're saying is create a dummy parameter, set it as hidden and what are the other settings for the parameter? If you set the default value as null then you need to set the allow nu... 11 Jun 2008 14:22

How can I pass a value from a subreport back to the main report?
Hey all, I'm having a big issue with SSRS, and I need to know if this solution (SSRS) will even be viable in my conversion from Crystal Reports 8.5. Is there any relatively easy way to send a subtotal that is calculated in one of the subreports back into the main report to be used for more calculations in the ma... 11 Jun 2008 13:21

Force entry on one of two parameters
I have a report where I need to force entry on one of two parameters. Is there a way to do this in Reporting Services? Any help is greatly appreciated. ... 11 Jun 2008 12:19

Query to get a list of reports that use "Credential Stored Securely in Report Server"
We are in the process of moving the SSRS 2000 Reporting databases to a new server as we are retiring the current server. So I am in need to find out all the reports that use the option "Credential stored Securely in the report Server". Does anyone know of a query that I can run to get that result from the reportin... 11 Jun 2008 11:18

Using Stored Credentials with Impersonate functionality fails
Hi Charles, The security filters that I setup work fine on the report server therefore they do not need changing. The only issue is why BIDS does not effectively make the call to SETUSER as does the report manager. I suspect that it relates to the way that BIDS uses its own internal DATA SOURCE even when... 13 Jun 2008 10:16

SSRS 2005 The request failed with HTTP status 407: Proxy Authentication Required
Hi Guys, Configuring SSRS for a customer, when i try and install the reporting server or connect to SSRS using the SQL Managment Studio i get the error: The request failed with HTTP status 407: Proxy Authentication Required Any Ideas? Chris ... 11 Jun 2008 06:10

Data Driven Subscription Random Errors in SQL 2005 RS
Hi Every night I have 3 data driven reports that run and are emailed to a couple hundred people each. For some reason, every time there are errors to 1-5 people on each list. The email addresses are pulled from a table. In the log files I get the message: System.IO.IOException: The process cannot access the fil... 11 Jun 2008 05:09

Change report ciontent if saving as excel
Does anyone know how i can use the ReportingServices Expression syntax to see if a report is rendering to html, excel, csv, etc. I am required to make all reports print on 8.5x11 paper, To accomplish this, I've 'stacked' multiple data items in a single column and sometimes omitted some pertinent information... 10 Jun 2008 21:45