Remote Report Server 2005 using the reportviewer control - parameter problem

I am using an asp.net web page (C#) to access a remote Report Server via the reportviewer contol. After solving the credentials issues, all of my test reports seem to run very nicely if there is no parameter input. When a parameter report is executed, the text box for parameter input is displayed. When the parameter is entered and the View Report button is pressed, the report is NOT Returned. If I go directly to the remote Report Manager and run the report (IE no code behind), it runs as it is supposed to. I've also run the report (web page) on my local report server and it displays the report after the parameter has been input. Why is the remote report server not returning the report after the parameter is input?

Thanks,

John

This problem has been resolved. The page will not work if the "ReportViewer1.ServerReport.ReportServerCredentials = new MyReportServerCredentials();" statement is placed in the Page_Load event.

Here are the steps taken to eliminate the problem:

1. Remove the credentials statement from the Page_Load event.

2. Place this code in the Page_Load event

if (!Page.IsPostBack)
{
ReportViewer1.Visible = false;
}

3. Place a button on the page to display the report.

4. Move all report statements to the push button event. Make sure to include "ReportViewer1.Visible = true"

It now works like a champ and I am happy!

Thanks,

John

Remote Desktop: Losing credentials ...

Hi,

I've experienced a problem (bug?) when deploying reports to the report server. My users kept complaining about losing authentication to reports when I deploy a new report. I found the problem but don't understand why this is happening. My collegue developped the earliest reports and loggs in with a different user on Remote Desktop to develop the reports. When the report is deployed, the datasources are deployed also.

Now when I log in on Remote Desktop with another user then my collegue and open the same report project, and check out the datasources, the credentials are gone ... ?!? So when I deploy a report the datasource with the empty credentials are deployed too, wich causes all the authentication problems.

My Question: How comes I can't see the user credentials my collegue filled in? When I open the report project the credentials are gone. I log out, my collegue loggs in, and the credentials are back

I suppose this has something to do with Remote Desktop and the users connecting to it?

Thanks in advance!

Nobody?|||I believe Visual Studio stores the data source credentials in a user specific data file (<projectname>.rptproj.user). This is by design, so that one developer cannot "borrow" another developer's credentials. However, if you are using shared data sources, there is a simple workaround. Make sure that the OverwriteDataSources property in the Project Properties is set to FALSE. This way, shared data sources are only deployed if they don't already exist. On the first deployment, you may have the update the data source on the server, but subsequent report deployments will not overwrite it.|||

Hi jwelch,

Thanks for the explanation. Your solution will probably prevent anything like this happening ever again.

Respect! ;-)

|||Can you mark the response as an answer? It helps others who encounter the same problems find solutions more easily.