I am generating a report where it is showing all items which are in stock or out of stock
Now I am taking that choice from a cmbstatus list.. so the value is 0 is in stock and 1 if out of stock
now the sql query to run in the report is
( depending what the person chooses )Code:select * from item where item.status = 1/0
how do i do this.. i did create a parameter field "stat" but i am unable to generate this formula.. I am passing the value via
where st = the value chooses by user i.e. 0 or 1Code:crxReport.ParameterFields.GetItemByName("stat").AddCurrentValue st
i gave in the selection formula
But it gives errorCode:{item.status} = {?stat}
what to do ????Code:A Number is required here
once this problem is solved i have another multitable query problem which i will give later




Reply With Quote