Text object

[bhavvibudagam]

Hi,

In a text object i have entered this condition

if(GetSelectedCount(AGENCYEVENT.DISTRICT)>0, 'AGENCYEVENT.DISTRICT  :'&  Concat(GetFieldSelections(AGENCYEVENT.DISTRICT),',') ) & ' '&

I have used this condition for showing filed selections i have total 210 fields right now i have added 200 fields after that it's not taking field name as field showing field name in black color.

Is their any limitation of characters in text object.if yes is their any possibility to do in any other way.please help me to do.

Thanks,

[Anonymous]

Hi

Post sample image

[ziadm]

Try This in the Dimension enable condition

=IF( (GetSelectedCount(Calendar))> 0), SubStringCount(Calendar), '|'), 'Year') ,0 )

Lets assume your Dimension is Year and you want to enable or disable that Dimension based on the user selection of Year Field.

Calendar is Your Table where "Year" is a Record in that Table

[bhavvibudagam]

HI Anil,

After 201 line it SHOWS ACCIDENT_WEEKDAY IN BLACK

[bhavvibudagam]

i AM WORKING IN REPORT BUILDER.I am applying the condition which is shown on above image in bottom blue color text object.The selection which i have done in filter will appear below.

[ziadm]

=IF( (GetSelectedCount(LWCASE))> 0), SubStringCount(LWCASE), '|'), 'ASSIGNED_DIVISION') ,0 )

if ASSIGNED_DIVISION SELECTED THEN enable the Dimension

[vinieme12]

Can you post your full expression?

also you won't need getfieldselection in Concat function

if(GetSelectedCount(AGENCYEVENT.DISTRICT)>0,'AGENCYEVENT.DISTRICT  :'&  Concat(DISTINCT AGENCYEVENT.DISTRICT,',')) & ' | ' &