being on your secure  firewalled intranet is ok.

out in public on Internet, i don't want to send those in..

But my main concern is the flexibility on having 1 report run...

Adriaan,

If we are concerned about Security, you can just hard code the username and password in the DataSource Credentials Tab.

As far as DatabaseName and ServerNamer are concerned, you don't have...

If you don't wanna embed Reports within the ReportViewer in a WebForm then you don't need to use the ReportViewer.

This format should work. https://RSServer/Reportserver?/ReportFolder/ReportName&rs:Command=Render&server=ServerName&database=DataBaseName

as long...

Debby,

You can pass in the ServerName and Database in the URL like this:

You need to have ReportViewer first and set its ReportServerURL property first:

http://localhost/ReportServer

Then do this...

Adriaan,

Dynamic connection string is a Great feature in RS2005. When you use shared datasources, you HARDCODE the Servername and Database name in there which you cannot change.

What if  you want...

Rosey,

it can definetly work for jump to reports. You just have to pass the serverName and database name to the target report that will be accepting these.

=Parameters!ServerName.Value

=Parameteres!DatabaseName.Value

Debby,

I only use Stored procedures and it works perfectly fine with Reporting Services 2005 expression based connection string.

Any time you edit the dataset, and try to save or hit ok...

Hi Steve.

We are trying to get away from shared data source. You cannot use a shared datasource with this expression based connection string, it defeats the purpose of making it...

My bad! My report was deployed on a remote server and stored proc was on the database locally on my computer... Since the remote errors was turned off i could...

Yes, Report works fine with Stored procedures and command type is stored procedure and not Text.

My question is Why does Report 2005 not work with stored procs when we use...