the report should include an OLE object that resides in the report footer. I'm trying to get the formula to suppress the report footer (and therefore the OLE object) if the list doesn't include one of the drape kits.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 03 May 2019 at 2:32am
if you place a field level criteria into a header or footer, or an object in a header or footer it is only going to apply the criteria to the first row int hat grouping for a header or the last row in the grouping for a footer.
You need to create a way to make your condition against a report summary.
The easy way is through a sum
create a formula field for this called "flag1" as
if {Table.FIELD} like "*Tech Booth Drape Kit*" then 1 else 0
now sum this formula field for the report
You should see that any time your data set has any of those rows the sum is >0 and whenever it has none of those rows it will be 0. use that as your suppression...
sum({@flag1})=0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
