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.