Skip to Content
Aug 01, 2009 at 10:40 AM

Query Result?



I want the query result to display like this, I think this can be done easily.. so pls help me out on this.

For Ex: Cardcode card name Card type ( Query will displays the result usually 😊

CT0001 TVS C

VH001 HP S

Bu t I need instead of " C " it has to display as "Customer" , instead of " S " it has to display as "Supplier", instead of "L" Lead.

Same thing in Production order status it showing as "L" , "R" so it has to show like "closed" or " released"....

So my clients will easliy understand their reports..