Thanks Daniel,
I tried setting the default value of the paramater with a
piece of .net code tha calcualtes the previous months start and end
date. although it seems to work reporting service becomes unstable and
won't let you click in the date field and change the paramaters some of
the time.
I decided to calculate the dates but only to show them in the report
headers and not leave the to and from parameters blank. I have set to
and from paramters as "no defualt" and "allow blanks". This works fine
in visual studio.
Once i deployed the report and try to set execuation schedule Reporting
services comes up with the message "Default report parameter values
are missing". Even if i make all the paramaters values optional it
complains that i haven't given them values.
Any ideas ?
[quoted text, click to view] Daniel Reib [MSFT] wrote:
> You can make your date parameter have a default value that is an expression
> which contains the current date. Then as long as you don't explicitly set
> the parameter, everytime you run the snapshot it will recalculate the
> default value giving you the current date.
>
> To allow other users to run the report ad-hoc, create a linked report to the
> original and have the users run that report.
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> <Josef.Szeliga@nrm.qld.gov.au> wrote in message
> news:1128060517.987036.201970@g14g2000cwa.googlegroups.com...
> >I have created a number of reports that I wish to run in the early
> > hours of the morning so they do not choke our servers.
> >
> > I have based the report on a snapshot which seems to work fine as long
> > as the parameters are fixed. Since this is a monthly report the
> > underlying date parameters change each month. My underlying stored
> > procedure will calcuale the previous months start and end dates if the
> > parameters are blank. However the execution plan for the snapshot
> > won't let me have date parameters that are empty.
> >
> > How can i get around this ?
> >
> > Although i want these reports to run on a shedule i also want the
> > service desk to be able to run these reports ad-hoc ie for other
> > months etc. However, once you link a report to a snapshot you can't
> > change the parameters. How can I have two different modes of running a
> > report.
> >
> > Erick
> >
