October 1, 2013 at 9:45 am
Hi,
Is there any way to read SSRS report server name or enivornment variables when report is run with limited access.
Not SysAdmin or DBOwner
Requirement :-
When report is run on Dev machine - Report Label = RptName_(Dev)
When report is run on QA machine - Report Label = RptName_(QA)
the Dev/QA should not be hardcoded but picked on basis of server name or some environment variable.
Regards,
Ankit
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
October 1, 2013 at 10:43 am
Hi Ankit,
Did you try using expression
=Globals!ReportName in SSRS report
Nikita
October 1, 2013 at 11:58 am
not report name but server name
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
October 1, 2013 at 10:04 pm
Have a look at the value of Globals!ReportServerURL. This might give you what you need
October 1, 2013 at 11:06 pm
Again the ReportURL can change. Need the report server name or machine name
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
October 3, 2013 at 2:00 am
Create a new dataset which will query the server such as using @@SERVERNAME and use parameters in the report body
Raunak J
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply