how to write a formula for display the value by group

Post Author: abadugu

CA Forum: Formula

Hi

Could any one please help me on writing the formula for the below senario.

I'm creating Crystal report Via using ClearQuest (IBM tool) since this tool is not supporting subreport function. I'm planning to write a formula.

I have grouped report by request_type field (request_type field contains Validation Defect, Production Defect, Known Defect etc..)

right now my report output is grouped by request_type

ex:

Validation Defect

SUMMARY COMMENTS

Production Defect

SUMMARY COMMENTS

...

my question was

If request_type = Production Defect display pm_number value field otherwise display null

ex

Production Defect

PM# SUMMARY COMMENTS

Validation Defect

SUMMARY COMMENTS

could you please help me writing a formula.

Thanks

Anand