Skip to Content
avatar image
Former Member

Blank space issue in grouping

Hi,

I came up scenario that I want to utilize blank space on each page, I do have group in report and unchecked keep group together option to split records on each page and repeat header on each page, but sometimes group has long char records which wont fit on page (specifically first record) then that page only shows header of group and group records with header on second page. This create issue that header showing without data on that page, I want to suppress that header if no records on that page but need to show header on next page with record.

This happens only for first record of group at bottom of page. please suggest.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Aug 21, 2017 at 08:09 AM

    Hi Amol,

    Here's what you need to do:

    1. Insert a Group Header 1b section.

    2. Copy all fields from the Details to this new Group Header 1b section. Don't delete fields from the Details section. Both Details and the Group Header 1b should look same.

    3. Go to the Section Expert > Highlight Group Header 1a > Uncheck 'Keep Together'. Highlight Group Header 1b and uncheck 'Keep Together'.

    4. Highlight the Parent Group Header#1 section > CHECK 'Keep Together'.

    5. Highlight the Details Section > Click the formula button beside Suppress and use this code:

    OnFirstRecord OR {Group Field} <> Previous({Group Field})

    Replace {Group Field} with the field you've grouped on.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2017 at 03:11 PM

    Hi Amol,

    Right-click the field that has the long characters > Format Field > Common tab > Uncheck 'Keep Object Together'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2017 at 03:43 PM

    Could you please attach a screenshot of the current report and an example of how you'd like it to be displayed?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2017 at 03:37 PM

    Hi Abhilash,

    Thank you for your response, Yes this option works to split the long char records and fill the blank space, But client don't want to show split records they wanted to suppress header for last record of page if it not get fit into page. Right now , last record has can grow field it grows to four rows, it is showing first row at last of group and rest of records will get displayed at next page group.

    Do you think it is possible to suppress header if groups first record content unable to fit then we need to suppress Group header.

    Appriciated your response!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2017 at 03:50 PM

    I cant attach anything related to project. I will try to show in text format.

    GH1

    Record 1

    Record 2

    GH2

    Record 3

    Record 4

    GH3

    Page end

    Page 2

    GH3

    Record 5

    Record 6

    --------------------------------------------------------------------------------------

    At GH3 it shows only GH because records are not fitting at end of page so I want to suppress conditionally. This is very tricky. GH repeating if page breaks its ok at next page not on previous page where no records displayed.

    Add comment
    10|10000 characters needed characters exceeded