This year I created a 1099 reporting module for our accounting system. One issue I came across occurred when I was pulling the information from Microsoft SQL into a Crystal Report. I couldn’t find a nice, clean way to print two 1099s per page. Then it hit me. I could have two detailed sections. The first section would contain the fields necessary to display the data. The second section would act as a buffer and add white space to the report so I could print both 1099s on one page. I then came across the issue that every other page was blank. So, this is what I did:
- I created 2 Details sections, an A and B section.
- I added my printable fields to Details A
- I created white space in Details B
- Then, I suppressed the Details B section, but added a Basic Syntax function to the Suppress action. The function looked like this:
1 2 3 4 Dim tmp as Boolean tmp = True If (Remainder (RecordNumber, 2) = 1) Then tmp = False formula = tmp
- I finally made sure that all sections were marked as Keep Together
This would ensure that I could create 2 details sections on a single page. Hope that helps!