var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How do you eliminate data on a footer of a report?
I just want to show the data on the header but I don't want some of the data to be total up in the footer.
1.) Show facilityid 1,2,3 for the header
2.) Eliminate facilityid 3 for the footer but total up the amount with the facilityID not equal to 3.
Set the detail section to invisible in the OnPrint event if the facility id is three. Set the sum fields to an iif() statement:
=sum(iif(facilityID = 3, "0", whateveryou'resumming))
I actually tried that but in a different way, which is wrong.
Originally Posted by Teddy
This is what I did before:
iif(facilityID = 3, "0", Sum(whateveryou'resumming))
Anyways, how do you add another facilityid to the condition?