BHScripter
Technical User
Hello:
I am building a report that groups by the following:
Parent Curriculum
Main Activity
Child Activities
Sometimes the value for the group child activities is "NoDetail" which is just a hardcoded placeholder value generated by the query. I want to suppress the visibility of the Child Activities group header and footer if the value for that group is "NoDetail" I attempted to put the following in the visibility expression for the group header but it returned an error as an invalid value:
IIF(Fields!ChildActivity.Value = "NoDetail",True,False)
Any help would be most appreciated.
Thanks!
I am building a report that groups by the following:
Parent Curriculum
Main Activity
Child Activities
Sometimes the value for the group child activities is "NoDetail" which is just a hardcoded placeholder value generated by the query. I want to suppress the visibility of the Child Activities group header and footer if the value for that group is "NoDetail" I attempted to put the following in the visibility expression for the group header but it returned an error as an invalid value:
IIF(Fields!ChildActivity.Value = "NoDetail",True,False)
Any help would be most appreciated.
Thanks!