- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: report
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2003 01:56 AM
тАО03-14-2003 01:56 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2003 02:09 AM
тАО03-14-2003 02:09 AM
Re: report
Interesting post, only what do you want to know ???
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2003 02:49 AM
тАО03-14-2003 02:49 AM
Re: report
Anyway, it didn't work :(
Any Retry ?
Regs David
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2003 03:34 AM
тАО04-19-2003 03:34 AM
Re: report
it's just for reference myself for oracle
report template. Nothing I want to know. Thank you for your attention!!!
steven chang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2003 04:06 AM
тАО04-19-2003 04:06 AM
Re: report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-21-2003 05:08 AM
тАО04-21-2003 05:08 AM