nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Column Alias

SasDWH · 2016-03-09T01:05:52+00:00

Hi All, 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 Select Account_Type, count(1) from accounts group by Account_Type order by Account_Type. Account_Type column is…

SasDWH

Hi All,
 
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 
 
Select Account_Type, count(1)
from accounts
group by Account_Type
order by Account_Type.
 
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.
 
Please help..
 
Also tell me where can I search the forum for related old posts.
 
Thanks in Advance
 
Sas

Find more posts tagged with

Comments

pricher

Hi,
 
This is more a SQL question than a BIRT question...
 
Without knowing your database structure, I'll take a shot in the dark. If the account name is in a different table (named below accounts2), then the following select statement should work:
 
SELECT A2.Account_name, count(*)
from accounts A1 inner join accounts2 A2 on A1.account_type = A2.account_type
group on A2.Account_name
 
Hope this helps,
 
P.

SasDWH

Hi Pricher,
 
Greetings..
 
Here I am attaching a PDF and the .rptdesign.
 
I am doing the counts on Account Types, so I am taking my acct type as my X-Axis and acct no as count. when I generate the report in X-Axis its showing Acct Type like 1001,1002,1003,1004... instead of acct type there I need acct name like Savings, Current, Loan, CreditCard.....
 
 
Regards
Sasikiran.V

pricher

Hi,
 
Thanks for sending the PDF, but the report design was not attached. Anyhow, if account_name is part of your data set, simply use account_name on the X-Axis. Unless I am missing something...
 
P.