|
| WD17 - Make particular lines in a report invisible. |
| Iniciado por guest, 24,ago. 2016 12:45 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 24,agosto 2016 - 12:45 |
Hi all,
I have a simple report with 3 columns, let's say NAME, DEBIT, CREDIT, TOTAL. TOTAL=DEBIT-CREDIT and is calculated in every line of the report. When TOTAL = 0 I don't want to print this line.
Any ideas how to achieve this ?
Best regards,
Aad Gouka |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,agosto 2016 - 14:30 |
Hi Aad,
Try using code like this in the "Before printing body" code section: IF Total = 0 THEN HReadNext(filename) END Best regards Ola |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,agosto 2016 - 20:42 |
Hi Aad
I think that should be IF Total = 0 THEN Total..visible = false ELSE Total..visible = true END
Regards Al |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,agosto 2016 - 10:39 |
Hi Ola and Al,
Thank you for your suggestions.
@Ola. I tried what you suggested in several ways, but it doesn't work. @Al. I want to make to complete line invisible.
I played around a bit with RESULT true and RESULT false. This seems to only way to filter a BODY line.
Variables from the report loose there value in the code segment Filter(proces record). Database fields keep there value. So to filter a BODY line out of the report, someone can't use a variable that is valued within the report.
I hope you understand what I mean.
Best regards,
Aad |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,agosto 2016 - 02:06 |
Hello !! What is the source of your Report ?? IS it table or something else like query ...
Further what about filtering the source of your report using the condition where debit <> credit ?? Thanks |
| |
| |
| | | |
|
| | | | |
| | |
|