Reducing the data printed when multiple labels are required.

[nelsonsk2]

We are using Crystal XI to develop reports from our Max (Pervasive SQL) MRP system. I have a job label that pulls data from our product structure and Part master tables to label the individual parts in our job kits. The label is laid out as follows:

work order # Assembly #
work center
component part # Qty Issued
Part description
reference designators (i.e. a1, a6, a8, b1-b10, a1_12)

Our problem is that there is only room on the label for one row of reference designators so when more are left to print the report prints the first four rows of information then only one row of reference designators again. The formula for printing the reference designators is:

If {Product_Structure.REFDES_02} = "" then
{Windows_Notes.NOTES_61} else
If ISNull({Windows_Notes.NOTES_61}) then
{Product_Structure.REFDES_02} else
{Product_Structure.REFDES_02}&","&{Windows_Notes.NOTES_61}

I'm looking for a way to evaluate the number of reference designators and if more than one label is required to print them all then only print the first row (work order #/assembly number) then print up to 4 rows of reference designators on the remaining labels required for that part.

In one case I have a part that has 128 reference designators that now requires 40 labels to print them all.

 

[SkipVought]

So TRUNCATE the Ref Des to a fixed number of character that will fit.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[nelsonsk2]

Unfortunately, the reference designator text can't be truncated. These designators represent specific locations the parts are used on an printed circuit board. If they were truncated they would be meaningless and there would be no reason to list them on the label.

Thanks for the suggestion though.