Passing more than one parameter value to report.

[garry1]

Hi,

I am trying to pass more than one value to the report and it is returning me a blank page every time I run the report.Following is my sql statment

select * from test_data where distr in (&p_1)

and I am passing values as (3011,3058) to the report when I try to run my paper layout. But I am not having luck with the data. I know for sure there is data which matches this values in the DB. Any help is very much appreciated.

Thanks.

 

[nagornyi]

Make sure you are passing the parameter as characters, i.e. in quotes: '(3011,3058)' .

 

[garry1]

Hi Nagornyi,

I tried your tip, but still it is causing me the same problem.

Thanks.

 

[mcgibbong]

Try using the Ltrim and Rtrim on distr as there may be leading or most likely trailing spaces on the variable.

 

[nagornyi]

Could you please run separately 3 queries using TOAD or SQL+ by copying and pasting the text from here, and post the results.

select * from test_data where distr in (3011)

select * from test_data where distr in (3058)

select * from test_data where distr in (3011,3058)