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

Group Records "Consolidation"

Hi! I am using Crystal Reports (11.5) to produce a file directly from my customer database. My customers have up to six policies that I need to display on the group record. The records display individually on the detail line, however, I need the group record to include all the policies. I have tried the "counter" approach, however, I can't seem to get the fields store and print on the group record.

Any suggestions are appreciated.

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2010 at 06:12 PM

    Not sure I understand, but look for Group Name Fields, you can drag these into one of the Group Headers / Footers

    and it will display the Group name hth

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Odd, is the formula in the details section?

      also, using the format with multiple columns, can cause issues if you field lengths are not constant.

      You can code around that, but it will be some work. You would need to build several formulas, each one to

      determine if the "Policy" is null, or empty, then on that condition, return a field of known length.

      ie... if the field is empty

      if () = " " then " " else

      I have 10 spaces between the " " in the example, this should help you get a constant length on your line.

      HTH

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.