Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Crystal report with ex...
Microsoft Dynamics SL (Archived)

Crystal report with extra page break

(0) ShareShare
ReportReport
Posted on by Ruben Juarez 175
I am completely out of ideas.  I have a customized Crystal invoice report (not using any variations of the BI.010) that just will not cooperate.  My situation is that whenever I have a multi-page invoice within a batch of invoices, the first page of the multi-page invoice prints the invoice header (group header) but does not print the body of the invoice (group footers).  The body starts printing on page two.  If I print the multi-page invoice by itself, or if it is the first invoice in a batch of invoices, it prints correctly.
 
I’ve tried moving the headers around, changing margins, turned off all “keep together” in the sections, turned page breaks on and off.  I have even added text boxes to show which sections print and that hasn’t helped either.  The page where I get only the header, none of my text boxes print in the body indicating that a blank section is printing.  There are many group footer sections and about 8 - 10 subreports.  I went as far as deleting all of the subreports and many of the sections to see if I could narrow it down, but nothing helps.
Any ideas would be greatly appreciated.
Thanks,
Ruben

*This post is locked for comments

  • Ruben Juarez Profile Picture
    Ruben Juarez 175 on at
    Re: Crystal report with extra page break

    I got the answer through a Crystal Developer forum.  The answer was to turn off the "Keep Together" option in the group expert settings.  I had already turned it off in the section expert but didn't know that the option also exists in the group expert.

  • Ruben Juarez Profile Picture
    Ruben Juarez 175 on at
    Re: Crystal report with extra page break

    Carolyn,

    It's a long complicated story, but bottom line is that we ended up writing our own invoice report  - we don't use any version of the BI010 report.  Our report runs off of a view that picks up data from a custom table, then is joined to several standard tables on the report.

    I have a formula that does grouping something like what is in parameter maintenance and use this formula for my section breaks.  In an attempt to see which of these sections was displaying, I put in a text field with the name of the group headers / footers within each of the sections.  I hoped this would show me which section was causing the break.  I did find that I’m getting a page break between group header 3 and group header 4.  I normally have both of these group headers suppressed as they don’t contain anything I need on the invoice (I get the same page break whether the group headers are suppressed or not).  The corresponding group footers are also suppressed.

    I did a test based on what you suggested: I did a sql select of the fields in my group expert, grouping and sorting by those fields.  The result set suggests that there should be no break at the point where I’m getting the break (between GH3 and GH4).  Every record has the same value in groups 3 and 4.  The nearest page break is at group 2, Draft_Num.  

    I don't understand why I would get a page break between GH3 and GH4 when the invoice is not the first one being printed, but no page break when it is the first one.

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Crystal report with extra page break

    Hi Ruben,

    It sounds like you are saying if the multi page invoice is the first invoice, then it prints OK.  When it’s the second invoice though, it prints the group header, then pages.  That makes it sound like something on the record is changing and Crystal thinks it has to page at that point.

    Those reports are pretty complex.  There are a series of formula fields that pull 4 character strings from a global parameter that is sent to the report, and then a group of ‘group and sort’ fields that tell the system how to group the records.  As an example, the same report can be group by account category, by comment, by project billwith, by source transaction date, etc.  Probably based on the section type used in invoice format maintenance.  Without additional information, it’s hard to tell what it should be grouping on.  There are a dozen or so possibilities.  Let’s say as an example though that it’s grouping on the project bill with and account category.  It sounds like the first invoice prints, then the group header of the second invoice prints before the system realizes that the project billwith and account category changed, and now that it realizes it changed, it has to do a page break to start a new page.  That sounds like something is messed up on the report, but it might be hard to find as complex as that report is.

    Sorri I don't have any concrete ideas as to what the issue might be.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans