CODEWITHSUNDEEP
crystal-reportsmulticol
leafrostar
leafrostar

Reputation: 23

Limit number of rows in Crystal Report down then across per column

The Down then Across doesn't limit the number of rows down, is there any formula to achieve this? I can adjust the footer height to limit the row numbers, but it's not a good way I suppose to do. e.g. I have:

 1_____16  
 2_____17  
 3_____18  
 4_____19  
 5_____20  
 6  
 7  
 8  
 9  
10  
11  
12  
13  
14  
15

Need change to: (Limit the No. of rows to 10)

 1_____11  
 2_____12  
 3_____13  
 4_____14  
 5_____15  
 6_____16  
 7_____17  
 8_____18  
 9_____19  
10_____20

Upvotes: 2

Views: 3682

Answers (1)

haraman
haraman

Reputation: 2742

You can do it as:

  1. Format your report with multiple sections.
  2. Split your details section into two sub-sections e.g. Details a and Details b
  3. Put all required report fields in Details a section only.
  4. In Section Expert of Details b section, enable / check Print at Bottom of Page

  5. Set suppression formula of Details b section as:

    if (RecordNumber mod 10) <> 0 then 
    true
else
    false
  6. Do NOT Suppress Blank Section, New Page Before or New Page After for Details b section

Above formula will print 10 records per column. You can replace 10 with your required number of records per column.

Upvotes: 2

Related Questions