Hi,
Its for an Invoice Report. I am having a list of values which are directly fetched from a table. There is a column named 'Type' which will be having values 'Gas' and 'Water'. It is having another column named 'values' which will list all values.
Based on the 'Type' we will be displaying 'values'. Gas values will be displayed in Gas Details section and water values will be displayed in Water Details Section
Q1: My requirement is to display like this
Gas heading
Gas details
Water heading
Water details
Q2: Also i need to display only if there are datas in the table. But now even though if there are no datas its displaying o.oo by default. This is the code that I have used.
Ex of the code used:
If Isnull({RptInvoiceSub.Type}) <> True then
IF {RptInvoiceSub.Type} LIKE 'GasCharges' THEN
{RptInvoiceSub.value}