Crystal reports, dataset and select command - what to use instead of iif statement
Hi,
I have a table with several columns. One of them is quantity, and another is code for the product. I want column quantity to get different names in the heading row of the report, depending on the value of the code for the product. For example if code is 099100 of the table, name the column quantity as "Oil", if the code is 0993050 name the column quantity as "name" and select the quantities for that code for all the rows in the table.
Could anybody help me please?
Thank you very much in advance.