September 11, 2007 at 4:39 pm
An additional question about SQL Server 2005 Reporting Services...
Do any of you know whether it is possible to use snapshots within reports that are already using parameters? For instance, if we try to use snapshots, then the parameters within the reports that our users are accessing appear to be grayed out and unusable for selection.
Any suggestions?
Regards,
- Jodi.
---Call me Jodi for short. I am.---
October 1, 2007 at 6:53 pm
If you wish to use snapshots, but be able to change the data displayed in the report, then use Filters.
Parameters are applied before the data is stored in the snapshot. Filters are applied to the data after it has returned from the source, and thus can be applied against a snapshot.
Look for "filters [Reporting Services]" in BOL.
-Eddie
Eddie Wuerch
MCM: SQL
October 1, 2007 at 9:18 pm
Thanks! We'll give that a shot.
Regards,
- Jodi.
---Call me Jodi for short. I am.---
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply