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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
2 Groups per Page
- Thread starter potdar
- Start date
Dear Potdar,
If you don't mind that the first page of the report is blank, I have a solution.
Use the format section for the group you want to print two per page. My assumptions are that you are not showing or that there is not alot of data in the details section which would push stuff over to another page.
Choose Format Section for the Group you want two records per page to appear.
On the New Page After click the formula editor button next to it and enter:
Remainder(Groupnumber,2)>0
Click save and exit button.
Now on the New Page Before item click the formula editor and enter:
if pagenumber = 1 then groupnumber =2
The above may not make sense since it blanked the first page, but I tried many different formulas and this seemed like the best result as you can make the first page like a title page with the report header.
Other formulas I tried (if you're interested, post back and I will post them for you) resulted in:
1 record for first page and 2 for each subsequent page.
2 records on first page, 1 on page 2 and then 2 on each subsequent page.
2 on first page, blank 2nd page, and 2 on each subsequent page.
So I thought I would post what seemed to me the best one.
Hope this helps,
ro
Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
If you don't mind that the first page of the report is blank, I have a solution.
Use the format section for the group you want to print two per page. My assumptions are that you are not showing or that there is not alot of data in the details section which would push stuff over to another page.
Choose Format Section for the Group you want two records per page to appear.
On the New Page After click the formula editor button next to it and enter:
Remainder(Groupnumber,2)>0
Click save and exit button.
Now on the New Page Before item click the formula editor and enter:
if pagenumber = 1 then groupnumber =2
The above may not make sense since it blanked the first page, but I tried many different formulas and this seemed like the best result as you can make the first page like a title page with the report header.
Other formulas I tried (if you're interested, post back and I will post them for you) resulted in:
1 record for first page and 2 for each subsequent page.
2 records on first page, 1 on page 2 and then 2 on each subsequent page.
2 on first page, blank 2nd page, and 2 on each subsequent page.
So I thought I would post what seemed to me the best one.
Hope this helps,
ro
Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question