Skip to Content
author's profile photo Former Member
Former Member

How to redefine group header details from second page....Crystal reports 2008.

Hi All,

I have a requirement in crystal reports 2008 where we need to remove group header detail from second page and redefine group header box with lesser information.

For example, at present we are printing the grouping on every pae as follows.

Group Header TEXT FIELD 1 : Data field 1 TEXT FIELD 2 : Data field 2 TEXT FIELD 3 : Data field 3 TEXT FIELD 4 : Data field 4 TEXT FIELD 5 : Data field 5 TEXT FIELD 6 : Data field 6

Now on change of group header, for the first page, we need to print as above. Then from second page onwards,

group header should look like as shown below.

Header from second page per group TEXT FIELD 1 : Data field 1 TEXT FIELD 6 : Data field 6

I tried the following options and it does not work .

1) Creating a second group header and trying to suppress it whever needed.

2) Using the concept of running total fields and page numbers.

I am still learning on writing formulas.

Can you please help me on how can I achieve it? Any advice would be highly appreciated.

Thanks and Regards,

Kiran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 15, 2012 at 04:10 PM

    You can conditionally suppress group headers using inrepeatedgroupheader

    split your group header and create the two versions...

    on the first page group header conditionally format to suppress with inrepeatedgroupheader. Now it will only print the first time for the group, and suppress on all following pages until the group changes.

    on the second page group header conditionally format to suppress with

    not(inrepeatedgroupheader). Now it will suppress the first time the group header prints for the group and print on all following pages until the group changes.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 15, 2012 at 03:37 PM

    Hi Kiran,

    The first method you tried should work.

    After you create a second group section go to Section Expert > select the 1st group > click on the formula button beside Suppress and use this formula:

    pagenumber <> 1

    Then select the second group > click on the formula button beside Suppress and use this formula:

    pagenumber = 1

    Hope this helps!

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2012 at 04:33 PM

    Hi Vera Venkata Suryakiran Garimella,

    I will suggest to use the "Section" feature rather than Group Header. There are following sections header available in the report designer

    1. Report Header - Header that only shows in page 1

    2. Page Header - Header that shows in every page

    3. Group Header - you already know. It is the header for the group

    4. Details - If not using group by, then this is the header for the detail record

    5. Report Footer - A footer text which only appear in page 1

    6. Page Footer - A footer text which shows in every page

    You are using #3 above, but I think you should use Report Head instead. Put the text or column names in this section.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2012 at 08:38 AM

    Pls help i also have almost the same problem its like this

    ReportHeaderSection1

    GroupHeaderSection1

    Entry no.

    GroupHeaderSection2

    NOTES

    GroupHeaderSection3

    Done By

    GroupHeaderSection4

    Approved by

    The problem is the Approved by repeats in between ReportHeaderSection1 and GroupHeaderSection1

    Can you pls help. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.