May 6, 2015 at 9:35 am
Hello Experts,
I have the SSRS application installed. Wanted to know how to call a procedure to display in the results in the SSRS reports and giving permissin to managers and fellow staff so that in stead of using SSMS and running it manually, anyone whoever are subscribed to the report can view it.
Kindly help and suggest.
Have a good day.
Thanks.
May 6, 2015 at 12:12 pm
I'm not sure I understand your question.
stored procedures are normally used as the source for a dataset, which you use in the report.
Once you create your report, you grant users the right to view it. If a user doesn't have permission to view a report, it won't show up when he goes to the URL to which the reports are published. That's the way SSRS works.
May 8, 2015 at 11:22 am
can you refer me some of the docs to create the report where in I will call a procedure and will execute on different SQL SErvers?
Thanks.
May 8, 2015 at 11:26 am
Ok.
I found a good one. : - https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-building-ssrs-reports/
One question to you, if I need to run the same proc to multiple servers, what's the most convenient method followed?? I don't want to create multiple data source/data sets!
Thanks.
May 9, 2015 at 2:20 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply