Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blank Records 1

Status
Not open for further replies.

Frank2002

Programmer
Dec 6, 2002
5
GB
How can i add blank records after filled records in detail section? Ex: after 6 filled records i want to add 3 blank ones.

Thanks for your help.
Frank.
 
I'll assume that a blank record just means an empty line:

Create a counter in the detail, add in three additional sections which are suppressed unless this counter / 6 = int(counter / 6).

The counter would look something like:

whileprintingrecords;
numbervar MyCounter;
MyCounter:=MyCounter+1

If you have a group, reset this variable in the group.

If not, you might just use :

recordnumber / 6 = int(recordnumber / 6)

in these additional sections.

-k kai@informeddatadecisions.com
 
How can i turn off the supress section state with Crystal?.
So in these case i would need 8 sections after detail (they are 9 lines)?
Why do you need MyCounter? Recordnumber gives you the total records in the section bellow, isn't it?

Thanks again for your help.
 
No, you want 4 sections, the additional 3 would remain suppressed until you hit a row divisable by 6.

To add a section:

Right click the section->Insert Section Below

to suppress the new sections conditionally (sections B - D):

Right click the section->Format Section->Click the X-2 alongside suppress.

recordnumber / 6 <> int(recordnumber / 6)

-k kai@informeddatadecisions.com
 
At the end i add a section with a blank formula and in
-> format Section->Click the X-2 alongside suppress i added recordnumber=9. Both following your advices.

It works great!
Thanks for your help.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top