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

Posted on 2005-04-10
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
    LVL 2

    Accepted Solution

    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 100

    Assisted Solution

    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

    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.

    LVL 1

    Author Comment

    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 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    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 …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video discusses moving either the default database or any database to a new volume.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now