It seems ridiculous that I can't find a solution to this one.

Quite simply put, I want to create a define field that utilizes the value from a multi-select parameter in the report.

My Define Field:
If the multi-select field is (no selection _FOC_NULL) then 'A' else 'B'.



DEFINE FILE webfocus/wf_retail_lite
Sort_Field/A1=IF &PRODUCT_CATEGORY EQ '_FOC_NULL' THEN 'A' ELSE 'B';
END

TABLE FILE webfocus/wf_retail_lite
BY Sort_Field
WHERE PRODUCT_CATEGORY EQ &PRODUCT_CATEGORY.(OR(FIND PRODUCT_CATEGORY IN WF_RETAIL_LITE |FORMAT=A40V)).Product Category:.;
END

I'm assuming this is a problem with analyzing the _FOC_NULL element, having tried many things I've decided to all upon the experts.

Any help would be greatly appreciated.

Brian.

This message has been edited. Last edited by: <Kathryn Henning>,

I knew it was a stupid one! Adding .QUOTEDSTRING after the parameter did the job.