Suppress template text if no rule input data

Question

I have created a form that collects data, i.e Water Usage, Gas Usage, Electrical Usage. So I need to create a report that only displays the sections that have actual data from the form. So if there is no Gas for example, that section of the report template would be suppressed. 
 
 Thoughs?

Mike Schmitt · Accepted Answer

You will need to remove the hardcoded "Water / Power / Gas" language from your template file, and instead, provide one replacement field i.e. '###allSavings###'; after this, you will assemble the text necessary to inject into that replacement field which will recreate your desired text along with linebreaks, for which you will need to use the special XML flavor known as "WordML"

Richard Michaelis · Answer

as addition to stefans reply (regards by the way) you can check for "empty" values with the isnull() function. example: (please replace "label" with you actual label string and local!value with you actual local or rule input) 
textfield(
 label: "label"
 value: local!value
 saveInto: local!value
 showWhen: not(isnull(local!value))

 ....

)

/* isnull() = true -> there is no value,&#160; &#160; isnull()=false, there is a value&#160;*/

Suppress template text if no rule input data

Top Replies