Hello everyone,

I am trying to burst a report based on 3 burst values: Large, Small & Lease
These values however are not clearly stated as such in the field I am using as a Burst value..

For example: the field on which I am bursting the report has values ABC, LMG, etc which mean they fall in "Large" bucket.. When the field value is null means they fall in "Small" bucket & when the field is 1 or L it means those records fall in "Lease" bucket..

How do I define the burst variables as Large/Small/Lease based on the above values?
Also, I have to display the burst value as the title for each report, so the report with all records falling in "Large" category will have the title as "Large" and so on...

Thanks in advance for all the help!

This message has been edited. Last edited by: FP Mod Chuck,

DECODE fieldname(code1 result1 code2 result2...[ELSE default ]);

https://webfocusinfocenter.inf...dm/source/decode.htm

Inside the Report Heading place the decoded field using

   <DECODED_FIELDNAME 

https://webfocusinfocenter.inf...ootTitleLabel1027945

This message has been edited. Last edited by: BabakNYC,