Skip to Content
0
Former Member
Aug 20, 2007 at 05:22 PM

Multi page header

19 Views

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}