How do I include a "variable" on a report?

I am very new to BIRT. I'm trying to build a simple report, listing customers and their addresses. The problem is, I don't know how to get a variable, based on a formula, to print on the report. For example, I want to concatenate the city, state, and zip code fields. I've created a variable with the following script:

BirtStr.concat(row["bill_city"],", ",row["bill_st"]," ",row["bill_zip"])

However, the variable won't "drag 'n drop" to the report. What am I doing wrong?

Thank you,

Merrill

Find more posts tagged with

Comments

BWill

I just saw this post here - it seems to answer your question..<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/16772-concatenation-multiple-columns.html'>http://www.birt-exchange.org/forum/designing-birt-reports/16772-concatenation-multiple-columns.html</a><br />
<br />
Hope it helps.

Virgil Dodson

Generally, create the same concatenation in a computed column on the data set itself.