Home » Developer & Programmer » Reports & Discoverer » report layout in 6i (developer 6i report builder 6i, xp)
report layout in 6i [message #411159] Thu, 02 July 2009 03:27 Go to next message
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member

I am designing a report in 6i, which is being printed on a stamp paper or letter head. so i have to leave the blank space on the upper portion of report for letter head which is already printed.

it is working fine.

now the requirment is first page should leave blank space for letter head but next page and onward are printed on simple blank pages, but my report leaves upper portion blank on all page.

My report should leave upper portion blank on first page.
and next pages should be printed properly without leaving any blank space in upper portion. is it possible in 6i report builder???

who can help?

Re: report layout in 6i [message #411183 is a reply to message #411159] Thu, 02 July 2009 05:34 Go to previous messageGo to next message
Messages: 21574
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know about Reports 6i as I don't have it, but I guess that this (10g) approach might help as it doesn't do anything special.

Sample report has been created on Scott's schema. Perhaps it can be simplified, but I'd leave that to you.

I have created a simple query which spans a few pages (Cartesian join of the EMP table, with the additional dummy column which will be later used as a GROUP ABOVE column):
select 'x' dummy, e1.ename, e1.job
from emp e1, emp e2
Data model layout should look like this (drag and drop the "dummy" column to create its own group above the default G_ename group):

Now use Report Wizard to create paper layout. Style = Group Above. Group Field (Level 1) = dummy. Display all fields. The result is

Rearrange the layout: move useful information down (ename and job in our case), so that you'll have enough space at the top for letter head. Drag both M_G_DUMMY_GRPFR and R_G_DUMMY frames up so that they are separated from EMP part of the report:


Delete both DUMMY label and field (as we don't want to print them). Set R_G_DUMMY repeating frame's Vertical Elasticity property to "Fixed". Write its Format trigger as
function R_G_dummyFormatTrigger return boolean is
  l_cur_page number;
  return (l_cur_page = 1);
i.e. print it only on page 1.

Run the report; empty "dummy" frame is displayed on the top of the first page; employees' data follows and continues from the top of every subsequent page:


I'll attach the report itself; though, I'm not sure that you'll be able to open this 10g report with Reports Builder 6i.
Re: report layout in 6i [message #411993 is a reply to message #411159] Tue, 07 July 2009 07:02 Go to previous message
Messages: 12
Registered: June 2009
Junior Member
you can do it with a little bit tricky way

Try to create a rectangle of exact shape which you want to leave for Letter Head's heading part on layout editor. and set its property to print on first page only then choose no line from color pallete.
Then Print virtually it will be printed on first page and data on other page will be printed normally.

HOpe this will work for you

Previous Topic: using operators
Next Topic: Problem in report printing
Goto Forum:

Current Time: Thu Jul 09 04:13:22 CDT 2020