suppression based on the prompt value

[unknownly]

I have a report where everything is fine but my users came up with new enchancement to the report which Iam unable think how to get there.

Here what Iam doing

I have some formulas to determine the other formula value.

@ breakage

where somethimes the @breakage value will be zeros and negative amounts and postive amounts


What my user want is


When the run the report they want to input value/Prompt/parameter ( say: matched (@breakage= 0), Unmatched(@breakage<>0), All(@breakage=0 and <>0)

How can I suprress my deatils and stuff to show them if Matched or UnMatched or ALL.


I counldn't explain better than this and hope you guys understand what Iam trying to ask


Any help and quick response is greatly appericated

Thanks,

Sweetie

 

[GMcNamara]

Create a parameter for displaying values - {?Breakage}. Set the default values for {?Breakage} to 'Matched', 'Unmatched', or 'All'. In the conditional suppression for the details, enter:

({?Breakage} = 'Matched' and {@Breakage} <> 0) or
({?Breakage} = 'Unmatched' and {@Breakage} = 0)

These may be reversed since I am not sure which way you want these to work but I think you get the idea. You shouldn't have to do anything for the All case since none should be suppressed.

 

[unknownly]

I have tried this before I came in for help. It didn't work

 

[synapsevampire]

Post what's in breakage.

(
if {?Breakage} = 'Matched' then
{@Breakage} <> 0
)
and
(
if {?Breakage} = 'Unmatched' then
{@Breakage} = 0
)

-k