whileprintingrecords; 2

[sim133]

Hello everyone;
I have this code that prints business naics codes (business services code). The problem I am having is it keeps concatenating the codes created in the first grouping to the next, and next, and next grouping. Is there anyway to reset nics variable when it starts a new grouping. The report is grouped by business IDs; Below is the code.

whileprintingrecords; 
stringvar nics;
nics := nics + {VENDOR_NAICS.NAICS_CODE} + ", ";

 

[bdreed35]

Create another formula that resets it and place it in the group header:

whileprintingrecords; 
stringvar nics := "";

~Brian

 

[dgillz]

Be careful of the last formula if you are also repeating the group header on every page. If this is the cast the header will print again and reset the value of the variable.

To get around this, modify the formula slightly:

WhilePrintingRecords; 
If Not InRepeatedGroupHeader then stringvar nics:="";

This will have the effect of resetting the variable only once at the beginning of each group, regardless if the group header is repeated in the group.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra