Need help in Record Selection formula

[devnaren]

Hi,

I am using CRXIR2 version. we are using Oracle 9i.

I created 5 parameters. param1, param2, param3, param4, param5.

param2, param3, param4 are related to one field. In that the data is seperated by comma (,)
eg: aaa, bbb, ccc

Now when the user runs this report,

1. he may enter just param1 or he may enter just param2, param3, param4.

2. he may enter both param1 and param2, param3, param4.

3. he may not enter any of these parameters param1, param2, param3, param4. they are null

4. when all the first parameters were null then the report should filter by

param5='ABC'


I need help in writing Record selection formula.

 

[Madawc]

Write some formula fields, a 'boolian' something like

isnull(param1) and isnull(param2) and isnull(param3) and isnull(param4) and param5 ='ABC'

First put the formula fields next to the unsorted date, to check they are OK. Then you can select just by including the formula field name,

if @VetParams or ...

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10