cancel
Showing results for 
Search instead for 
Did you mean: 

Group Records "Consolidation"

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

if the poiicies are db items, you can use a summary, and put that on the GH, I may be way off base, so forgive me if I did not

understand the issue.

Former Member
0 Kudos

Does this help? This is the report I am trying to create?

Co_name Co_no Policy# Policy_date Policy_Type

XXYZ CO 111 Pol123 12/1/2011 Auto

XXYZ CO 111 Pol123 12/1/2010 Flood

XXYZ CO 111 Pol123 12/1/2009 Fire

I want my group record to look like this:

XXYZ CO 111 Pol123 12/1/2011 Auto Pol123 12/1/2010 Flood Pol123 12/1/2009 Fire

Thank you!

Former Member
0 Kudos

Yes, that does help, you can put this formula in the details section

&" "&&" "&{Policy#}&" "&&" "&

now

select details, then section expert, check format with multiple columns, "You should see a layout tab now", click on it, select detail size width, Printing direction, across then down, and format groups with multiple columns (If you need too)

You may need to work with font sizes to get 6 items on one section, you can always adjust the page width, and turn it to landscape.

HTH

Former Member
0 Kudos

I really appreciate your assistance. Thank you!

I think you are getting me on the right track. The problem I am getting now is the displayed values are only representative of the last detail line, and the values from detail line 1 and detail line 2 are not showing up.

Former Member
0 Kudos

I changed the Detail Width, and it seems to have done the trick. I see each section on the same line. The issue I am having now is when I export to CSV, or Excel each section is listed on a separate line. Is there a way to get all the sections on the same line during the export?

Thank you!

Former Member
0 Kudos

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

Answers (0)