Hello all,
I'm hoping someone can help me with a report I'm building to support a review task.
I've combined 10 fields into a single column using sharecol, which works well visually. However, I'm trying to find a way to only display each field if it contains data. The reason is that users may not fill in all fields, and I’d like to avoid showing empty labels in the report.
Has anyone found a way to conditionally hide fields or labels in text mode when the field is blank?
For this example, I would only want the highlighted field data to be displayed:
This is my current code:
column.2.displayname=Risk Raised By
column.2.sharecol=true
column.2.textmode=true
column.2.usewidths=true
column.2.value=<span style="color:green;"><strong>Risk Raised By 1: </strong></span>
column.2.valueformat=HTML
column.2.width=189
column.3.displayname=Risk Raised By
column.3.sharecol=true
column.3.textmode=true
column.3.usewidths=true
column.3.valuefield=ccoRiskRaisedby1
column.3.valueformat=customDataLabelsAsString
column.3.width=189
column.4.displayname=Risk Raised By
column.4.sharecol=true
column.4.textmode=true
column.4.usewidths=true
column.4.value=<br><span style="color:green;"><strong>Risk Raised By 2: </strong></span>
column.4.valueformat=HTML
column.4.width=189
column.5.displayname=Risk Raised By
column.5.sharecol=true
column.5.textmode=true
column.5.usewidths=true
column.5.valuefield=ccoRiskRaisedby2
column.5.valueformat=customDataLabelsAsString
column.5.width=189
column.6.displayname=Risk Raised By
column.6.sharecol=true
column.6.textmode=true
column.6.usewidths=true
column.6.value=<br><span style="color:green;"><strong>Risk Raised By 3: </strong></span>
column.6.valueformat=HTML
column.6.width=189
column.7.displayname=Risk Raised By
column.7.sharecol=true
column.7.textmode=true
column.7.usewidths=true
column.7.valuefield=ccoRiskRaisedby3
column.7.valueformat=customDataLabelsAsString
column.7.width=189
column.8.displayname=Risk Raised By
column.8.sharecol=true
column.8.textmode=true
column.8.usewidths=true
column.8.value=<br><span style="color:green;"><strong>Risk Raised By 4: </strong></span>
column.8.valueformat=HTML
column.8.width=189
column.9.displayname=Risk Raised By
column.9.sharecol=true
column.9.textmode=true
column.9.usewidths=true
column.9.valuefield=ccoRiskRaisedby4
column.9.valueformat=customDataLabelsAsString
column.9.width=189
column.10.displayname=Risk Raised By
column.10.sharecol=true
column.10.textmode=true
column.10.usewidths=true
column.10.value=<br><span style="color:green;"><strong>Risk Raised By 5: </strong></span>
column.10.valueformat=HTML
column.10.width=189
column.11.displayname=Risk Raised By
column.11.sharecol=true
column.11.textmode=true
column.11.usewidths=true
column.11.valuefield=ccoRiskRaisedby5
column.11.valueformat=customDataLabelsAsString
column.11.width=189
column.12.displayname=Risk Raised By
column.12.sharecol=true
column.12.textmode=true
column.12.usewidths=true
column.12.value=<br><span style="color:green;"><strong>Risk Raised By 6: </strong></span>
column.12.valueformat=HTML
column.12.width=189
column.13.displayname=Risk Raised By
column.13.sharecol=true
column.13.textmode=true
column.13.usewidths=true
column.13.valuefield=ccoRiskRaisedby6
column.13.valueformat=customDataLabelsAsString
column.13.width=189
column.14.displayname=Risk Raised By
column.14.sharecol=true
column.14.textmode=true
column.14.usewidths=true
column.14.value=<br><span style="color:green;"><strong>Risk Raised By 7: </strong></span>
column.14.valueformat=HTML
column.14.width=189
column.15.displayname=Risk Raised By
column.15.sharecol=true
column.15.textmode=true
column.15.usewidths=true
column.15.valuefield=ccoRiskRaisedby7
column.15.valueformat=customDataLabelsAsString
column.15.width=189
column.16.displayname=Risk Raised By
column.16.sharecol=true
column.16.textmode=true
column.16.usewidths=true
column.16.value=<br><span style="color:green;"><strong>Risk Raised By 8: </strong></span>
column.16.valueformat=HTML
column.16.width=189
column.17.displayname=Risk Raised By
column.17.sharecol=true
column.17.textmode=true
column.17.usewidths=true
column.17.valuefield=ccoRiskRaisedby8
column.17.valueformat=customDataLabelsAsString
column.17.width=189
column.18.displayname=Risk Raised By
column.18.sharecol=true
column.18.textmode=true
column.18.usewidths=true
column.18.value=<br><span style="color:green;"><strong>Risk Raised By 9: </strong></span>
column.18.valueformat=HTML
column.18.width=189
column.19.displayname=Risk Raised By
column.19.sharecol=true
column.19.textmode=true
column.19.usewidths=true
column.19.valuefield=ccoRiskRaisedby9
column.19.valueformat=customDataLabelsAsString
column.19.width=189
column.20.displayname=Risk Raised By
column.20.sharecol=true
column.20.textmode=true
column.20.usewidths=true
column.20.value=<br><span style="color:green;"><strong>Risk Raised By 10: </strong></span>
column.20.valueformat=HTML
column.20.width=189
column.21.displayname=Risk Raised By
column.21.textmode=true
column.21.usewidths=true
column.21.valuefield=ccoRiskRaisedby10
column.21.valueformat=customDataLabelsAsString
column.21.width=189
Any assistance is appreciated!!
Thanks,
Solved! Go to Solution.
Views
Replies
Total Likes
Hello All,
I have managed to solve my own problem but thought I would post the answer for others.
This ensures only the fields with data show with their respective headers:
column.2.displayname=Risk Raised By
column.2.sharecol=true
column.2.textmode=true
column.2.usewidths=true
column.2.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby1}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 1:</span></div>"))
column.2.valueformat=HTML
column.2.width=189
column.3.displayname=Risk Raised By
column.3.sharecol=true
column.3.textmode=true
column.3.usewidths=true
column.3.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby1}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby1}+"</div>")
column.3.valueformat=HTML
column.3.width=189
column.4.displayname=Risk Raised By
column.4.sharecol=true
column.4.textmode=true
column.4.usewidths=true
column.4.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby2}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 2:</span></div>"))
column.4.valueformat=HTML
column.4.width=189
column.5.displayname=Risk Raised By
column.5.sharecol=true
column.5.textmode=true
column.5.usewidths=true
column.5.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby2}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby2}+"</div>")
column.5.valueformat=HTML
column.5.width=189
column.6.displayname=Risk Raised By
column.6.sharecol=true
column.6.textmode=true
column.6.usewidths=true
column.6.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby3}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 3:</span></div>"))
column.6.valueformat=HTML
column.6.width=189
column.7.displayname=Risk Raised By
column.7.sharecol=true
column.7.textmode=true
column.7.usewidths=true
column.7.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby3}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby3}+"</div>")
column.7.valueformat=HTML
column.7.width=189
column.8.displayname=Risk Raised By
column.8.sharecol=true
column.8.textmode=true
column.8.usewidths=true
column.8.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby4}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 4:</span></div>"))
column.8.valueformat=HTML
column.8.width=189
column.9.displayname=Risk Raised By
column.9.sharecol=true
column.9.textmode=true
column.9.usewidths=true
column.9.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby4}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby4}+"</div>")
column.9.valueformat=HTML
column.9.width=189
column.10.displayname=Risk Raised By
column.10.sharecol=true
column.10.textmode=true
column.10.usewidths=true
column.10.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby5}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 5:</span></div>"))
column.10.valueformat=HTML
column.10.width=189
column.11.displayname=Risk Raised By
column.11.sharecol=true
column.11.textmode=true
column.11.usewidths=true
column.11.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby5}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby5}+"</div>")
column.11.valueformat=HTML
column.11.width=189
column.12.displayname=Risk Raised By
column.12.sharecol=true
column.12.textmode=true
column.12.usewidths=true
column.12.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby6}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 6:</span></div>"))
column.12.valueformat=HTML
column.12.width=189
column.13.displayname=Risk Raised By
column.13.sharecol=true
column.13.textmode=true
column.13.usewidths=true
column.13.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby6}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby6}+"</div>")
column.13.valueformat=HTML
column.13.width=189
column.14.displayname=Risk Raised By
column.14.sharecol=true
column.14.textmode=true
column.14.usewidths=true
column.14.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby7}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 7:</span></div>"))
column.14.valueformat=HTML
column.14.width=189
column.15.displayname=Risk Raised By
column.15.sharecol=true
column.15.textmode=true
column.15.usewidths=true
column.15.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby7}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby7}+"</div>")
column.15.valueformat=HTML
column.15.width=189
column.16.displayname=Risk Raised By
column.16.sharecol=true
column.16.textmode=true
column.16.usewidths=true
column.16.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby8}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 8:</span></div>"))
column.16.valueformat=HTML
column.16.width=189
column.17.displayname=Risk Raised By
column.17.sharecol=true
column.17.textmode=true
column.17.usewidths=true
column.17.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby8}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby8}+"</div>")
column.17.valueformat=HTML
column.17.width=189
column.18.displayname=Risk Raised By
column.18.sharecol=true
column.18.textmode=true
column.18.usewidths=true
column.18.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby9}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 9:</span></div>"))
column.18.valueformat=HTML
column.18.width=189
column.19.displayname=Risk Raised By
column.19.sharecol=true
column.19.textmode=true
column.19.usewidths=true
column.19.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby9}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby9}+"</div>")
column.19.valueformat=HTML
column.19.width=189
column.20.displayname=Risk Raised By
column.20.sharecol=true
column.20.textmode=true
column.20.usewidths=true
column.20.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby10}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 10:</span></div>"))
column.20.valueformat=HTML
column.20.width=189
column.21.displayname=Risk Raised By
column.21.textmode=true
column.21.usewidths=true
column.21.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby10}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby10}+"</div>")
column.21.valueformat=HTML
column.21.width=189
Views
Replies
Total Likes
Hello All,
I have managed to solve my own problem but thought I would post the answer for others.
This ensures only the fields with data show with their respective headers:
column.2.displayname=Risk Raised By
column.2.sharecol=true
column.2.textmode=true
column.2.usewidths=true
column.2.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby1}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 1:</span></div>"))
column.2.valueformat=HTML
column.2.width=189
column.3.displayname=Risk Raised By
column.3.sharecol=true
column.3.textmode=true
column.3.usewidths=true
column.3.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby1}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby1}+"</div>")
column.3.valueformat=HTML
column.3.width=189
column.4.displayname=Risk Raised By
column.4.sharecol=true
column.4.textmode=true
column.4.usewidths=true
column.4.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby2}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 2:</span></div>"))
column.4.valueformat=HTML
column.4.width=189
column.5.displayname=Risk Raised By
column.5.sharecol=true
column.5.textmode=true
column.5.usewidths=true
column.5.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby2}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby2}+"</div>")
column.5.valueformat=HTML
column.5.width=189
column.6.displayname=Risk Raised By
column.6.sharecol=true
column.6.textmode=true
column.6.usewidths=true
column.6.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby3}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 3:</span></div>"))
column.6.valueformat=HTML
column.6.width=189
column.7.displayname=Risk Raised By
column.7.sharecol=true
column.7.textmode=true
column.7.usewidths=true
column.7.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby3}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby3}+"</div>")
column.7.valueformat=HTML
column.7.width=189
column.8.displayname=Risk Raised By
column.8.sharecol=true
column.8.textmode=true
column.8.usewidths=true
column.8.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby4}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 4:</span></div>"))
column.8.valueformat=HTML
column.8.width=189
column.9.displayname=Risk Raised By
column.9.sharecol=true
column.9.textmode=true
column.9.usewidths=true
column.9.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby4}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby4}+"</div>")
column.9.valueformat=HTML
column.9.width=189
column.10.displayname=Risk Raised By
column.10.sharecol=true
column.10.textmode=true
column.10.usewidths=true
column.10.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby5}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 5:</span></div>"))
column.10.valueformat=HTML
column.10.width=189
column.11.displayname=Risk Raised By
column.11.sharecol=true
column.11.textmode=true
column.11.usewidths=true
column.11.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby5}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby5}+"</div>")
column.11.valueformat=HTML
column.11.width=189
column.12.displayname=Risk Raised By
column.12.sharecol=true
column.12.textmode=true
column.12.usewidths=true
column.12.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby6}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 6:</span></div>"))
column.12.valueformat=HTML
column.12.width=189
column.13.displayname=Risk Raised By
column.13.sharecol=true
column.13.textmode=true
column.13.usewidths=true
column.13.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby6}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby6}+"</div>")
column.13.valueformat=HTML
column.13.width=189
column.14.displayname=Risk Raised By
column.14.sharecol=true
column.14.textmode=true
column.14.usewidths=true
column.14.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby7}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 7:</span></div>"))
column.14.valueformat=HTML
column.14.width=189
column.15.displayname=Risk Raised By
column.15.sharecol=true
column.15.textmode=true
column.15.usewidths=true
column.15.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby7}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby7}+"</div>")
column.15.valueformat=HTML
column.15.width=189
column.16.displayname=Risk Raised By
column.16.sharecol=true
column.16.textmode=true
column.16.usewidths=true
column.16.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby8}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 8:</span></div>"))
column.16.valueformat=HTML
column.16.width=189
column.17.displayname=Risk Raised By
column.17.sharecol=true
column.17.textmode=true
column.17.usewidths=true
column.17.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby8}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby8}+"</div>")
column.17.valueformat=HTML
column.17.width=189
column.18.displayname=Risk Raised By
column.18.sharecol=true
column.18.textmode=true
column.18.usewidths=true
column.18.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby9}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 9:</span></div>"))
column.18.valueformat=HTML
column.18.width=189
column.19.displayname=Risk Raised By
column.19.sharecol=true
column.19.textmode=true
column.19.usewidths=true
column.19.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby9}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby9}+"</div>")
column.19.valueformat=HTML
column.19.width=189
column.20.displayname=Risk Raised By
column.20.sharecol=true
column.20.textmode=true
column.20.usewidths=true
column.20.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby10}),"",CONCAT("<div style='margin-bottom:4px;'><span style='color:green; font-weight:bold;'>Risk Raised By 10:</span></div>"))
column.20.valueformat=HTML
column.20.width=189
column.21.displayname=Risk Raised By
column.21.textmode=true
column.21.usewidths=true
column.21.valueexpression=IF(ISBLANK({DE:ccoRiskRaisedby10}),"","<div style='margin-bottom:8px;'>"+{DE:ccoRiskRaisedby10}+"</div>")
column.21.valueformat=HTML
column.21.width=189
Views
Replies
Total Likes
Views
Likes
Replies