Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Keep Together not working Post Reply Post New Topic
Author Message
samirlogin
Newbie
Newbie


Joined: 16 Jul 2009
Location: United States
Online Status: Offline
Posts: 3
Quote samirlogin Replybullet Topic: Keep Together not working
    Posted: 17 Jul 2009 at 9:36am

Hi Friends,
I created five detail sections and set property Keep Together for all detail section. But Sometime 2 detail section displayed at first page and remaining 3 detail sections displayed at second page.
I want all five detail section on same page either first or second.

Please help me.
- Sam

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Jul 2009 at 8:01pm
Keep Together applies to each section, not to all of the details sections together.
 
Do you have any groups?  Have you turned on Keep Together for the inner-most group?  That will keep all of the detail sections together.
 
-Dell
IP IP Logged
samirlogin
Newbie
Newbie


Joined: 16 Jul 2009
Location: United States
Online Status: Offline
Posts: 3
Quote samirlogin Replybullet Posted: 21 Jul 2009 at 9:30am
If we create a Group and keep togther now towking from below setting.
Not Working (Report->Section Expert->Select Group and enable Keep togther)
 
 
Working(Report->Group Expert->Select Grop and Oprions->Select Option Tab->Enable Keep Togther)
- Sam
IP IP Logged
fwayner
Newbie
Newbie
Avatar

Joined: 26 Nov 2009
Location: New Zealand
Online Status: Offline
Posts: 2
Quote fwayner Replybullet Posted: 26 Nov 2009 at 12:37pm
I have found that both methods listed for "Keep together" work the same for me.
What I really want is "Keep with next".
I'm using Group Header 1 for the name, Group Header 2 for a 1 line sub-heading and Group Header 2 for a long paragraph. I never want the Name or the name and subheading to appear on 1 page and the paragraph start on the next.
I've tried lots of grouping options and the only one I've come up with is to use a subreport and that is limited by the "no nested subreports" problem/feature.
Anything else I can try?
IP IP Logged
Leon52
Newbie
Newbie


Joined: 26 Jan 2011
Online Status: Offline
Posts: 1
Quote Leon52 Replybullet Posted: 26 Jan 2011 at 10:22am
Ok I have a work around which may work for some people depending on what you need to do.

You need to Put your group heading 1 into group heading 2, suppress group heading 1.
Then go to section expert - group heading 2 and insert a SQL field that will turn off and on the "Supress(no drill down)".

I cannot give you the SQL for the SQL expression field because I dont know your database but it will be like something below:

select min({grouped item])
from table table_min
and table_min.field = table.field

The trick is to get first value of group1.

In your Suppress field formula you want to test it against itself and return true false.
E.g.
Case when @SQLExpressionField = [grouped item] then false else true end

Your new group heading 2 should only show at the start of each group1.

Then you make sure your keep together is ticked inside group heading 2 and the whole group will stick together and move to another page carrying the heading with it if it is bigger than a page.

Very hard to explain but it works.
IP IP Logged
fwayner
Newbie
Newbie
Avatar

Joined: 26 Nov 2009
Location: New Zealand
Online Status: Offline
Posts: 2
Quote fwayner Replybullet Posted: 26 May 2011 at 9:58am
Ahhh. Finally found the answer I was looking for:

1. Click the group you want kept together, in my case, Group Header #2, right click the group and choose Change Group.
2. click to the Options tab and
3. tick Keep Group Together.

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.