Avatar of Taras
TarasFlag for Canada asked on

Crystal report layout in multiple columns

I have crystal report with two groups Group I =  Club and Group II =  Club Role.
A club could have 10 club roles.
Club Role could have more members. Some Club role groups have one some two and some 4 members.
For club role group that have more than two members (e.g. Club_Role2,Club_Role3,Club_Role5,Club_Role7) I need to put lay out of detail section in two columns.
For club roles that have one member (e.g. Club_Role1, Club_Role4,Club_Role6,Club_Role8, Club_Role9,Club_Role10)I would to put those groups in two columns and they will have one detail section.
Is this possible?
Crystal Reports

Avatar of undefined
Last Comment
Taras

8/22/2022 - Mon
Mike McCracken

Yes.

OPen the report
Right click the detail section in the left margin
Click SECTION EXPERT
CLick the box - FORMAT WITH MULTIPLE COLUMNS
A new tab appears to allow you to format the columns
Click the new tab
Set the width of the column as desired
Click to use ACROSS THEN DOWN

mlmcc
ASKER
Taras

Hi mlmcc.
Yes I already did this and this is working.
However user is not happy with that, he wants to save on paper as report have large number of records.
 And to do that user asked that for groups (club roles) that have one member those groups has  to be put in two columns(groups in two columns) with one detail line for each.

And for groups with two or more members they(groups) should be put in one column and have two detail lines.
 It looks like I have to do not just detail line formatting in two columns but group section too. And this group section formatting in two lines has to be conditional.
A hope that I am clear.
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Taras

Groups with two and more detail lines have to have two columns for those detail lines and not two rows with one detail line.
Groups with one detail line (one row) have to be put in two columns(those type of group going in two columns.
I am not sure that you understand what I want.
In short: In one report I need some groups to be put in two columns some in one column .
I attached some rough layout for orientation.
Group-Layout.png
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mike McCracken

Does the single column have to be the width of the 2 columns?

mlmcc
ASKER
Taras

Width of two groups with single columns put a side by side have to have the same width as one group that have two columns detail line layout.
Single column width in all those groups  is the same as they have to line up.
ASKER
Taras

Thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.