Need zero suppression in Data report?

[senthilkumartd]

Hi,
I designed a report in DATA REPORT of visual basic 6.0 . I wish to suppress zero and print empty string when the field value contain zero in detail section. How can I do that. I have depiced a example. I need it to be done in DATA REPORT.

------------------------------------------------------------------
Name``````````````````````Credit````````Debit
------------------------------------------------------------------
Senthil```````````````````5000.00`````````0.00
Siva````````````````````````0.00``````3000.00
------------------------------------------------------------------
````````````````Total`````5000.00````` 3000.00

The above should be displayed as,
------------------------------------------------------------------
Name``````````````````````Credit````````Debit
------------------------------------------------------------------
Senthil```````````````````5000.00
Siva``````````````````````````````````3000.00
------------------------------------------------------------------
````````````````Total`````5000.00````` 3000.00


Note: where CREDIT and DEBIT fields are numeric.
Here, ` sign used to show the above report in proper alignment assume it as a space.

Waiting for the solution.

Advance thanx,

cheers,
Senthil

[dee-u]

In your SELECT query you could try using something like the ff...

SELECT IIF(Amount1=0,'',Amount1) as Fld1
FROM ImpBillRecords;

[senthilkumartd]

Hi dee-u,
Happy new year!.
The data type of the CREDIT and DEBIT fields are single and the group footer used the sum(CREDIT) for total. It is not accept our try. If the data type of the fields CREDIT and DEBIT is string, will allow suppression, but group wise total is not possible. Any suggessions please give.

Cheers
Senthil

[Hack]

Moved to reporting section.