Created my first crystal report with wizard want an adjustment with groupings.

Posted on 2005-04-10
Medium Priority
Last Modified: 2012-06-27
I've created my first Crystal Report - with a wizard called Budget Reports.
I did have a particular field called Alternate that I went ahead and grouped the entire report by.
I only have two records for Alternate - one is Base Bid and the 2nd is Future so its not a long report.
Thus I have two pages - one for Base Bid Budget and the 2nd for Future Budget.
What I want to do is to list both of these on the same page!  But I don't see any options to declare this header group to not start with a next page.
Please help - my first attempt at Crystal Reports.
I appreciated it a lot!.
Question by:stephenlecomptejr

Accepted Solution

hulitk earned 800 total points
ID: 13750133
You can check under the Report menu > Change group expert.  Under the options button check to see if the "keep groups together" box is checked, if it is uncheck it.  

LVL 101

Assisted Solution

mlmcc earned 600 total points
ID: 13750236
There are other possibilities
Open the report
Select each section in turn
   Check to ensure you don't have NEW PAGE BEFORE or AFTER clicked.
   Check to ensure the KEEP TOGETHER is not checked.

LVL 42

Assisted Solution

frodoman earned 600 total points
ID: 13752136
Another thing to check is for empty space in the design - if you have a lot of white space in a section above your fields, Crystal will keep that white space and the total size of the section may be taking up too much space on the page.  Try squeezing things together on the design layout if none of the above suggestions helps.


Author Comment

ID: 13752829
I've tried all of your suggestions and checked all the settings accordingly and none of which has New Page before or New Page after checked off.  I've tried checking each individual setting for New Page After/Before and also the white page and still not working...
Sometimes a combination of settings for others may cause conflict so I've listed them below.  Is there an original glitch that a service pack may need to be run to fix this?

This is what I have accordingly below.
Report Header (Keep together)(Suppress No Drill-Down)(Free-Form Placement)
Page Header
  Page Header a (Free-Form Placement)
  Page Header b (Free-Form Placement)
Group Header#1: sp_GetBudget
  Group Header#1a (Free-Form Placement)(Keep together)
  Group Header#1b (Free-Form Placement)(Keep together)
Details (Free-Form Placement)(Keep together)
Group Footer#1: sp_GetBudgetFooter
  Group Footer#1a: sp_GetBudgetFooter (Free-Form Placement)(Keep together)
  Group Footer#1b: sp_GetBudgetFooter (Free-Form Placement)(Keep together)
Page Footer (Free-Form Placement)
Report Footer (Keep together)(Suppress No Drill-Down)(Free-Form Placement)
Any of these settings may cause a conflict with the end result?
LVL 101

Expert Comment

ID: 13758279
Glad i could help


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Integration Management Part 2
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
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