June 5, 2010 at 9:59 am
I'm somewhat familiar with SSRS in 2005 so I'm posing these questions to see if anything has changed in 2008.
In order to save on the number of SSRS reports I need to create for various users, I would like to:
1. Be able to have a dynamic way to add and remove dimensions, and have the metrics re-group by those dimensions after the final columns are chosen. I.E. Data grid has Dimensions 1, 2, 3 alongside Metrics 1, 2, 3. Choose to remove Dimension 3 and the data grid is refreshed such that only Dimension 1 and 2 are shown and Metrics 1, 2 and 3 are calculated appropriately.
2. Have a single report be able to serve different levels of users. For example, I have a region filter on a sales report and I want the Regional Mgr over Texas to only see sales data for the Texas region, while the Arkansas Regional Mgr would only be able to see the Arkansas region. This would be automatically set when they entered the report.
Is there a way to accomplish each of these?
Thanks in advance.
June 5, 2010 at 12:49 pm
Not sure what type of report you are looking for in your first question. Almost seems like you want it to be fairly interactive and not sure if this would be done with filters, but you could do it with that if that is how you set it up. Simply create multi-select filters (parameters) on the report to allow the user to select would would get populated on the data region (tablix or chart).
For the second one you should be able to do this in any version, simply utilize the User!UserID to retrieve the logged in user information and utilize that on the backend to filter the dataset appropriately.
If you are looking for new features you can check out the following for SSRS 2008 and R2 releases:
What's New SSRS 2008
http://msdn.microsoft.com/en-us/library/ms170438(v=SQL.100).aspx
What's New SSRS 2008 R2
http://msdn.microsoft.com/en-us/library/ms170438.aspx
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply