Default Value for Paramters

HI,
I set the default value for the report, but it doesn't show at runtime.
what is the problem? any work around trick?
Thanks
KenHour posting is a bit vague. Could you give a bit more detail? What kind of
parameter is it - date, boolean, number? Have you defined available values
based on a query or as an entered list? How have you set the default - from a
query or non-queried? If non-queried what expression have you used?
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"SQLKen" wrote:
> HI,
> I set the default value for the report, but it doesn't show at runtime.
> what is the problem? any work around trick?
> Thanks
> Ken
>|||thank you for answering my question.
the issue is any parameter value doesn't populate in the parameters.
But let deal with just one right now.
I have a datetime parameter.
I populate the default value as today's date( using getdate() function
in my sql)
the dataset is working however, at runtime, it doesn't show that value.
thanks
ken
magendo_man (donotspam) wrote:
> Hour posting is a bit vague. Could you give a bit more detail? What kind of
> parameter is it - date, boolean, number? Have you defined available values
> based on a query or as an entered list? How have you set the default - from a
> query or non-queried? If non-queried what expression have you used?
> --
> Magendo_man
> Freelance SQL Reporting Services developer
> Stirling, Scotland
>
> "SQLKen" wrote:
> > HI,
> > I set the default value for the report, but it doesn't show at runtime.
> > what is the problem? any work around trick?
> >
> > Thanks
> >
> > Ken
> >
> >|||I take it that the default for this datetime parameter is based on a query.
If this query dataset is simply based on something like SELECT GETDATE() as
MYDEFAULT DATE Date you might be best to make your your default non-queried
and use an expression like =Now() or =Today() in the report parameter
definition.
Another suggestion: In your report parameter definition have you got
anything in the "Prompt" field? If this is blank then you have what is called
a hidden parameter which does not display anything at runtime. Just enter
something meaningful in the prompt field and you'll see the default value at
runtime!
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"SQLKen" wrote:
> thank you for answering my question.
> the issue is any parameter value doesn't populate in the parameters.
> But let deal with just one right now.
> I have a datetime parameter.
> I populate the default value as today's date( using getdate() function
> in my sql)
> the dataset is working however, at runtime, it doesn't show that value.
> thanks
> ken
> magendo_man (donotspam) wrote:
> > Hour posting is a bit vague. Could you give a bit more detail? What kind of
> > parameter is it - date, boolean, number? Have you defined available values
> > based on a query or as an entered list? How have you set the default - from a
> > query or non-queried? If non-queried what expression have you used?
> >
> > --
> >
> > Magendo_man
> >
> > Freelance SQL Reporting Services developer
> > Stirling, Scotland
> >
> >
> > "SQLKen" wrote:
> >
> > > HI,
> > > I set the default value for the report, but it doesn't show at runtime.
> > > what is the problem? any work around trick?
> > >
> > > Thanks
> > >
> > > Ken
> > >
> > >
>