sql server reporting services: Is it possible to change the connection dynamically. -- sql server reporting services

Re: Is it possible to change the connection dynamically.

EMartinez
4/26/2007 7:25:42 PM

[quoted text, click to view]

The only options I can think of are:
- Have a report parameter (possibly hidden) passed to the query/stored
procedure that is sourcing the report and based on that parameter,
select the correct database (via opendatasource, etc).
- If an ASP.NET application is an option, dynamically set the desired
datasource as part of a custom RDL building process (dynamically) as
part of the <Datasources><Datasource Name="SomeDatasource"></
Datasource></Datasources> tags.
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

RE: Is it possible to change the connection dynamically.

Amarnath
4/26/2007 10:36:01 PM

So one report connects to US with US database and the other connects to UK
database is it right ? then while creating dont use shared data source
instead create a seperate data source from data tab for each server and each
report.

Sounds simple. Let me know if my understanding is right

Amarnath

[quoted text, click to view]

RE: Is it possible to change the connection dynamically.

Sriman
4/27/2007 6:06:04 AM

wow..both options sounds good to me.
Thanks alot ..

Regards,
Sri

[quoted text, click to view]

Re: Is it possible to change the connection dynamically.

EMartinez
4/27/2007 8:47:45 PM

[quoted text, click to view]

You're welcome. Let me know if I can be of further assistance.

Regards,

Enrique Martinez
Sr. Software Consultant

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.