Limit number of rows in Down & Across multi column layout 1

[tjmare]

I am creating an invoice using a multiple column crystal report with totals at the bottom. We use a down and across format for faster checking. The problem is, the down and across doesn't limit the number of rows down. This is a real issue because it wastes paper as the total shows up on a 2nd sheet of paper when it could easily fit on one if I could equalize the number of rows & columns on one page. I'm surprised there isn't an easy way to deal with this issue. For example, instead of 2 columns of 60+ items, I could set it to 24 items per column (5 columns), leaving lots of room at the bottom for totals. Is there a formula that can handle this? NewPage didn't equalize the rows per columns only put it to a new page after 60 rows were printed in 2 columns.

 

[BettyJ]

In which section of the report are the totals being displayed?

 

[pmax9999]

I think the only way to achieve this would be to increase the size of the Page Footer (or Page Header, or both) section(s) so as to minimise the amount of space allocated to other sections. This would take some trial and error, but what you want should be achievable.

Hope this helps.

Cheers
Pete

 

[tjmare]

BettyJ: These are grouped by customer so the totals are running in the Group footer section.

 

[tjmare]

I did already try to play with the page footer. The larger I make it, the faster the invoices gets pushed to a second page. I need to figure out a way to limit the number of rows down in the detail section. I thought there might be some formula that could count records and then start a new column after N # of records? As mentioned, I very surprised that there seems to be no solution to this issue.

 

[BettyJ]

Try if this works:
In the Details section, Check New Page After and add the following condition.
[tt]remainder(recordnumber,120)=0[/tt]

Then as pmax9999 suggested the page footer can be adjusted so you can view 24 records in each column. (make sure the width of the column is adjusted to accommodate 5 columns).

 

[tjmare]

Will give that at try.

 

[tjmare]

Check marked New Page After adding above formula, increased page footer dramatically - does not provide desired effect. Played with the page footer. No matter what I did, the totals still went to page two. The larger the footer, (or header) the more often page two was produced.

 

[BettyJ]

I was able to do it when I tried a report without any groups using Down and Across and 5 columns with 24 rows in each page. All I did was adjust the Page Footer. Since you have Group Footer, probably you can also try adjusting that instead of the Page Footer. (if you have a Group Footer which takes a lot of space, then probably it has to be made smaller.)

Also, can you provide more details on your report. Do you have multiple groups or just one group?

 

[tjmare]

I have two groupings, group 2 groups customer's purchases, group 1 I'm not sure - I forgot its been so long since I originally designed the report. Here is a screenshot of the format of this report:

http://twindragonnorth.com/crystalreport/reportincr2013.jpg

I'm going to try what you have done - creating a report with down & across without any groups and see if I can reproduce what you have.

Thank you!

 

[BettyJ]

Looking at the screenshot I feel like there is no space to accommodate 24 rows.

Try if you can accommodate a few rows (say 2) in 5 columns. Then the formula will be[tt] remainder(recordnumber,10)=0[/tt]

(In the screenshot, it looks like you have 6 columns. If that is the case then use formula [tt]remainder(recordnumber,12)=0[/tt] )

 

[tjmare]

I have counted how much will fit in the space and I believe I can show up to 32 rows in 6 set of columns. The font size is set at arial 10 and is why I can get so much data on one sheet. I have been able to do this using a legacy program (dos) but I want to move into SQL and crystal reports. I did try this particular formula numerous times in various sizes. As soon as I put a smaller number in here, report only shows that many records on one page (ie if "12" or "10", then only 12 or 10 records show up on each page).

 

[tjmare]

Here is another screen shot of the actual printed invoice. (Unfortunately cropped and not showing the actual 8.5 x 11 on the first page:

http://twindragonnorth.com/crystalreport/invpg1.jpg

And then how much space is left on page 2:

http://twindragonnorth.com/crystalreport/invpg2.jpg

I'm not sure if this helps or not.

 

[BettyJ]

You wrote:As soon as I put a smaller number in here, report only shows that many records on one page (ie if "12" or "10", then only 12 or 10 records show up on each page).

That's how it is supposed to work. You have to put a bigger number. try 144 or 150.

I believe there is not enough space for the Group Footer to be displayed in the first page with that many rows. That's why it is moving to the second page. And in the second page the space is because there are no more records under that group.

I feel it is just a matter of adjusting the section size properly.

 

[BettyJ]

Correcting what I wrote in the last line of the previous post. It's rather probably figuring out how many rows can be displayed in the details section.(or both)

 

[tjmare]

Thank you Betty, I'm just about to leave this project until I return next Monday. I will do a couple more "dummy reports" without grouping to see if I can get it to product equal rows. Although that wont solve my problem. I need to be able to at least group by customer?? Not sure we are on the correct path.