OraFAQ Forum: Reports & Discoverer » I query to give give two out comes side by side.

Home » Developer & Programmer » Reports & Discoverer » I query to give give two out comes side by side.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I query to give give two out comes side by side. [message #122350]

Mon, 06 June 2005 02:36

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

I have a table:-
Tbl_Daily_Account
Col_Sno PK
Col_Account_Head FK Head_Of_Accounts
Col_Description
Col_Cr
Col_Dr
Col_Bal
Col_Date

I want my query to give two out comes side by side on the basis of DR, CR (i.e. one out come where DR > 0, other where CR>0)group by Col_Account_Head as shown in attached jpg image.

Wishes
Jawad

Attachment: Day Book Report.jpg
(Size: 83.29KB, Downloaded 870 times)

Report message to a moderator

Re: I query to give give two out comes side by side. [message #122395 is a reply to message #122350]

Mon, 06 June 2005 06:26

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Nothing complex I want to two thing.

1. Group the report by “Col_Account_Head” (which is simple)
2. I want to display four columns as follows.(which I want to know)

Col_Description (where Cr >0), Col_Cr, Col_Description(Where Dr>0), Col_Dr

Wishes
Jawad

Report message to a moderator

Previous Topic:	How to hide the username/password in report URL
Next Topic:	How to use two column from different data group?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 07 22:25:44 CDT 2025