Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Dynamic dataset


Tamas Szaniszlo
9/13/2004 10:43:21 PM
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

PeteZ
9/14/2004 7:20:33 AM
Tamas,

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


[quoted text, click to view]

Toby
9/18/2004 6:25:42 PM
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

[quoted text, click to view]

Toby
9/18/2004 6:33:18 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button