Conditional Repeat Section

M

malcolmliz

Hello and TIA

Can I set up a label to be printed only if there is data on a page? I
have a report with several agencies, I've setup the Agency Group with
a label and set the repeat section to yes. The problem I have is that
I am going to duplex print and if the page is blank I don't want an
agency label. Currently the Agency label prints on every page.
Thanks, Liz
 
C

Clifford Bass

Hi Liz,

What is it that determines there will be a blank page? Is there always
one? Or sometimes one with text and sometimes not?

Clifford Bass
 
M

malcolmliz

Hi Liz,

     What is it that determines there will be a blank page?  Is there always
one?  Or sometimes one with text and sometimes not?

               Clifford Bass






- Show quoted text -

Not all Agencies have the same number of clients. I need each Agency
to start on an odd numbered page so that they can each have their own
data. The Agency Group header is set "Repeat Section = Yes". I've
setup this code:

Me.PageBreak28.Visible = Page Mod 1 = 0

The first Agency has 110 clients which fills 3 pages (1, 2, 3). The
But the Agency label is printed on page 4 which has no data. This is
what I am trying to avoid - a page with an Agency name where there is
no data.

Thanks for any help.

Liz
 
C

Clifford Bass

Hi Liz,

Try setting the visibility of the label also when you set the page
break's visibility. If it messes up the pages that have information, try
doing it in the group footer. Sometimes it is kind of tricky to get it to do
exactly what you want so play around with placing the code in various
headers/footers. Test using print preview and also actual printing, because
those actions do not work exactly the same. I know it is possible to get it
to work. So post back if your attempts fail.

Clifford Bass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top