Hi all,

I'm hoping you can help out, I've tried for the past week to fix this, but I just can't figure out a way.

I have a report which contains a subreport. In the subreport I have a formula that looks to see if the customer has a certain tax code in a field, if so I want Crystal to put a "Reverse Charge" text onto an invoice.

My formula reads as follows:
IF {TABVACBPR.VACBPR_0} = "EUR" then "Reverse Charge" else ""

This works absolutely fine, but the report still pulls through all of the other tax codes, but places them as blank lines. (There are 7 tax codes, so it creates 6 blank lines, with one of them saying "Reverse Charge").

I have attempted to put the formula inside a text object and "Suppress Embedded Field Blank Lines" but this makes no difference.

Is there any way I could create a formula that would check TABVACBPR to see if the client was using an EUR tax code and put in the Reverse Charge text, without pulling through the rest of the lines?

I hope this makes sense, please let me know if there's any more information that could help.

Thanks in advance,

Solomon

Thanks DBlank. I'm not entirely sure how to do that, but I'll go and investigate (i.e. Google ;)) now and see if I can work out how to do that.

Thanks,

Solomon

I am still unclear if the 'rows' you want to suppress are in the sub report or the main report.