If you are unable to create a new account, please email support@bspsoftware.com

 

Advanced Conditional Style to Set Box Type to None in Repeater in a List Column

Started by Cognos_Jan2017, 31 Jul 2018 01:53:24 PM

Previous topic - Next topic

Cognos_Jan2017

Running Excel Report w/ Prompt Page to select "Hide" or "Show" all rows in a List.

Works fine to set Box Type of ALL List Columns to None if "Hide" is selected ... EXCEPT for a Repeater.

Uses ...
Data Item of "ToSeeOrNot" Data Item.  This is added to the List Layout as a Singleton.

"ToSeeOrNot" calculates as ...
Case
When ?p_HideShow?='Hide' Then 'NoSee'
When ?p_HideShow?='Show' Then 'YesSee'
End

The advanced conditional style "See_Or_Hide" then sets Box Type to None if 'NoSee".

The problem ...
We have a Repeater which concatenates "Owner(s)".  Our 3rd-party Cloud App assigns
only One "Owner" to a Task.  When that same task has 2 or more "Owners", it has 2 or
more records.

The Repeater makes "One Record" appear in the List no matter how many Owners may
be assigned.

A List Column of a Repeater does NOT have an entry for a Conditional Style.

I can assign the Conditional Style to the Text Item within the Repeater List Column
which makes an entry "Blank" but the Box Type for the Repeater is still there.

Thoughts on setting a List Column Repeater Box Type to none in response to
"Hide" or "Show" ??

TIA, Bob

Cognos_Jan2017

S O L U T I O N ...

My error -->  I originally selected what I thought was the Full List Column (it displayed
"Repeater"). I re-examined this afternoon by selecting again to see "List column body".
The outline of the "List column body" is only slightly larger than the Data Item listed in
the "Repeater".

I then applied the "See_Or_Hide" Conditional Style to "List column body" and all is fine.