Is there any way to read SSRS report server name or enivornment variables when report is run with limited access.
Not SysAdmin or DBOwner
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.
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.”