Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
FPW26 Report laser form
- Thread starter fitedgar
- Start date
As long as the detail data is the same, it's not a problem. Just make the header the same size as the top half, and the footer the same size as the bottom half. Then duplicate everything in both halves.
If you are trying for a different record on each half, you will have to do some coding to print the first record on the top, skip a record and probably use memory variables for the second half.
-Dave Summers-
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
Even more Fox stuff at:
If you are trying for a different record on each half, you will have to do some coding to print the first record on the top, skip a record and probably use memory variables for the second half.
-Dave Summers-
Even more Fox stuff at:
- Thread starter
- #3
Thanks dave,
The first and second halves, have to be the same.
Where do I place the (same) details for the first half and bottom half?
How do i force the details to go on subsequent pages?, for example only 3 details per page.
Thank you in advance
EMC
The first and second halves, have to be the same.
Where do I place the (same) details for the first half and bottom half?
How do i force the details to go on subsequent pages?, for example only 3 details per page.
Thank you in advance
EMC
Make your Page Header the same size as the top portion of the perf paper. Then add the labels, fields, whatever to that area.
Make the Page Footer the same size as the bottom half of the perf paper. You can then select all items from the top half, copy them, then paste them to the bottom half.
By default, when a report form is run, it will skip through the records of the currently selected table. You only design the initail layout and it carries through to the rest of the pages.
-Dave Summers-
Even more Fox stuff at:
Make the Page Footer the same size as the bottom half of the perf paper. You can then select all items from the top half, copy them, then paste them to the bottom half.
By default, when a report form is run, it will skip through the records of the currently selected table. You only design the initail layout and it carries through to the rest of the pages.
-Dave Summers-
Even more Fox stuff at:
- Thread starter
- #5
While you are correct in that you can only print one detail band per report there are ways in which you can organize the data prior to sending it to the Report Form which will group and/or sort the data so that it can appear similar to multiple detail bands.
Consider using a temporary table for your Report data and add additional fields which will not be printed, but which can be used to organize the data into the appropriate "groups".
Additonally you can use these addition fields in Print When... expressions within the Detail band objects to show or not show Report Form objects.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
Consider using a temporary table for your Report data and add additional fields which will not be printed, but which can be used to organize the data into the appropriate "groups".
Additonally you can use these addition fields in Print When... expressions within the Detail band objects to show or not show Report Form objects.
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
- Status
