Multiple Columns, stop a group from wrapping to the next column

I am using multiple columns in my report, also my group headers are using multiple columns as well.  The format is "down then across".

The problem I'm having is that my groups are being broken up when the report breaks to the next column, and I don't know what I need to do to prevent this, if this is even possible.  For example my group header appears in the lower left, with a few details, then it wraps to the next column, where it finishes printing the details/group footer.

Is there anything I can do to prevent this?
LVL 33
raterusAsked:
Who is Participating?
 
raterusConnect With a Mentor Author Commented:
Ok this is crazy, I think I've figured out how to do it!!

The answer is to use a subreport in the group header, and configure this group header to "keep together":

Explanation:
I started thinking about subreports, and how subreports only reside within one section of the report, and how it is really easy to configure an individual section not to break.  Only between details sections does CR feel it needs to break to a new column.  If the group header has to follow the rules of "keep together", why can't I just throw a subreport in there, which finishes off the report/details for me?

Well it works, at least it appears to work.  In the group header of the group I want to keep together I've created a subreport.  The subreport is linked so it can only see the pertinant data of current group the main report is on.  The design of this subreport basically "finishes off" the design of the group header/details section I originally had in the main report.  In the main report, I've hidden the details section and the group footer, and I've formatted the group header to "keep together", and so far everything works great!

Have I figured out the impossible, or am I missing something completely obvious to you?

--Michael (who feels pretty good right now!)
0
 
mlmccCommented:
Questions like this have been asked in the past here.

As far as I know there is no way to determine where you are on the page or in the column.  I don't know of a property to start group in new column.

mlmcc
0
 
raterusAuthor Commented:
I know, I asked them :^)
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
GJParkerCommented:
I can only agree with mlmcc, you have no control over when the column breaks in crystal.

If you were to supply more details about your report format we may be able to provide some suggestions.

Gary
0
 
raterusAuthor Commented:
It's a fairly simple report:

-Multiple Columns for details/groups
-Two groups

The inner group always has only a few details sections that are printed.  The problem is that Crystal reports is breaking the group up across column breaks, usually right in the middle of the details section, so the report looks awful.  I have managed to configure it so this group is "kept together" across page breaks, but I need to configure it so it also works across the column breaks.

All the searching I've done of the newsgroups comes up with many people asking this same question, no solution, I emailed CrystalDecisions, and they told me it couldn't be done, and now you guys are telling me it can't be done.  Should I give up?

--Michael
0
 
mlmccCommented:
I have seen this asked several times and no answer has been suggested.  As far as I know you can't control the column breaks.

mlmcc
0
 
mlmccCommented:
SOunds like a solution.  I don't think anybody ever considered using a subreport with a group before.

mlmcc
0
 
GJParkerCommented:
I've used this technique in the past and it works but it does depend on which sections of the report you are using, which is why I asked for more info on the report format.

Glad you got it sorted. The more you use CR the more you find most things are possible yuo just need to think outside the box.

Gary
0
 
raterusAuthor Commented:
mlmcc, if GJParker and you do not mind, can you just accept my answer?  No need to get CS involved.
0
 
GJParkerCommented:
No objections.

Gary
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.