June 5, 2012 at 3:30 pm
Hi, I have several reports that use queries to allow users to select parameters when they run reports. When I run the reports from SQL Server Report Builder, I am able to change my selection values for my parameters. When I run the same reports through my Reporting Server intraweb site, the parameter values are grayed out. I've tried tweaking with the reports' "Available Values" and "Default Values" settings in SQL Server Report Builder, but I have been unable to get the Report Server intraweb site to allow me to choose my parameter values. Is anyone familiar with this problem?
June 6, 2012 at 9:16 am
It looks like it was because I had the snapshot view option on. Although I am still confused as to why the report doesn't choose the last date value for the parameter when it runs in snapshot view. ie: The list of options for my parameter would be "Jan 2012", "Feb 2012", "March 2012", "April 2012", "May 2012". The report always select the "April 2012" view on the Report Server. I would like it default to the "May 2012" view. It does so in design view, but not on the Report Server intraweb.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply