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

how to create a group with multiple data fields

Post Author: RichS

CA Forum: Formula

Using CR XI. Using CSV input from ODBC text driver. No problems here.

There are 3 fields that I want the same group by action. Is this possible?)

If any one of these 3 fields change I want some header information and column fieldnames to display. The header information I only want displayed on the first page (on the change) and the column fieldnames to display on every page. I have played around with things like "InRepeatedGroupHeader" and "report group header on each page". I am not getting all the results that I am looking for though.

I want report to look like:

Page header stuff (to display on every page) This data consists of some fields that will have static data and will display on every page. And it consists of 3 non-static fields that I want to group on.

Group header stuff that I only want displayed on the first page on a change from one of the 3 fields mentioned above.

Column headings that I want displayed on every page.

Details data

Group footer stuff (details not important for this)

I get the expected output (column headings displayed on every page, and group header stuff display on the first page on each group change) with one group field. But I want the group change to happen for all 3 fields.

It seems simple but I can't find a way to create a "group" so if "field1 or field2 or field3" change, I get the same "group by" action. I just need to know how to get the expected action.

I expect that I might have some terms mixed up and/or some important information that would aide you in helping me. If that is the case please re-post and I will add any missing or mis-stated information.

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 04:35 PM

    Post Author: V361

    CA Forum: Formula

    I am slightly confused, but perhaps you can create a formula

    & " " & & " " &

    Then group on the formula. If this is not what you want, could you post some sample data, with the desired results.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 10:35 PM

    Post Author: RichS

    CA Forum: Formula

    I just figured this one out about 2 hours ago. Thanks for your response though. Rich

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2007 at 04:31 PM

    Post Author: V361

    CA Forum: Formula

    Cool, what did you do ?

    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.