Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Getting rid of empty page
Versions des environnements
Hi Everyone:
I have a report in which I want to be one page. In the report designer, it appears as 1 page. However, when printed, it also prints a blank second page.
I have done a lot of playing around with it but cannot solve the problem. It appears that the problem occurs because of one field that is printing, which is a memo field from a cursor created from a select statement. When I remove the memo field, i don't have this problem.
The memo field is set to stretch with overflow. If I don't do the stretch with overflow and make the box bigger, the second page doesn't print. However, the downside to this is that I have a few fields on the left side of the page (the memo is on the right side) that are set to not print if blank. if the memo field is extended onto their line, then those fields will print even if blank.
Is there anyway to do an alltrim with a memo field? I've tried it but it doesn't seem to make a difference. I'm open to any other suggestions. For those who do, Thanks!
Paul
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement