I have a CR11 report that is using an oracle stored procedure. In the where clause it has the following:
(L.STATUS = pSTATUS OR pSTATUS IN ('L','M','R') OR pSTATUS IS NULL)
When I run the report from crystal, if I put in a parameter value for STATUS with one of the 3 values, the report still returns rows for all of the values.
Should I be able to just select one values and get only those rows? Ultimately, the user needs to be able to select 1, 2 or all 3 values from a list box on a report server.
(L.STATUS = pSTATUS OR pSTATUS IN ('L','M','R') OR pSTATUS IS NULL)
When I run the report from crystal, if I put in a parameter value for STATUS with one of the 3 values, the report still returns rows for all of the values.
Should I be able to just select one values and get only those rows? Ultimately, the user needs to be able to select 1, 2 or all 3 values from a list box on a report server.