Parameter Issue

[ekta22]

Hi,

My report is based on an oracle stored procedure. I declare my parameters in my stored procedure something like this

pSTART_DATE IN T1.START_DATETIME%TYPE,  
pEND_DATE IN T1.LOG.END_DATETIME%TYPE,
pCC IN T1.CODE%TYPE

I use the code below for each parameter in my stored procedure to check the value entered by the user or if it was left blank.

(T1.START_DATETIME >= pSTART_DATE OR pSTART_DATE IS NULL) AND
(T1.CC = pCC OR pCC IS NULL)

My question is that when I connect my report to the oracle stored procedure it pops up the parameter dialog box which is okay. All the parameters are optional for my report but for some reason crystal don't let me leave the above 3 parameters blank. If I click "OK" it takes the cursor to pSTART_DATE. When I enter that and click "OK" it takes me to pEND_DATE and finally pCC(it's a number field). I have to manually check "SET TO NULL" to avoid entering the value for these 3 parameters. I have 8 other parameters which don't ask me to do that.

I was wondering why that happens. The only thing I noticed was that all the other parameters are text parameters while the other 3 are DATE and NUMBER. But still not sure why this would happen. Any suggestions would be greatly appreciated.

I am using Crystal XI and Oracle 10g.

Thanks!
-E

 

[ekta22]

Any ideas??