x

Dynamic SSRS Report based on Query

Is it possible to dynamically choose a report based on a dynamic value? For example. I have 2 types of users. Standard, and Intermediate. I want to embed a report into a sharepoint page which, dependant on the USERID of the person running the report it would present the relevant report.

Initially I thought a landing report which basically chose a subreport based on an initial query to identify which report should display, but it seems you cannot choose the subreport with an expression ie IF USERID.Group = standard then open x else open y.

Please help?
more ▼

asked Jun 23, 2011 at 06:14 AM in Default

ProKelly gravatar image

ProKelly
42 3 4 5

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
Could you not handle this with groups? Assign the users to different groups depending on standard or intermediate and only display the appropriate report to each group? I work with SSRS a little bit but don't work with SharePoint so I am not sure of the bells and whistles with it. With SSRS I can limit who sees what based on roles and memberships.
more ▼

answered Jun 23, 2011 at 07:56 AM

Tim gravatar image

Tim
36.4k 35 41 139

(comments are locked)
10|1200 characters needed characters left

Hi ,

You could have 2 sub reports in a single report and toggle the visibility between the reports based on the user who is running the report. Toggling the visibility can be achieved using expressions in the visibility property of the data region.

Cheers, Nk
more ▼

answered Jun 23, 2011 at 10:17 AM

aRookieBIdev gravatar image

aRookieBIdev
2.3k 47 55 61

(comments are locked)
10|1200 characters needed characters left

Trade ... its not about permissions of data its about displaying 2 completely different reports.

I think kannan is onto something though I will try that tomirriw thanks.

Excuse typos this new xoom is taking some getting used to,
more ▼

answered Jun 23, 2011 at 02:18 PM

ProKelly gravatar image

ProKelly
42 3 4 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x113
x18

asked: Jun 23, 2011 at 06:14 AM

Seen: 1716 times

Last Updated: Jun 23, 2011 at 06:14 AM