Filter field based on values within another field

[jcs2923]

I have a report that uses the same table.field twice as two seperate columns. In the first column, I need to filter by the value of another column. In SQL terms, I would like to select field 1 value where field 2 valuek = x and in the second column I would liket o select field 1 value where field 2 value = y. I tried the select wizard, but my selections were used for the entire report and I need to use this filter for only one column. Any help would be appreciated.

 

[lbass]

Don't create the formulas in the record selection area. Go to field explorer->formula->new and create the formulas there, as in:

//{@field1whenx}:
if {table.field2} = "x" then {table.field1}

//{@field1wheny}:
if {table.field2} = "y" then {table.field1}

Then place these in the detail section of your report.

-LB