Home » SQL & PL/SQL » SQL & PL/SQL » Reports in SQL
Reports in SQL [message #188116] Thu, 17 August 2006 03:17 Go to next message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi,
I have to create a report from Crystal report in SQLPLUS. I have to display the same format that is break on groups and ther things.
Please advice as where can I get good documentation on this.

Thanks,
Mona
Re: Reports in SQL [message #188120 is a reply to message #188116] Thu, 17 August 2006 03:27 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is SQL*Plus command summary; reporting is to be done using those commands (for example, TTITLE, BREAK, COLUMN, BTITLE, ...).

However, I wouldn't expect SQL*Plus reports to look *exactly* the same as the ones created by advanced reporting tools (Reports Builder, Crystal Reports), unless - of course - they are relatively simple. For things that those tools do easily ("press a button and here it is"), you'll have to, actually, write a code to achieve the same.

Not that it is impossible, but is less convenient.
Re: Reports in SQL [message #188170 is a reply to message #188120] Thu, 17 August 2006 06:13 Go to previous message
monasingh
Messages: 229
Registered: May 2006
Location: Mumbai
Senior Member

Thanks Littlefoot,
this will help me out with what I need.
Previous Topic: Data migration from One table to another
Next Topic: Tree Structure query
Goto Forum:
  


Current Time: Sun Dec 04 04:52:44 CST 2016

Total time taken to generate the page: 0.07094 seconds