Results 1 to 4 of 4

Thread: Crystal 8.5 Preprinted Forms with Subreports

  1. #1

    Thread Starter
    Member
    Join Date
    Dec 2001
    Posts
    48

    Crystal 8.5 Preprinted Forms with Subreports

    I am modifying a vb6 application that prints on a preprinted form using Crystal Report 8.5.

    The report has a main report and a subreport.
    It is basically an Invoice with Header Data(Main Report Top Half of Form) and
    Detail Data(Sub Report with 6 sections - Bottom Half of Form).

    Currently, the sub report is allowed to grow so that if there is too much detail information it will print on the second page.

    The problem is that when the subreport grows it prints on the top of the next page and overwrites on top of parts of the preprinted form reserved for header data.

    Is it possible to get the overflow to print on the second page only in the area reserved for the subreport data.
    Also can the subreport break at the top of a section inside the subreport.
    each section represents a different type of detail data.

    Any suggestions on how to proceed?

    Thanks

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Crystal 8.5 Preprinted Forms with Subreports

    Which Sections are you utilizing for each report? Which section does the sub-report print?

    It might be simply a matter of inserting an additional Page Header section (PageHeaderB) onto the Main Report that does not contain any fields. Set the height of the PageHeaderB section equal to the top half of the report. Suppress it if the Page Number = 1 and suppress PageHeaderA if the Page Number > 1.

    There are other methods but again they would depend on which sections you are using.

  3. #3

    Thread Starter
    Member
    Join Date
    Dec 2001
    Posts
    48

    Re: Crystal 8.5 Preprinted Forms with Subreports

    Main Report Sections
    ---------------------
    Report Header Sect 1 - Greyed Out
    Page Header Sect 2 - Greyed Out (Key Sorting)
    Group Header #1 Sect 10 - Greyed Out (Key Sorting)
    Group Header #2 Sect 6 - (Key Sorting)
    All Header Data being Printed
    Sub Report is Embedded Here as well

    Detail Sect 3 - Greyed Out
    Group Footer #2 Sect 7 - Greyed Out
    Group Footer #1 Sect 11 - Greyed Out
    Report Footer Sect 4 - Greyed Out
    Page Footer Sect 5 - Greyed Out


    SubReport Sections
    ---------------------
    Report Header Sect 2 - Greyed Out
    Group Header #1 Sect 7 - Sequence Data A
    Detail Sect 3 - (Key Sorting) Data
    Group Footer #2 Sect 8 - Data

    Report Footer a Sect 9 - Data
    Report Footer b Sect 1 - Data
    Report Footer c Sect 5 - Data
    Report Footer d Sect 6 - Data


    Also, Anyway to renumber the Section # so they don't jump around?

    Group Header #2 will probable need to be broken up since Header Data and the Sub Report are Embedded here
    The Form Prints Like this
    HHHH
    HHHH
    XSSS
    SSS
    SSS

    H=Header Data, X=History Data(Part of Header), S=SubReport Data

  4. #4

    Thread Starter
    Member
    Join Date
    Dec 2001
    Posts
    48

    Re: Crystal 8.5 Preprinted Forms with Subreports

    Quick Note The SSS should all line up. When it saved my reply it shifted the SSS that were below the X to the left.
    HHHH
    HHHH
    XSSS
    ..SSS
    ..SSS
    Where .. is blank area

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width