I would like to display the value of the same field multiple times throughout the report based on the changed value of field2.

field1 = SEQ
field2 = STD_QTY

if field2 = 1
then display field1 on report with value (175)

if field2 = 2
then display field1 on report with value (172)

based on the sequence number (SEQ) the standard quantity changes (STD_QTY)

I want to display the multiple records for each STD_QTY as I assign a value to the SEQ.

I not sure where to do this.

Thanks in advance