on 07-02-2010 4:30 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.