Hiding numerical values in a report

[Cillies]

Hi All!
I have a display problem where I want to display certain information in a report, but I also want to be able to not display certain information.

i.e. if I wanted to display all company info but not a particular company I would use the following

=Sum(IIf([companyfieldname]="companyname",0,[valuefieldname]))

I want to do exactly the same as the expression above, only the info that I want to subtract is numerical. I tried jigging about the above expression but just can't get it to work.

I have an "Invoice" report,which display's company invoice details, but the VATRate feild sometimes equals 0 for certain invoices, I want to not display other info that relate to that company like "Price" and "Total" but I still need to keep the company name in the report, as certain companies have invoices that contian items that have VAT and others that don't


Hope someone can help, if you need any clarification please do not hesitate to contact me.

Kindest regards
Cillies

 

[BSman]

Use the visible property of the controls that display the values you want to sometimes hide.

Set up something like this:

IF (your test expression that when true is when you don't want to display values) THEN

SET me.control1.visible = false
.... (additional controls)
ELSE

SET me.control1.visible = True
.... (additional controls)
END IF