Hi all,
I have a requirement where in my report should display results based on dashboard prompt values.
For example, a dashboard prompt which should contain values "ALL" and "Contain Negative".
When the user selects "ALL" in DB prompt then my report to display all the values (both +ve and -ve measure column values).
If i select "Contain Negative" (if my measure values contain at least one -ve value) then my report should display measure column values (both +ve and -ve values), here if all the +ve all there then it should not show anything.
Regards,
Chandra.