cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report multiple columns

Former Member
0 Kudos

I'm having trouble with Crystal Report's multiple columns in the detail section.

The details section, the multiple columns is checked then the printing direction is across - down. Since the form I am using is a pre-printed form, by estimation it can only allow at best 30 records in one page, that is 15 in the 1st half of the column and another 15 records on the next. For visual:

Invoice No Invoice Date invoice total Invoice No Invoice Date invoice total

1 16

2 17

3 .

. .

. .

. 28

14 29

15 30

For some reason there is this giant space after the last set of rows before it prints out the page footer. This giant blank section disrupts the layout of the page footer section.

Here are some info on the details section as configuration is involved:

Format with Multiple Columns - checked

In Paging: New Page after 30 visible Records

In Layout: Width: 3.5 in Height: 0.0 in

Horizontal: 0.0 in Vertical: 0.0 in

Printing Direction: Across-Down

Anyone knows how to suppress it or have the page footer move upwards?

P.S To see actual pre-printed form, please download this [http://www.mediafire.com/i/?csu0q75mjynys2k]

Edited by: Khristine Angelei Basilla on Mar 1, 2012 8:34 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks for all the suggestions.

Added the second detail in the group footer thru a sub report.

adjusting it to stay in their "assigned" places is what I'm working out.

Former Member
0 Kudos

Have you checked the section expert for the page footer to see if it is set to print at bottom of page?

Former Member
0 Kudos

Yes, I did. By default it was checked/ticked.

The reports looks like [this|http://www.mediafire.com/?be7uznw9ab1467d]

Former Member
0 Kudos

Consider putting the total at the Group Footer instead of Page Footer.

Page Footer always print at the bottom of the page depending on the paper size.

Former Member
0 Kudos

Now why didn't I try that out. Actually, initial plan was 2 subreports.

So when I added the second subreport in the group footer section, it only prints the details on the last page, which should not be the case as I need to be printed on all pages.

I'll test it out. I'll post an update soon.

Thanks.