>I create an snapshot programmatically with default paramters for a report
> which takes 2 minutes to run.the snapshot takes the same time and the only
> things the snapshot dose it that it dosen't let me change the
> parameters.They are all grayed out.Is that what it should be?
>
> Thanks
>
>

> The snapshot stores the data as you selected the parameter, therefore you
> can´t do any parameter changing after the snapshot is taken. You can do a
> snapshot for another parameter, but thats all. Its like you make a copy of
> a filled form, then later change something on the original form and ask
> "Why doesn´t that change on the copy ?!"). Snapshot are taken in our
> projects if the query method takes too long to wait for the user
> (complcated procedures, AS400 access, whereas the whole table is pulled to
> the SQL Server ....)
>
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
> "J-T" <J-T@microsft.com> schrieb im Newsbeitrag
> news:uZOUEeFcFHA.3048@TK2MSFTNGP12.phx.gbl...
>>I create an snapshot programmatically with default paramters for a report
>> which takes 2 minutes to run.the snapshot takes the same time and the
>> only
>> things the snapshot dose it that it dosen't let me change the
>> parameters.They are all grayed out.Is that what it should be?
>>
>> Thanks
>>
>>
>
>