Using <>, >, < and/or wildcards with parameters

[smadsen91]

We have several crystal reports that are launched using crystals web viewer. We pass values into parameters using AddCurrentValue or AddCurrentRange. The parameter values are entered on an ASP page, currently all we have available is "=" logic. The reports have a RecordSelectionFormula like this {Table.Field} = ?Parameter.

My question is, now our users would like the ability to do >, <, <> and/or wildcard selections on these parameters. How would I go about doing that using parameters? If that's not possible has anybody done anything similar?

Thanks.

 

[GPOGA]

To bypass this problem, I built a custom web form that had all of my custom ASP to modify the reports embedded in it. I took out the parameters and passed a full SQL statement back into the report with a dynamic Where clause that was dependant upon the user selections. I then used blank formulas to pass other values into. I used these formulas to filter the data seen in the report (suppression, detail level, etc.).

Hope that helps.