Report header expression

I have create a report with date parameters -- @.FromDate and @.ToDate.
The report requested if @.FromDate is null and @.ToDate is null, will use
GetDate()-7 and GetDate().
I have included this condition into report SQL and had no problem.
My question is how to display the dates on the report header.
For example, "Rental Date from (@.FromDate or GetDate()) to (@.ToDate or
GetDate())".
Thanks a lot for any help.
JeanneOn Dec 28, 10:25 pm, "JeanneZhang" <u39996@.uwe> wrote:
> I have create a report with date parameters -- @.FromDate and @.ToDate.
> The report requested if @.FromDate is null and @.ToDate is null, will use
> GetDate()-7 and GetDate().
> I have included this condition into report SQL and had no problem.
> My question is how to display the dates on the report header.
> For example, "Rental Date from (@.FromDate or GetDate()) to (@.ToDate or
> GetDate())".
> Thanks a lot for any help.
> Jeanne
In terms of using an expression to show the conditions, something like
this should help.
="Rental Date from " + iif(Parameters!FromDate.Value Is Nothing and
Parameters!ToDate.Value Is Nothing, DateAdd("d", -7,
Now()).ToString(), Parameters!FromDate.Value.ToString()) + " to " +
iif(Parameters!FromDate.Value Is Nothing and Parameters!
ToDate.Value Is Nothing, Now().ToString(), Parameters!
ToDate.Value.ToString())
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant