<p>Hi All,</p>
<p> </p>
<p>I am very new to BIRT, I am preparing a BIRT Report my Requirement is to get the totals of the accounts. so my query looks like </p>
<p> </p>
<p>Select Account_Type, count(1)</p>
<p>from accounts</p>
<p>group by Account_Type</p>
<p>order by Account_Type.</p>
<p> </p>
<p>Account_Type column is integer column which contains the code, but in my Report I need to show the Account_name instead of Account_Type.</p>
<p> </p>
<p>Please help..</p>
<p> </p>
<p>Also tell me where can I search the forum for related old posts.</p>
<p> </p>
<p>Thanks in Advance</p>
<p> </p>
<p>Sas</p>
<p> </p>
