Report Design: Display field1 value based on field2 value

Print Page | Close Window

Display field1 value based on field2 value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16707
Printed Date: 19 May 2024 at 1:46am

Topic: Display field1 value based on field2 value

Posted By: bdk_12
Subject: Display field1 value based on field2 value
Date Posted: 08 Jun 2012 at 2:22am

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

Print Page | Close Window