on 04-27-2009 7:03 AM
Hi,
I have the following sample tables
ACCOUNT Table :
ACCNUM ACCTYPE ADDRESS
A101 FIXED ADD1
A102 RECURRING ADD2
A103 FIXED ADD3
A104 RECURRING ADD4
A105 SHORT TERM ADD5
A106 SHORT TERM ADD6
ACCOUNT DETAILS TABLE:
ACCNUM BALANCE
A101 23456
A102 12345
A103 34567
A104 12237
A105 45767
A106 56789
As like above tables i want the following detalis in the report look like
ACCNUM FIXED RECURRING SHORT TERM
A101 23456
A102 12345
A103 34567
A104 12237
A105 45767
A106 56789
can u give solution how to format like above in the desktop intelligence .
i will really appreciate u r solution.
regards
sekhar
Sekhar,
That shouldn't be much of a problem. Assuming you have a universe where the join between the 2 tables are defined or you use a free standing SQL where you defined the join yourself.
Now you have 2 solutions:
1. create a crosstab with ACCNUM for the rows and ACCTYPE for the columns and put the BALANCE in the body of the crosstab
2. create a table where you add for each of the ACCTYPE columns the following formula (eg. for column FIXED)
=<BALANCE> where (ACCTYPE = "FIXED")
Regards,
Harry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Harry,
As specified i worked out but in case of crosstab it was not working because of if acctype amount is not there it will not showing as column when have data then only it is fine,in second case it was good in this case it was working with fine but all the accnum are showing when no data exist for acctype.
Thankful for given solution
Regards,
sekhar
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.