Home » Developer & Programmer » Reports & Discoverer » To break a report while printing on file
To break a report while printing on file [message #89136] Thu, 16 October 2003 03:06 Go to next message
Priyanka Syal
Messages: 1
Registered: October 2003
Junior Member
How can I print a report to a excel file ,such that if file exceeds 60,000 rows, file should break at that row count and associated files ran for remainder.

Report message to a moderator

Re: To break a report while printing on file [message #89137 is a reply to message #89136] Thu, 16 October 2003 05:07 Go to previous message
Bhavin Mehta
Messages: 18
Registered: October 2003
Junior Member
You can use Oracle Reports BuiltIn Package TEXT_IO to create a text file which can be opened with excel.
(see Reports help for procedures inside this package)

You can use this package in your "before report trigger". Try to run a loop, increment a variable after each record and open new file after every 60000 records. Be careful while giving path of the file.

See documentation more details/ examples on text_io.

Report message to a moderator

Previous Topic: cant see a view - unbelievably urgent
Next Topic: PROBLEM IN REPORT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 03:16:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.