Eclipse Community Forums: BIRT » Concatenating strings in a dataset

Home » Archived » BIRT » Concatenating strings in a dataset

Concatenating strings in a dataset [message #259077]

Tue, 23 October 2007 07:20

Eclipse User

Originally posted by: steve.eastman.ncmail.net

I would like to be able to concatenate strings in a dataset. Is there a
way to do this with Birt?

Re: Concatenating strings in a dataset [message #259095 is a reply to message #259077]

Tue, 23 October 2007 11:10

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Steve,

You can add a computed column that combines existing columns using the
BIRT expression builder.

Jason

Steve Eastman wrote:
> I would like to be able to concatenate strings in a dataset. Is there a
> way to do this with Birt?
>

Re: Concatenating strings in a dataset [message #259271 is a reply to message #259095]

Wed, 24 October 2007 08:36

Eclipse User

Originally posted by: steve.eastman.ncmail.net

Thanks, Jason, but I guess I did not state my question clearly enough. I
have a column of strings and would like to combine them into a single long
string. It's similar to how BIRT allows you to Sum numbers in a column,
except this would be concatenating strings in the column. Any ideas on
this one?

Thanks--Steve

Re: Concatenating strings in a dataset [message #259300 is a reply to message #259271]

Wed, 24 October 2007 11:24

Eclipse User

Steve,

Is this a one time operation, you could create a globalPersistentVariable
and just keep concatenating the strings into it. Kind of ugly but it should
work. If this is something that you want to use on a more consistent basis,
I would recommend extending the Aggregate Extension Point.

This extension point allows you to extend the Total... function. If your
function was named Total.sumString, then users would just invoke it through
the expression builder or the aggregate builder.

Scott Rosenbaum

> Thanks, Jason, but I guess I did not state my question clearly enough.
> I have a column of strings and would like to combine them into a
> single long string. It's similar to how BIRT allows you to Sum
> numbers in a column, except this would be concatenating strings in the
> column. Any ideas on this one?
>
> Thanks--Steve
>

Re: Concatenating strings in a dataset [message #259440 is a reply to message #259300]

Thu, 25 October 2007 07:48

Eclipse User

Originally posted by: steve.eastman.ncmail.net

Thanks, Scott I will definitely pursue yur second approach.
Steve

Re: Concatenating strings in a dataset [message #259459 is a reply to message #259440]

Thu, 25 October 2007 10:20

Eclipse User

Steve,

If you want an example, I have one for you out on my Subversion server.
Use the subclipse plug-in to login to

http://longlake.minnovent.com/repos/birt_example (anonymous read access)

Checkout the com.innoventsolutions.birt.aggregate project.

Scott Rosenbaum

> Thanks, Scott I will definitely pursue yur second approach. Steve
>

Previous Topic:	Long string is truncated not wrapped
Next Topic:	where is the console?

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Aug 07 21:18:37 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter