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
>

Dyanmically add fileds

Hi Guys,
Is it possible to edit the report dynamically.Please let me know
your thoughts.
--
Thanks and Regards
M. S. Raja Mohamed,
Senior Devoloper,
PHOTON INFOTECH PVT LTD.,
Adayar,
Chennai.Not easily. If doing the server product you have to modify the report and
redeploy. If you use the new controls that ship with VS 2005 you can modify
the report and then use the controls in local mode. This means you have your
own front end, you are not using report manager. Also you have to provide
the dataset and the report to the control.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Raja Mohamed" <Raja@.photoninfotech.com> wrote in message
news:%23Tacn0M7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hi Guys,
> Is it possible to edit the report dynamically.Please let me
> know your thoughts.
> --
> Thanks and Regards
> M. S. Raja Mohamed,
> Senior Devoloper,
> PHOTON INFOTECH PVT LTD.,
> Adayar,
> Chennai.
>|||Yes, you can do this
There are article and sample code available at this link
http://www.codeproject.com/dotnet/DynamicReport.asp
Hope this helps. Let me know
Sumit Pilankar
"Raja Mohamed" <Raja@.photoninfotech.com> wrote in message
news:%23Tacn0M7FHA.3660@.TK2MSFTNGP09.phx.gbl...
> Hi Guys,
> Is it possible to edit the report dynamically.Please let me
> know your thoughts.
> --
> Thanks and Regards
> M. S. Raja Mohamed,
> Senior Devoloper,
> PHOTON INFOTECH PVT LTD.,
> Adayar,
> Chennai.
>