Skip to Content
Former Member
Aug 23, 2007 at 09:49 AM

CR in .NET


Post Author: vikas777

CA Forum: .NET


Anybody who has worked on CR pl help me out

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 headingGas details

Water headingWater 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 thenIF {RptInvoiceSub.Type} LIKE 'GasCharges' THEN{RptInvoiceSub.value}