Problem with select options

[Former Member]

Hi Friends.

I am facing a problem in my report , in the selection screen i have WBS Element , Year, Month as input . My problem is , if i use parameter for WBS element and if i enter a particular WBS it is fetching data and displaying it . And if i use select option instead of parameter and if i give the same WBS it is not fetching the data. My client is asking to use select option only as he wants to give WBS range in the selection screen.

Please check this .

[Former Member]

you will have to paste the code here

are u using where wbs = select option

or wbs in selectoption

in your select query?

try using IN

[Former Member]

Hi Rohini,

Can you show the select statement

I hope you are using IN for Slect options

SELECT ....

...

WHERE <WBS> IN S_WBS..

[Former Member]

Hi,

I think you may have this problem

Please check once in Select Query what you are writing, I mean.

for parameters in where condition EQ you can use, but SELECT-OPTIONS you have to use IN option.

anyway can u send your code I can give better solution.

Thanks

Ganesh