Hi,

I am using vb.net and cr10

I want to display the stock related to particular category and using the below said formula but it show the zero result but originaly there is a data.

Can anybody help how to define the 'like' in cr10


strFormula = "{TempItemStockStatement.BranchCode} = '" & strString & "' and {TempItemStockStatement.CurrentStock} <> 0 and {TempItemStockStatement.Category} = '" & txtCategoryCode.Text & "%'"


thanks