problem with printing terms and condions on back side
Hi,
I design a report in crystal reports 2008 and use it in a crystalreport viewer object in visual basic 2008.
My report has several subreports.
Until then everything works well.
Now I want the 'terms and conditions' on the back side of the paper (on a duplex printer offcourse)
So a pageheader is added with the supress option and the formula 'Remainder (PageNumber,2 ) <> 0'.
The pageheader has the size of a full paper.
Now when running is the first page ok, the second also with the terms and condition.
But on the third page the first row is missing. If I make my 'terms and conditions' page bigger i got the error that the size don't fit.
If I make my subreport detail section bigger (that the line that disapears) I have to make my 'terms and conditions' section smaller or the error appears don't fit on the page.
So It seems to me that crystal reports want to set at least 1 line of my subreport on the second page even if the space is so small that there is no visible output of that line.
I hope I did make the case clear to understand.
So if anyone has an solution or workaround please tell me,
Regards,
Luc.
I design a report in crystal reports 2008 and use it in a crystalreport viewer object in visual basic 2008.
My report has several subreports.
Until then everything works well.
Now I want the 'terms and conditions' on the back side of the paper (on a duplex printer offcourse)
So a pageheader is added with the supress option and the formula 'Remainder (PageNumber,2 ) <> 0'.
The pageheader has the size of a full paper.
Now when running is the first page ok, the second also with the terms and condition.
But on the third page the first row is missing. If I make my 'terms and conditions' page bigger i got the error that the size don't fit.
If I make my subreport detail section bigger (that the line that disapears) I have to make my 'terms and conditions' section smaller or the error appears don't fit on the page.
So It seems to me that crystal reports want to set at least 1 line of my subreport on the second page even if the space is so small that there is no visible output of that line.
I hope I did make the case clear to understand.
So if anyone has an solution or workaround please tell me,
Regards,
Luc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, thanks for your quick reply.
frodoman,
I don't understand how the report will working if the T&C are in a detail sections. There are three subreports on the report with each there details sections. One supreport can be on more then one page. The T&C must be on each backside of the page.
In the details sections I only have report header/footer and not page header/footer.
mlmcc,
The only new page after that i have is in the report footer of the main report. I need that one to place the T&C on the last page of the report.
Luc.
frodoman,
I don't understand how the report will working if the T&C are in a detail sections. There are three subreports on the report with each there details sections. One supreport can be on more then one page. The T&C must be on each backside of the page.
In the details sections I only have report header/footer and not page header/footer.
mlmcc,
The only new page after that i have is in the report footer of the main report. I need that one to place the T&C on the last page of the report.
Luc.
ASKER
Hi,
I tried the solution to make a extra details section in the subreport.
But I still lose a line of my report between page 1 and 3.
If i make that extra details section only half page big i lose 2 lines ...
So it seems that the detail line is processed and supressed and that crystal reports go on with the folowing line.
Luc
I tried the solution to make a extra details section in the subreport.
But I still lose a line of my report between page 1 and 3.
If i make that extra details section only half page big i lose 2 lines ...
So it seems that the detail line is processed and supressed and that crystal reports go on with the folowing line.
Luc
ASKER
Hi,
I found the logic from the missing line.
It is after the processing of that line that the pagenumer rises not before.
So a condition pased on a pagenumer only works after that line that is on that page.
As solution I inserted a new detailsection A and there I print one field of the current record so the pagenumer can rise. On the second detail section i print the T&C with supress on the 1-3-.. page and on the third detailsection i print the recordfields.
The field in the first detailsection can be supressed and the pagenumer still rise as you don't supress the blanc section.
So that works now but what if my subreport 1 just ends on a page and my subreport 2 starts on the second page. Now the reportheaders from subreport2 stands on page 2 with T&C under them.
I can make the same construction on the reportheaders but it becomes a pain in the ass the T&C because now i have to put them in de subreport header and subreport details for my 3 subreports and another on the last page of my report (reportfooter). So thats 7 times T&C ...
Is this the best way to work with T&C ?
Thanks,
Luc.
I found the logic from the missing line.
It is after the processing of that line that the pagenumer rises not before.
So a condition pased on a pagenumer only works after that line that is on that page.
As solution I inserted a new detailsection A and there I print one field of the current record so the pagenumer can rise. On the second detail section i print the T&C with supress on the 1-3-.. page and on the third detailsection i print the recordfields.
The field in the first detailsection can be supressed and the pagenumer still rise as you don't supress the blanc section.
So that works now but what if my subreport 1 just ends on a page and my subreport 2 starts on the second page. Now the reportheaders from subreport2 stands on page 2 with T&C under them.
I can make the same construction on the reportheaders but it becomes a pain in the ass the T&C because now i have to put them in de subreport header and subreport details for my 3 subreports and another on the last page of my report (reportfooter). So thats 7 times T&C ...
Is this the best way to work with T&C ?
Thanks,
Luc.
Hi Luc,
Are all of your subreports in the same Details section of the main report? If I'm visualizing your layout correctly it may be cleaner to set up the details sections of your main report with T&C's alternating between subreports (obviously conditionally suppressing the T&C's as needed). You may also want to force a page break between the subreports if you can do that.
I know this whole process is ugly, but Crystal really isn't well-formulated for what you're trying to do. Unfortunately it's going to be a bit of a hack to get it to work.
frodoman
Are all of your subreports in the same Details section of the main report? If I'm visualizing your layout correctly it may be cleaner to set up the details sections of your main report with T&C's alternating between subreports (obviously conditionally suppressing the T&C's as needed). You may also want to force a page break between the subreports if you can do that.
I know this whole process is ugly, but Crystal really isn't well-formulated for what you're trying to do. Unfortunately it's going to be a bit of a hack to get it to work.
frodoman
ASKER
Hi frodoman,
No, my subreports are in three different details sections ...
So T&C in the main report will not work (I think).
Thanks for your reply.
Luc.
No, my subreports are in three different details sections ...
So T&C in the main report will not work (I think).
Thanks for your reply.
Luc.
Okay. Unfortunately it's going to be messy to do this...
ASKER
Thanks for your help with my difficult report !!
mlmcc