Eclipse Community Forums: BIRT » Concatenating strings in a dataset

Help

Home

Home » Archived » BIRT » Concatenating strings in a dataset

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

Concatenating strings in a dataset [message #259077]

Tue, 23 October 2007 11: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?

Report message to a moderator

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

Tue, 23 October 2007 15: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?
>

Report message to a moderator

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

Wed, 24 October 2007 12: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

Report message to a moderator

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

Wed, 24 October 2007 15:24

Scott Rosenbaum

Messages: 425
Registered: July 2009

Senior Member

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
>

Report message to a moderator

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

Thu, 25 October 2007 11:48

Eclipse User

Originally posted by: steve.eastman.ncmail.net

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

Report message to a moderator

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

Thu, 25 October 2007 14:20

Scott Rosenbaum

Messages: 425
Registered: July 2009

Senior Member

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
>

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 14 11:54:09 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter