Is it possible to print a line for each 3 records???

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

Is it possible to print a line under each 3:d record in a report?

I have a report (list) of persons and phonenumbers (Home, Work and Mobil)
sorted on person´s last name/first name (repmembershipPhonelist).

This report is using quit small fontsize (Times New Roman, 8). The report is
also sectioned in two columns so I print two columns of person names and
also (offcource) two columns of each type of phonenumber. This makes it a
little bit tricky to read and I´d like to make it easier for the user to
read this report (it´s a requirement from the user to get as many records as
possible on each page since it´s going to be printed and shiped out to all
members (300 - 400 members)).

Since there is so small font´s it´s not a good idéa to print a line under
EACH record. So I´d like to print it each 3:d or 5:th record! But I d´nt
know if it´s possible and if so how it´s going to be done?

TIA!
// Niklas
 
Niklas said:
Is it possible to print a line under each 3:d record in a report?

I have a report (list) of persons and phonenumbers (Home, Work and Mobil)
sorted on person´s last name/first name (repmembershipPhonelist).

This report is using quit small fontsize (Times New Roman, 8). The report is
also sectioned in two columns so I print two columns of person names and
also (offcource) two columns of each type of phonenumber. This makes it a
little bit tricky to read and I´d like to make it easier for the user to
read this report (it´s a requirement from the user to get as many records as
possible on each page since it´s going to be printed and shiped out to all
members (300 - 400 members)).

Since there is so small font´s it´s not a good idéa to print a line under
EACH record. So I´d like to print it each 3:d or 5:th record! But I d´nt
know if it´s possible and if so how it´s going to be done?
Click to expand...


First you need to know when the report is processing each
third record. This is easily done by adding an invisible
text box (let's name it txtLineCounter) to the details
section. Set its control source expression to =1 and
RunningSum to Over All.

Add a Line control (let's name this one linSeparator) to the
bottom of the detail section.

Now you can add code to the detail section's Format event to
make the line visible or not:

Me.linSeparator,Visible = (txtLineCounter Mod 3 = 0)
 
Thank´s a lot Marshall!

That did it! And yet again I have learnt something new! Havn´t even heard
about RunningSum before.

Thank´s a lot!

// Niklas
 
Back
Top