Dynamic dataset

Hi all,
I would like to create a report in which I can dynamically define the
dataset (i.e: the name of the database). How can I do it?
Regards,
Tamas SzaniszloTamas,
Not sure of your big picture here but try using Data processing extensions.
These leave you in control of what data you want presented to RS
Report Designer will need to be "bound" to a datasource / set of course -
you can "fake" this using an XSD or possibly expose a dataset via a web
service.
regards,
- peteZ
"Tamas Szaniszlo" <t.szaniszlo@.scania.hu> wrote in message
news:ci50nt$huj$1@.namru.matavnet.hu...
> Hi all,
> I would like to create a report in which I can dynamically define the
> dataset (i.e: the name of the database). How can I do it?
> Regards,
> Tamas Szaniszlo
>|||Tamas , you could try http://workspaces.gotdotnet.com/appworld this
is a DPE that allows you to change the connection string on the fly.
In deployed scenario please be aware that if you are using URL access or
exporting to HMTL / XML etc the connection string will be exposed. There are
couple ways to tackle this either encrypt the connection string and decrypt
at the server or in my scenario I use a client id or database id to set the
connection string in the DPE, this works well and hides any connection
string information about the server.
Regards
Toby
"Tamas Szaniszlo" <t.szaniszlo@.scania.hu> wrote in message
news:ci50nt$huj$1@.namru.matavnet.hu...
> Hi all,
> I would like to create a report in which I can dynamically define the
> dataset (i.e: the name of the database). How can I do it?
> Regards,
> Tamas Szaniszlo
>|||Tamas , you could try http://workspaces.gotdotnet.com/appworld this
is a DPE that allows you to change the connection string on the fly.
In deployed scenario please be aware that if you are using URL access or
exporting to HMTL / XML etc the connection string will be exposed. There are
couple ways to tackle this either encrypt the connection string and decrypt
at the server or in my scenario I use a client id or database id to set the
connection string in the DPE, this works well and hides any connection
string information about the server.
Regards
Toby
"Tamas Szaniszlo" <t.szaniszlo@.scania.hu> wrote in message
news:ci50nt$huj$1@.namru.matavnet.hu...
> Hi all,
> I would like to create a report in which I can dynamically define the
> dataset (i.e: the name of the database). How can I do it?
> Regards,
> Tamas Szaniszlo
>