Parameters Disabled with Snapshot Report Execution

Is there a way to schedule report snapshots and still give users the option to change the parameters? I found that report parameters are disabled when I set the execution options to use a snapshot. I fixed the problem by setting the report to use cached data that expires on a custom schedule and by scheduling an e-mail subscription that creates a new report cache soon after the cache expires. I'm guessing there must be a better way to provide good report performance with the default parameters as well as flexibility.

You'd need to change from using Query Parameters the query to using Report Filters.

You can read about it here:

http://msdn2.microsoft.com/en-us/library/aa255838(SQL.80).aspx

I would only recommend doing this for filtering relatively small amounts of data. The SSRS is not as efficient at filtering data as a stored proc on a DB server.

Parameters are disabled

I've set three parameters in the reports. However, when it is deployed, the
three parameters (textbox & dropdown list) become disabled? Is there
anything that need to set to make it enable?
Please advise.On Dec 2, 10:12 pm, YeungTakYan
<YeungTak...@.discussions.microsoft.com> wrote:
> I've set three parameters in the reports. However, when it is deployed, the
> three parameters (textbox & dropdown list) become disabled? Is there
> anything that need to set to make it enable?
> Please advise.
Are you using a different datasource for the parameters than you are
for the report itself? If so, make sure that the datasource is
available in the Report Manager on the production server. Also, by
default, the datasource for the report when it is first deployed is
not set. You normally set it by selecting the Properties tab (I
believe it is) and then select Datasources and select the datasource
from the top. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant