Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2011-11-16 : 03:36:36
|
| Guys,We have a report in SSRS report manager and i want to see the scriptsused in that report. what should i do to see the scripts in that report?regards,JOV |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 03:54:33
|
| which scripts you need to see? the backend sql scripts or expressions/custom codes used in report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-11-16 : 21:07:47
|
| Both sql scripts. I tried to download in reports server the .rdl but i got an error. i thnk i dont have the rights to download.is there any possibility/Idea to see the scripts of the table use in that report?Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-17 : 00:58:11
|
| nope. unless you download rdl and open and see it you wont be able to see expressions/custom code. Even query and store procs if any used information are also embedded inside rdl.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-11-18 : 01:59:17
|
| Thanks Visakh16 for this info. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-18 : 03:13:27
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Script in SSRS