<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>
