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: E-mail through Pl/SQL
Next Topic: Very Slow Response Time
Goto Forum:
  


Current Time: Sat Aug 19 13:55:15 CDT 2017

Total time taken to generate the page: 0.10382 seconds