Render Variable without using Boolean Varible

[karan27]

 Prompt Page

  O   ENAME
  O   JOB
  O   SAL
  O   HIREDATE


     [Finish]

On the Report page Following are mandatory columns.

EMPNO DEPTNO
9090       30
7369       20
7499       30
7521       30
7566       20
7654       30
7782       10 

Now I have created STRING VARIABLE with following condition,

if  (ParamValue('Parameter1') contains ('ENAME')) then ('ENAME') else

if  (ParamValue('Parameter1') contains ('JOB')) then ('JOB') else

if  (ParamValue('Parameter1') contains ('SAL')) then ('SAL') else

if  (ParamValue('Parameter1') contains ('HIREDATE')) then ('HIREDATE')

With this condition when I am selecting single value i.e('ENAME' OR 'JOB' OR 'SAL' OR 'HIREDTAE') from prompt page then I am getting proper output.

But when I am selecting multiple values together i.e('EMANE' AND 'JOB' AND 'SAL') then output showing only ENAME with mandatory columns i.e('EMPNO' and 'DEPTNO')

The problem is when I am selecting multiple values that time first IF condition is execute and satisfy so it is not executing rest ELSE and IF part.

is there any way to execute remaining else part as wel

Thanks in Advance....

[schrotty]

Hello again,

why won't you use one single boolean variable for each from your multi-select-prompt?

The "case when"- and "if elseif"-structures breaks allways when a match is found.

[karan27]

Schrotty, Thanks again for your reply.

Yes, we can achieve the output using Boolean variable for each.

but the task given to me is achieve output without using Boolean variable.

[schrotty]

Hi,

i consider the only way to solve this problem with a string variable is to set foreach possible combination of your choices set an other value:

eg.
CASE
WHEN ParamValue('Parameter1') = 'ENAME' THEN 'ENAME'
WHEN ParamValue('Parameter1') = 'ENAME ,JOB' THEN 'ENAME_JOB'
WHEN ParamValue('Parameter1') = 'ENAME ,JOB ,SAL' THEN 'ENAME_JOB_SAL'
...

:-\

[BigChris]

Is there a particular reason for not using boolean variables?

[Francis aka khayman]

prompt page looks like it uses radio buttons, so how can you do multiple select? or am i just too focused on detail I should ignore?