October 11, 2007 at 8:11 am
I need to input an expression into my report using designer how would i write
>= 20/09/2007
I get wrong simtax error
please help
October 12, 2007 at 7:43 am
Sorry, but can you be more clear on your question as to what is your exact requirement.
Prasad Bhogadi
www.inforaise.com
October 12, 2007 at 7:49 am
If you want to display something like >= 20/09/2007 on your report you need to have the expression as =">= 20/09/2007"
Prasad Bhogadi
www.inforaise.com
October 18, 2007 at 4:21 am
Hi
I need to get back data which is >=20/09/07 so i need this to be a filter.
October 19, 2007 at 6:10 am
Why don't you modify your stored procedure to accept the filter date and run the sp and display the retrieved data on the report. Sorry if I am missing anything here.
Prasad Bhogadi
www.inforaise.com
December 31, 2007 at 5:07 am
hi,
well you can change format of your date when you write expression by extracting date part from your date. Or you can change stored procedure date format so that it will accept dd/mm/yyyy.
In SP, you can change format as below.
dbo.FormatDateTime(your date field say startdate,'YYYY-MM-DD')
You can change date format in expression as below.
DatePart("d","Parameters!startdate.Value) & "/" & DatePart("m",Parameters!startdate.Value) & "/" & DatePart("yyyy",Parameters!startdate.Value) & " and " & DatePart("d",Parameters!enddate.Value) & "/" & DatePart("m",Parameters!enddate.Value) & "/" & DatePart("yyyy",Parameters!enddate.Value)
Here u need to pass your date value instead of parameters!startdate.value.....
hope this helps.
Vijay
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply