In many flyer and report templates, icons are shown to represent how many bedrooms, bathrooms, garages, and living areas a property has. This guide looks at the scripting behind these icons which makes them show if the number is greater than zero, and hide if the number is zero or blank.
In this example template there are three script rules per icon.
- A rule which forces the numerical character to only show if the number is greater than zero, and not blank.
- A rule which forces the icon to only show if the number is greater than zero, and not blank.
- A rule which forces the icon background shadow to only show if the number is greater than zero, and not blank.
Each element is uniquely named - this is how the script rules are linked back to the icons.
In edit mode right click on an icon, shadow, or data field and click Options to view the Name. Here are the image names for the bedroom icon's three related elements:
- ImageBed = the bedrooms icon
- BEDSHADOW = the grey background shadow
- BED = the number
Now right click on an empty area of the same report band to view Scripts. Note the three lines of arguments which relate back to each of the bedroom elements. These SQL rules state that each item must only show if the number of bedrooms is not zero or blank.
SETBOOLPROP('ImageBed', 'Enabled', Listings.Bedrooms <> 0)
Tips
If you're swapping in new icons, you will probably need to rename each image with a unique name like 'ImageBed2' and then also copy and paste another matching rule into scripts. Often a name cannot be recycled.
If your rule is <> '' instead of <> 0, this will work if the Listing Entry fields are left blank, but if zeros have been entered (e.g for sections or bare land) then the number zero may appear on reports.
Notes
For an office's custom complex magazine template, anomalies began to occur where for various properties the icons would randomly show or hide. The solution was to rename all of the icon and numerical objects, and also rename them in the SQL script.
RSS Feed
