OLE Object always creates a blank page at end of report

[Repoman]

Hi,

I have a problem that seems consistent in many of my reports. The reports are comprised of several OLE objects, graphic files (signatures) and Word Docs. The Word docs are necessary because they are standard forms that are used within the organization and change over time. Rather than recreate the forms and have subtle differences in their appearance, we are inserting them into the Crystal Reports. Also, multiple docs are added to a single report so that the users can print all of them at once either for a single recipient (patient) or for multiple recipients who will arrive in any given day (if that makes sense). Demographic information is pulled from the database and added to sections on the report where you would normally write it in. The problem I am seeing is that if an OLE object is added to the last page of the report, an extra blank page is generated. If the OLE object is removed, the problem goes away. We are running Crystal XI and delivering the reports via the web interface. However, the problem appears in the designer as well. Suppress Blank Page is checked on all sections. The only sections used are the Detail and Page Footer. Removing the footer does not resolve the problem. I am expecting something simple is going on, but can't seem to put my finger on it. Any help would be greatly appreciated. This problem is beginning to grate on our nerves.

 

[lbass]

If you are not using the report footer, then suppress it.

-LB

 

[Repoman]

lbass,

Thanks for replying. I should have notated in the post that Report Header, Report Footer, and Page Header are all suppressed. Any other thoughts?

 

[Rapids]

I'm not sure if this will help. I had a similar problem, and none of the posts I read worked. I succeeded, eventually, in tracking down my problem by suppressing each section of my report one by one until the extra page stopped printing. In that way I identified the section causing the problem. I suggest the same approach for anyone who tries the other approaches but continues to have an extra page printing.

By the way, my problem ended up being caused by a box and a line which I had drawn up to the edge of the margins -- nothing one could see just by looking at it. I had to move those in slightly to "fix" the problem. Good luck tracking yours down.

 

[harsha]

dear Repoman,
what ever u r doing is exactly what i m looking for i.e. i have about 16 formats of reports which can be changed over a period of time by the user. A group of reports are attached to individual type of customer, so for a customer may be 1,2,3,5,6 and 7 no reports to be printed and for other, another set is to be printed. But in all there r 16 reports. They need a facility to format the reports at their will (as can be done in msword). i have to incorporate this in vb6 and access db and cr9. How do i approach it. I thought about mail merge but then how to allow the user to modify the report and also to save this format for that particular entry, so while reprinting the docs the format, it prints in the same format as was used at the time of entry.
can any body suggest anything.
Darkages.