Liveware Publishing Support Forum

I have generated a cable ampacity report, which first determines the raceways in which each cable is routed from point A to B. It also calculates the worst ampacity derating factor for the cable in each raceway. The filter for cable report is all LIKE Cable IDs (_%O2AB04%P%^).____The report prints all the raceways (cable trays and conduits) associated with each cable. For each cable the number of raceways varies from one to 50 raceways. It also calculates the different multiplying factors for each raceway and the worst ampacity derating factor, which varies from 0.36 to 0.89.____By using a calculated field _ Worst Raceway_, I have reduced the number of records printed for each cable. However, my objective is to print only one of the worst raceway for each cable.____How can I accomplish this? __

One approach is to set "cable type" as a group. Then calculate a minimum that resets for each group (cable type).____RW

Thanks, I did use the group fiels and Min Value and that solved my problem