Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Crystal Reports Space Every 5

Do you remember green bar paper?  5 rows of information would typically be on a white background, then 5 rows on green.  When that went away, I missed the alignment for my eye.  Being told it was better, I got used to not having it, but I still miss it.

Years ago I made this up, I forget to use it, maybe since it's here I'll remember to use it more often.  It should just be a part of the starter template. I like the way it makes a report more readable, the eye can stay on a line much easier with the breaks in the page.

To put a Space every 5 records, image

Create a Running Total called Space 5, Summarize FirmFile

  • Type of Summary Count
  • Evaluate for Each Record
  • Reset Never. Or on Grouped Reports Reset on Group

Thenimage

Insert a new Details section, Right click on Details, select inset section below,

Right click again, and select Section Expert.

 

 

Select Details B, then push the  image Button on the Suppress (no Drill-Down) line

Insert as formula

If Truncate( {#Space5} /5) - ( {#Space5} /5 ) = 0

Then

    False

Else 

    True

 

The formula appears to be backwards, however the correct result is given by Crystal (Unless you check the box by the image button)  If you get 4 spaces and 1 not space, flip the true and false.

Save it and after every 5th line will be blank line splitting the report into easier to view report.  You can break by other numbers by changing the divisor from 5 to something else in the formula.  I like 5 as I also count records sometimes, and that makes it easy.

To get a true green bar look. You could duplicate the Details fields, grey the background on one of them, Then toggle them on even and odd lines, so one details line would print on even and the other on odd.  Just a note, to get the finest grey, I used to use a light yellow, it would print lighter than the lightest grey.  I still use an HP4 printer so your mileage might vary on newer machines.

Help support the site when shopping on Amazon, click through any ad to get to Amazon, ignore that product, then buy whatever you're there for. Thanks for helping out.
Category: General
Tag:

Your email address will not be published. Required fields are marked *

*

css.php