| Oracle Report Output size issue (need 0 bytes?) [message #234939] |
Thu, 03 May 2007 09:13  |
vz86mj
Messages: 6
Registered: May 2007
|
Junior Member |
|
|
Hi,
Suppose I have a report with only single labels and nothing else, and I have written a format trigger on this label to return false, so when I will run the report it will give me blank page, but what will be the byte of the output will it be 0 bytes? Is there any way we can get the output from report as 0 bytes so that if auto printer is attached then it should not print anything.
Please help me out from this.
Thanks and Regards,
Sreejit Nair
[Updated on: Thu, 03 May 2007 09:15] Report message to a moderator |
|
|
|
|
|
| Re: Oracle Report Output size issue (need 0 bytes?) [message #235116 is a reply to message #235030] |
Fri, 04 May 2007 02:12  |
vz86mj
Messages: 6
Registered: May 2007
|
Junior Member |
|
|
Hi,
I have given you just an example in my previous mail, suppose my orgainzation had some 15000 orders get process every day and for this if there are some 2000 orders are getting blank output due to the report which is returning a false for the frame and time taking and picking the blank outout out and back to drawer is not justified.
Anyway thanks for reply and I have found the solution too.
Regards,
Sreejit Nair
|
|
|
|
|
|
|
|
| Re: Oracle Report Output size issue (need 0 bytes?) [message #235204 is a reply to message #235162] |
Fri, 04 May 2007 05:50 |
vz86mj
Messages: 6
Registered: May 2007
|
Junior Member |
|
|
Hi All-
There could be three condition of this issue:
1) Running report from oracle APPS11i.
2) Running Report from unix command.
3) Running from report builder runtime.
Solutions:
1)Running report from oracle APPS11i.
One option:
Use the shell script to run the report.Add some text in the report if you are getting it as blank (like "no data found" ) and in shell script check the output file for this text after report call. If the test "no data found", remove the output file and create the same file with using touch command, thus it will be 0 bytes file and no print will happen if auto printer is attached.
Second option:
Write a format trigger on outer frames and labels to return false to get blank output.
But still the output will be greater than 0 bytes as it only hides all the outer frames and labels. To avoid the print even when your output file is blank use the Option field of the executable section of the concurrent program where the report used as BLANKPAGES=NO.
2) Running Report from unix command.
In command line add BLANKPAGES=NO.
3) Running from report builder runtime.
Edit --> Preference --> runtime setting --> uncheck "Blank Pages"
Hope this solution will be useful.
Thanks and Regards,
Sreejit Nair
[Updated on: Fri, 04 May 2007 05:52] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
