Hi,

Does anyone know how to filter inactive data in crystal report XI formula?

I have a field call warehouse:
(if {@Warehouse} <>''
    then{G.Warehouse} = {@Warehouse}
else true
)
This will call out all the warehouse included active and inactive.

I try to filter warehouse.isactive =1 but is not working

Can anyone please advice on my code.

Thanks a lot

Is not this.

In my product table have a column call "warehouse" field. I also have a warehouse table to keep the warehouse information.In warehouse table there is column/field call "IsActive" So, if the warehouse is inactive the value is = 0, if active the isactive column value=1.

When i link my product table to the warehouse table, i need to filter those isactive <>0 then product.warehouse. I do using select expert to set "warehouse.isactive" = true.

But I try is not working and ask for a boolean.

I not sure will you get what i mean here.

already try not working.

I do like this:
(if {@Warehouse} <> '' and {Warehouse.IsActive} <>0
then {G.Warehouse} = {@Warehouse}
else true)

the error message is "A Boolean is require here" the error is highlight at the value "0"



Edited by shiloh - 21 Oct 2011 at 4:55pm

My warehouse formula only have " ' '＂　just to capture data key in by user, or user can just select from the selection record.

This is depend on the setting I did in the system and then link to CR report.

Initial yes, user can enter through parameter.

Now I want to get the data from the database table so user can select their warehouse. I using back the same parameter. Just need to add the condition. But how I try the parameter is not working for that. Is still get all the data out from database instead of filter out the inactive warehouse