Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

report

steven chang_1
Regular Advisor

report

rem Name: activity.sql Type: start file report
rem Written by: G. Koch
rem
rem Description: Report on G. B. Talbot sales by product
rem during second half of 1901.
set headsep !
ttitle 'Sales by Product During 1901!Second Six Months (Jul-Dec)'
btitle 'from G. B. Talbot"s Ledger'
column Item heading 'What Was!Sold'
column Item format a18
column Item truncated
column Person heading 'To Whom Sold' format a18 word_wrapped
column Rate format 90.99
column ActionDate heading 'Date'
column QuantityType heading 'Type' format a8 truncated
column Quantity heading 'Quan' format 9990
column Ext format 990.99
break on Item skip 2
compute sum of Ext on Item
set linesize 79
set pagesize 50 set
newpage 0
spool activity.lst
select ActionDate, Person, Item, Quantity, QuantityType,
Rate, Quantity * Rate AS Ext
from Ledger
where Action = 'SOLD' /* last 6 months only */
and ActionDate BETWEEN
TO_DATE('01-JUL-1901','DD-MON-YYYY') AND
TO_DATE('31-DEC-1901','DD-MON-YYYY')
order by Item, ActionDate;
spool off
steven
5 REPLIES
Rainer von Bongartz
Honored Contributor

Re: report


Interesting post, only what do you want to know ???


Regards
Rainer
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
David_246
Trusted Contributor

Re: report

looks like his english is bad Rainer, that's why he tries to programm what he wants to say.

Anyway, it didn't work :(

Any Retry ?

Regs David
@yourservice
steven chang_1
Regular Advisor

Re: report

sorry!!
it's just for reference myself for oracle
report template. Nothing I want to know. Thank you for your attention!!!

steven chang
steven
Michael Steele_2
Honored Contributor

Re: report

Absolutely confusing.
Support Fatherhood - Stop Family Law
Zafar A. Mohammed_1
Trusted Contributor

Re: report

If its for your reference only, then it's not a free drive storage dear.