| printing more records on second page of pre-printed report [message #448184] |
Sat, 20 March 2010 05:12  |
wazir
Messages: 18
Registered: February 2010
|
Junior Member |
|
|
Hello All..
I hope all of you will be fine and at the best of your health...
I am faceing a problem while printing record on pre-printed page..
Let me make my problem more simple..
I have to print a report which consist of two records set means one is master and other is detail..
Master Record contains information of company and detail record contain records of items...
Master record prints only on 1st page and after that on same page detail of item will print...(upto here everytng is good)..
on second page i have only detail records but here i have only limited number of records.. why becouse i change the property of repeating group: max records per page to 10 and on second page i got only 10 records...
what i want utilze the whole page means on next page it print more items then 1st one as i have pre-printd page with printed header and footer..
thankx in advance..
|
|
|
|
|
|
| Re: printing more records on second page of pre-printed report [message #448541 is a reply to message #448366] |
Wed, 24 March 2010 00:51  |
wazir
Messages: 18
Registered: February 2010
|
Junior Member |
|
|
@littlefoot 1st of thankx alot for your time...
Sir actully i have continous pre-printed sheets..which are feeded to printer(EPSON LQ-2180).print will come on all the sheets means alll on front said of the sheets..
Example Report is like
Master Record:-
Vendor Name: XYZ Vndor ID : 1234
Address:XYZ Mobile No:0500555555
Detail Record:-
Item_Code Item_Desc Item_Qty Item_Price Total_Prc
1 A 5 5 25
2 B 2 2 4
3 C 1 1 1
4 D 1 1 1
. . . . .
. . . . .
So what is the requirment:-
when report start on 1st page we have master record (print only on 1st page) and then detail record (will print rest of the sheets and we may have detail record from 1 to 1000 items)...
So what i did after printing master record on 1st sheet i have less space left for detail record so i restict the repeating fram to only print 10 records... So finally what happend 1st page comes good but on next sheet(for all rrest of the sheets) i have only 10 record for detail record...
So what i wants is to prints more then 10 record on next sheets...
is there any way that we can tell the reapeating fram that it is now end of page or end of certine point on the page and now go to next page... or some thning like this...
Note..I have pre-printed continous paper sheets with header and footer..i am using epson lq-2180 dot matrix printer.
|
|
|
|
| Re: printing more records on second page of pre-printed report [message #448581 is a reply to message #448541] |
Wed, 24 March 2010 02:44 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Do not restrict number of records; it, obviously, doesn't work.
Here's how I'd do that (example based on Scott's schema).
Data model is as follows: master (department) and details (employees) simulate your situation. I have cross-joined employees in order to get a lot of records per department.
Queries:-- Q1
select deptno, dname, loc from dept -- Q2
select e1.deptno, e1.empno, e2.ename, e2.job
from emp e1, emp e2
Use report wizard to create a default layout; choose "Group Above". This is the result:
Now rearrange it a little bit (so that "master" data looks like a header). I'll move department name and its location one below the other:
This is crucial: group header objects (labels and fields) - select all of them (6 in my case) and press <Ctrl + G>.
Now draw a frame over the group, so that it covers it entirely:
Move that frame backward; if we didn't group header objects, you'd have to move the frame backward as many times as there are objects it should contain. Having a group, we have to do that only once. The result should be as follows (all objects within the frame):
Run the report. Here's how it looks like; notice the dashed line which marks the end of the header section (I've taken it from the ruler).
Page 2 (beginning of the department 20 section):
Page 3 (department 20's second page): header section is empty (as it should be) - detail records follow below:
That's it, I guess.
[Updated on: Wed, 24 March 2010 07:42] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: printing more records on second page of pre-printed report [message #449136 is a reply to message #448184] |
Sat, 27 March 2010 03:37 |
wazir
Messages: 18
Registered: February 2010
|
Junior Member |
|
|
@Little Foot.. yes i got the images and really thankfull for your kind help..
yes this helps me alot but i have still facing problem i.e
i have pre-printed continous pages with pre-printed header
(like letter head on which comany name and other infor printed) and pre-printed footer at the bottom of sheet (i.e all the mailing address, fax no,s , phones # are writen)..
So for header i left the space and it goes well but for footer what i do????becouse after printing master record, i have to print the detail record on the rest of the space aviable (which is quite small) and then go to next page and only print the detal records but between that pre-printed header and footer..
So sir i am again waiting for your valuable comments...
wazir
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
