oh yeah .. fixed.. 1 was string and 1 was number.. now working..

Now another 2 queries

1) When the parameter value of "stat" is 0 .. i want to show a text like "shipped" somewhere.. how do i do this connection in the report ??

2) There is another 2 queries.. if the parameter value is 0 then the following query should be run

Code:
select order_details.order_id FROM order_details INNER JOIN shipping ON order_details.order_id = shipping.order_id
else the following should be run ( if parameter "stat" = 1 )

Code:
SELECT order_details.order_id FROM order_details WHERE order_details.order_id NOT IN (SELECT shipping.order_id FROM shipping )
how do i do this codeing in the report in to run seperate queries depending upon the parameter value??

thanks