dynamic connection string

hi all,

i've been reading through the forum on this subject but couldn't find the solution. i'm using RS2005.

it's mentioned that dynamic connection string is not applicable for shared data source. is there a workaround for this?

thanks!

Dynamic connection strings cannot be used with shared data sources.

Other suggestions can be found in this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16395&SiteID=1

-- Robert

|||

Thanks Robert for your reply.

however, do methods for RS2000 apply for RS2005? i've never used RS2000 before and i'm not sure where to start either.

Thanks!

|||

Yes, everything mentioned for RS 2000 works for RS 2005 the same way.
RS 2005 offers expression-based connection strings in addition.

-- Robert

|||

I wrote an application using VS2005 that has a generic report viewer and rdlc files stored in a database with the stored procedures necessary to run each report.

Then I took the report, replaced the dataset stored in the rdlc file programmatically with the generic dataset which accepts the result of the stored procedure and use it to populate the report.

It wasn't that straight forward, but now it works dynamically and I have an application now which I can add a new record to my database storing my rdlc files and stored procedure names and the list of reports that drop down in my application is completely dynamic, including parameters required appearing in a datagrid with controls for calendars and drop-down lists.

Just an idea of how you might get that dynamic dataset.