some data are not showing with data field concatination

newbie1

<p>Hello guru,</p>
<p> </p>
<p>Today is my 4th days on BIRT, been reading and watching most of the Birt intro videos, and when I try to do this query in my dataset against the sample db:</p>
<p> </p>
<p> </p>
<div>select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER</div>
<div>,CLASSICMODELS.CUSTOMERS.CUSTOMERNAME </div>
<div>, CLASSICMODELS.CUSTOMERS.CONTACTFIRSTNAME || ' ' || CLASSICMODELS.CUSTOMERS.CONTACTLASTNAME as "Contact Name"</div>
<div>, CLASSICMODELS.CUSTOMERS.ADDRESSLINE1 </div>
<div>,CLASSICMODELS.CUSTOMERS.ADDRESSLINE2</div>
<div>, CLASSICMODELS.CUSTOMERS.CITY</div>
<div>, CLASSICMODELS.CUSTOMERS.STATE</div>
<div>, CLASSICMODELS.CUSTOMERS.POSTALCODE</div>
<div>, addressline2 || ' , ' || addressline1 || ', ' || city || ', ' || state || ', ' || postalcode AS " Business Address"</div>
<div>from customers</div>
<div> </div>
<p>As you can see from the print screen, some of the rows are not showing for the "Business Address" Column.  What I would like to do is to have the address in one column  instead of 5 separate columns.  Any help is greatly appreciate.</p>
<p> </p>
<p>Thank you.</p>
<p> </p>

JFreeman

<p>This may be happening because the rows where the "Business Address" is not populated  do not have data in all of the fields you are concatenating.</p>
<p> </p>
<p>Instead of doing the concatenation in the query, you can make a computed column for Business Address and then use some javascript to do the concatenation.</p>