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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Is there a more efficient way to do this?
Next Topic: How to write the trigger?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 19:30:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.