Home » Developer & Programmer » Reports & Discoverer » Reports gets closed (Report Builder 10.1.2.0.2)
Reports gets closed [message #536836] Fri, 23 December 2011 05:02 Go to next message
sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India
Member
Hi,
I've created report to generate letters,my query contains records more than 1000 while generating report it shows report progress
"Formatting Page 1000" after that report builder gets closed without any error message,I've tried for 10 records it is working fine, please suggest how to handle for large number of records.


Thank You.

Report message to a moderator

Re: Reports gets closed [message #536902 is a reply to message #536836] Fri, 23 December 2011 15:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which operating system do you use? What is the destination? A file? What kind of it (a PDF)? Is there enough memory (both RAM and hard disk)?

Report message to a moderator

Re: Reports gets closed [message #536910 is a reply to message #536902] Fri, 23 December 2011 21:59 Go to previous messageGo to next message
sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India
Member
Sir,

I'm using windows XP professional, file type is PDF, & system memory is 1 GB & around 40 GB is free hard disk space.

Report message to a moderator

Re: Reports gets closed [message #536935 is a reply to message #536910] Sat, 24 December 2011 03:49 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you run the report from Reports Developer, using its default output (i.e. screen)? Does it finish successfully?

Report message to a moderator

Re: Reports gets closed [message #536937 is a reply to message #536935] Sat, 24 December 2011 03:53 Go to previous messageGo to next message
sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India
Member
Sir,

While generating report by default "generate to file >PDF" options reports generated successfully,while using distribute option around 300 records file generated successfully, but when I'm trying for more records like 1500 it after some time report builder get terminated without any message.

Report message to a moderator

Re: Reports gets closed [message #536938 is a reply to message #536937] Sat, 24 December 2011 03:56 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you could always run it in batches (300 by 300, until there are no more pages to be created).

Report message to a moderator

Previous Topic: Rep-1213
Next Topic: Building Reports in Dev. Report 10g with Ref Cursor Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 06:28:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.