Home » SQL & PL/SQL » SQL & PL/SQL » SQL Report using 2 groupings with label
SQL Report using 2 groupings with label [message #188709] Mon, 21 August 2006 05:01 Go to next message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi,
I have to create a Report using SQL*PLUS.
The report has 2 groups and the data needs to be shown as :
Group 1 Label name : Value
Group 2 Value
HEADING1 HEADING2 HEADING3
Data1 data2 data3

Group 1 Label name : Value
Group 2 Value
HEADING1 HEADING2 HEADING3
Data1 data2 data3

Group 1 Label name : Value
Group 2 Value
HEADING1 HEADING2 HEADING3
Data1 data2 data3

How to derive this kind of format using sql for reporting.
Re: SQL Report using 2 groupings with label [message #188863 is a reply to message #188709] Tue, 22 August 2006 03:54 Go to previous message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi,
I tried and got the result.
Previous Topic: Is there a more efficient way to do this?
Next Topic: How to write the trigger?
Goto Forum:
  


Current Time: Fri Dec 02 14:13:22 CST 2016

Total time taken to generate the page: 0.07958 seconds