Eclipse Community Forums: BIRT » Adding Text to Group field

Help

Home

Home » Archived » BIRT » Adding Text to Group field(Conatinating text and date)

Show: Today's Messages :: Show Polls :: Message Navigator

Adding Text to Group field [message #629628]

Wed, 29 September 2010 02:31

Chris

Messages: 47
Registered: September 2010

Member

Hi I have grouped the data for my report by date, which works.
datatype is Date
expression is dataSetRow["transdate"]
However I now wish to have the group show
Date: 02/01/2010.

I changed he datatype to String and
the data expression to
"Date: " + toString(dataSetRow["transdate"])

This does not work. Could anyone help please.

Thanks
Chris

Report message to a moderator

Re: Adding Text to Group field [message #629630 is a reply to message #629628]

Wed, 29 September 2010 03:33

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

There's probably a way to ode for this using a SimpleDateFormat call - I've seen string to date discussed so the reverse should be possible. I generally just code for this in the underlying SQL for simplicity. You can't use ToString because there's no single correct way to convert a date (or date-time) type to string.

This might be a good item for a BIRT reporting tips and tricks FAQ. If I get another stretch of time where I'm not terribly billable, I'll see what I can add.

Report message to a moderator