Home » Developer & Programmer » Reports & Discoverer » I query to give give two out comes side by side.
I query to give give two out comes side by side. [message #122350] Mon, 06 June 2005 02:36 Go to next message
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

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 04 15:29:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.