Report Design: Multi-column report screws up with groups

Print Page | Close Window

Multi-column report screws up with groups

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2138
Printed Date: 03 May 2024 at 1:58am

Topic: Multi-column report screws up with groups

Posted By: BrianBischof
Subject: Multi-column report screws up with groups
Date Posted: 24 Jan 2008 at 10:40pm

I'm have two-column report that needs to use grouping. Unfortunately, CR treats both columns as being part of the same group. It doesn't span down the page completely and then start at the top of the page. It only starts at the top of where the current group started. So the columns are all out of balance. Not only that, but it doesn't even try to put even numbers of labels on each side. It will put ten labels in the left column, and then put five in the right column. It looks ridiculous. Here is a sample:

Group Header 1
Label 1
Label 2
Group Header 2
Label 1 Label 6
Label 2 Label 7
Label 3
Label 4
Label 5

Is there a setting to fix this?

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Replies:

Posted By: rahulwalawalkar
Date Posted: 25 Jan 2008 at 12:51am

Hi Brian,

Is this the output you expecting

British Virgin Islands

Tortola

151 284‑987‑4738

Canada

24 604‑941‑4617

51 604‑298‑4841

60 604‑681‑9443

50 604‑941‑5469

45 604‑685‑0019

222 204‑949‑6053

221 902‑477‑9666

219 416‑766‑5007

223 613‑235‑6617

220 514‑697‑0077

Chile

Providencia

150 56‑2‑2942‑9021

China

Guangdong

226 86‑21‑3492‑3294

Hong Kong SAR

228 852‑4667‑9393

229 852‑3778‑2929

230 852‑3838‑1919

231 852‑3998‑2044

161 852‑6274‑9201

is this what you looking for the first column is customer id and second is telephone number ,

I have grouped on Country and then Region.... with the following settings Details Section Expert Format with Multiple columns selected

then in Layout tab Down then Across selected

Format Groups with Multiple Columns Selected.

Cheers

Rahul

Posted By: BrianBischof
Date Posted: 25 Jan 2008 at 8:56am

Thanks, but I don't think that's it. This looks like a one column report with two fields. I'm trying to do a newspaper format where all the info goes down the first column and then at the bottom of the page it continues onto the second column.

Let me try the sample again:

Header 1      Label 7
Label 1            Label 8
Label 2            Header 3
Header 2         Label 9
Label 3          Label 10
Label 4          Label 11
Label 5          Header 4
Label 6          Label 12

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: BrianBischof
Date Posted: 25 Jan 2008 at 10:07am

I got it working! The answer is very odd though (I don't like how they implemented this at all).

Here's the deal, if you create a report using the Mailing Label wizard and you add groups to it, then you can't do "Newspaper columns" like I'm trying to do. As I showed in the first post, it treats a group as going across all the columns in the page. The option "Down then Across" doesn't look right.

So what you have to do is create a normal report and fit the fields into the desired width of the column size. After doing this, go to Section Expert and on the Details section select option Format With Multiple Columns. After doing that, the Layout tab magically appears. Click on that and set up the width of your label sizes. Secondly, check the option Format Groups with Multiple Columns. After making these changes, click OK to save and close the dialog box.

Viola! Your report will print in newspaper column format and the columns accurately go completely down the first column before starting at the top of the next column.

I will DEFINITELY be writing about this in the next book!

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Print Page | Close Window