开发者

Crystal Reports 2008: Convert past date to future date

Crystal version: Crystal Reports 2008

I have a report that I need to reference a past date (9/18/2011) and have any items with that date be "converted" to a future date (10/02/2011). One of my report sections is a group by this date. NOTE: I can't change the date on the DB.

Any ideas?

Currently:
Date:       Project:
9/18/2011   Project1
9/18/2011   P开发者_JS百科roject4
9/18/2011   Project5
9/30/2011   Project2
10/2/2011   Project3

Convert the dates to look like this on the report:
Date:       Project:
9/30/2011   Project2
10/2/2011   Project1
10/2/2011   Project3
10/2/2011   Project4
10/2/2011   Project5


Create a new formula to group-by/display instead:

if {Table.TheDate} = date(2011,09,18) then date(2011,10,02)
    else {Table.TheDate}


//{@date_field}
//replace table.date_field with correct value
IIf({table.date_field} = Date(2011,09,18), Date(2011,10,02), {table.date_field})
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜