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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Formatting Date in Title of report

Author  Topic 

tdorsi
Starting Member

3 Posts

Posted - 2010-06-15 : 11:30:45
Hello I am very new to using Report builder. I have Version 9.00. I am trying to format add a Date in the title of the report and keep receiving the below error in red.

This is what I currently have:
[]= text box
[Report Dates From] [=dateadd(day,-7,today)] [to] [=(now)]

Expected result
Report Dates From 06/08/2010 to 06/15/2010 11:26 am

error: [BC30455] Argument not specified for parameter 'DateValue' of 'Public Function Day(DateValue As Date) As Integer'. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Value expression for the textbox ‘textbox12’ contains an error: [BC30455] Argument not specified for parameter 'DateValue' of 'Public Function Day(DateValue As Date) As Integer'.
--- End of inner exception stack trace ---


Any assistance would be greatly appreciated.
Tom

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 12:01:27
I know not much about that but I know for example that is has to be today() instead of today


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tdorsi
Starting Member

3 Posts

Posted - 2010-06-15 : 12:21:34
Thanks Fred. I tried your suggestion with the same result. I still receive the above error.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 12:28:27
=dateadd("dd",-7,today())

http://www.lukehayler.com/2009/07/the-dateadd-function-in-ssrs/


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tdorsi
Starting Member

3 Posts

Posted - 2010-06-15 : 12:38:42
No avail. I tried just as you posted above and recieved the error again. This must have something to do with the formula being in the text box. I used this in my Filter and it works fine to pull the date range I need.
Go to Top of Page
   

- Advertisement -