Help needed in conditional formatting

[unknownly]

Hi All,
This is what I have
Oracle database: I have 3 tables
---------
table 1
---------
parent_acct account //2 fields...with sample data
---------- --------
A11111 A10000
A11111 A10100
A11111 A10200
A22222 A20000
A22222 A20100
-------
table2
-------
Account Descr // 2 field ...with sample data
-------- ------
A10000 some descr
A10100 another descr
A10200 Account descr
A11111 Parent Account descr
A20000 sample descr
A20100 another sample descr
A22222 another Parent descr
---------------
table3
---------------
Account totals //2 fields ..sample data
-----------------
A10000 $ 999999
A10100 $ 999999
A10200 $ 999999
A20000 $ 999999
A20100 $ 999999
// Parent accounts doesn't have any totals or transaction in table 3

I have to create a report which should be showing

Account description totals
-----------------------------------------------------------
A10000 some descr $999999
A10100 another descr $999999
A10200 Account descr $999999
A11111 Parent Account descr sum( above 3 rows)
A20000 sample descr $999999
A20100 another sample descr $999999
A22222 another Parent descr sum( above 2 rows)


//Where ever the parent account occurs I need to do a bold font. How I can I do this.

My SQL doen't even work.. Can I get some help on this too, Please.
When Iam joining the table1 & table2 I get only the 3 rows(from the sample data) for that A11111 parent account
I don't get the parent account which exists in Table 2( I did the Outer join too but doen't help).

Any help is greatly appericated

Thanks,
Sweety pie

 

[lbass]

I would try creating an alias for Table 2 (just go to Database->Add Database to Report and add Table 2 a second time) and then link {Table1.Acct} to {Table2_A.Acct} and link {Table1.ParentAcct} to {Table2_B.Acct}. Also link {Table1.Acct} to {Table3.Acct}. There is nothing in your post which suggests you need an outer join--it looks like for every instance of a field in one table, there is an instance in the linked table, so I would start with an equal join.

You should then be able to lay out your fields as you have shown. I would group on {Table1.ParentAcct}, and then to get the sum of {Table3.Total}, just right click on the that field in the details section and insert a sum on it.

You can bold the Group Footer section by selecting all the fields (click on one and hold down the shift key until all are selected), and then just click on the bold icon in the toolbar.

That should do it. If this doesn't work for your requirements, please let us know the results you get when you try this, so that someone can help you further.

-LB

 

[unknownly]

Lbass,

Thank you very much.