how to open dataset in SSRS 2005
Hi all,
how to open existing dataset in SSRS 2005. I am creating some reports based on existing reports so i want to open and see existing data sets in old reports.
please let me know...
Thanks
jyo
June 30th, 2011 12:54pm
Hi Jyo,
- Go to Data tab,
- Select your DataSet which you want to edit (their might be multiple data-sets)
- Click the button right next to the drop down menu which say "edit selected dataset" which looks like 3 dots "..." when you hover your mouse to that button, click on the "..." (3 dots button) which will allow you to edit the data-set
Please let us know if you don't find.
Thanks
Kumar
KG, MCTS
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 1:14pm
Hello jyo,
You can't access datasets from other reports, that's not possible. In SSRS 2008 R2 you can define "Shared Datasets", but not in SSRS 2005.
You have to copy the dataset definition from an old report to your new one.Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
June 30th, 2011 1:16pm
Hi Agaoin,
Sorry I read the thread wrongly.
KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2011 1:22pm
Thanks Kumar and Olaf. Actaully i am new to SSRS 2005..previously i worked on 2008. So I got what i want from your reply.
Thanks.
June 30th, 2011 1:26pm