Eclipse Community Forums: BIRT » Adding Text to Group field

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

Adding Text to Group field [message #629628]

Tue, 28 September 2010 22:31

Eclipse User

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

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

Tue, 28 September 2010 23:33

Eclipse User

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.

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

Wed, 29 September 2010 00:19

Eclipse User

Got it to work, just removed the tostring
"Date: " + dataSetRow["transdate"]

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

Wed, 29 September 2010 00:21

Eclipse User

Thanks Richard

Previous Topic:	BIRT in eclipse without design IDE
Next Topic:	Different icons for folders in CN

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 21:07:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter