Hello everyone,
I was wondering how I can use what is returned from Getting a Scriptable object.
For example, I have this code that I use with the distribution platform
biv={};
Biv1={};
Biv2={};
Biv3={};
test=0;
Biv1 = Current Report()[OutlineBox(1)] << Get Scriptable Object;
Biv2 = Current Report()[OutlineBox(2)] << Get Scriptable Object;
Biv3 = Current Report()[OutlineBox(3)] << Get Scriptable Object;
if(biv3=={Distribution[]},
Biv = Current Report()[OutlineBox(3)] << Get Scriptable Object;
test=3;
,
biv2=={Distribution[]},
Biv = Current Report()[OutlineBox(2)] << Get Scriptable Object;
test=2;
,
biv1=={Distribution[]},
Biv = Current Report()[OutlineBox(1)] << Get Scriptable Object;
test=1;
,
".";
);The problem is that my If statement is not working as none of the Biv1-3 are recognizing the scripital object return value.
I'm using this to identify if there is a local data filter or column switcher and thus return the right outline box.
if there is no LDF or CS then i use outline box 1, if there is either a LDF or CS I use outline box 2, if there is both a LDF and a CS I use outline box 3.
thanks for any ideas
Steve
Maybe solution from here can help Check Display box existence by JSL
Maybe you could try changing those to characters? Not sure how robust this would be but could work just fine:
if(char(biv3) == "Distribution[]",<BR />...