?
Solved

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

Posted on 2005-05-10
11
Medium Priority
?
827 Views
Last Modified: 2008-02-01
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?
0
Comment
Question by:raterus
  • 4
  • 3
  • 3
10 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 13969723
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
 
LVL 33

Author Comment

by:raterus
ID: 13969770
I know, I asked them :^)
0
 
LVL 19

Expert Comment

by:GJParker
ID: 13969893
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 33

Author Comment

by:raterus
ID: 13970060
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 13974098
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
 
LVL 33

Accepted Solution

by:
raterus earned 0 total points
ID: 13978158
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
 
LVL 101

Expert Comment

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

mlmcc
0
 
LVL 19

Expert Comment

by:GJParker
ID: 13984390
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
 
LVL 33

Author Comment

by:raterus
ID: 13990792
mlmcc, if GJParker and you do not mind, can you just accept my answer?  No need to get CS involved.
0
 
LVL 19

Expert Comment

by:GJParker
ID: 13993963
No objections.

Gary
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question