Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeanneZhang
Starting Member
5 Posts |
 Posted - 2007-12-28 : 12:01:18
|
| I have create a report with date parameters -- @FromDate and @ToDate.The report requested if @FromDate is null and @ToDate is null, will useGetDate()-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 orGetDate())".Thanks a lot for any help.Jeanne |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-29 : 11:01:26
|
| Try this:-="Rental Date from "+ Parameters!FromDate.Value + "to " + Parameters!ToDate.Value Also set the default values of both parameters to today. I guess it will provide you with the required header. |
 |
|
|
|
|
|
Expression in report header