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

avatar image

ProKelly
42 5 5 6

(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

avatar image

Tim
40.4k 39 83 166

(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

avatar image

aRookieBIdev
2.7k 55 65 71

(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

avatar image

ProKelly
42 5 5 6

(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.

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:

x126
x28

asked: Jun 23, 2011 at 06:14 AM

Seen: 2044 times

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

Copyright 2016 Redgate Software. Privacy Policy