Dynamic Grouping in RTF

Aqaimkha

Summary

Dynamic Grouping in RTF

Content

Is it possible to have group by based of input parameter passed in XML for example user may pass to GROUP BY DEPTNO OR JOB OR AGE OR no GROUP BY at all.

Venkat Thota - BIP

Yes possible ,

1) first define parameter <?param:deptno?>

2) use parameter as grouping element as <?for-each-group:/DATA_DS/G_1;./$deptno?>

Thanks

Venkat Thota - BIP

upload RTF and xml , will send modified one , Thanks

Aqaimkha

I'm new to BI, my might not be clear or didn't asked correctly, it is about building RTF in word, user passes parameter GROUP_BY_OPTION in xml as

<GROUP_BY_OPTION>1</GROUP_BY_OPTION>

IF (GROUP_BY_OPTION ='1') THEN

       group_by deptno

         display     deptno

            group_by area

            display area

                        display        field1      field2       fiedl3      field4        field5        field6     

            end group_by area

         display area_total :999

      end group_by deptno

        display deptno total: 999

ELSE IF (GROUP_BY_OPTION ='2') THEN

group_by proj_mngr

         display     proj_mngr

                        display        field1      field2      fiedl3  field4  field5

            end group_by proj_mngr

ELSE

            display        field1      field2      fiedl3  field4 

END IF

Thanks again for quick reply, any help would be appreciated.

Aqaimkha

Thanks for the reply, I guess I got it working as below.

<?if:IN_GROUP_BY=’1’?>

group_by deptno

         display     deptno

            group_by area

            display area

                        display        field1      field2       fiedl3      field4        field5        field6     

            end group_by area

         display area_total :999

      end group_by deptno

        display deptno total: 999

<?end if?>

<?if:IN_GROUP_BY=’2’?>

group_by proj_mngr

         display     proj_mngr

                        display        field1      field2      fiedl3  field4  field5

            end group_by proj_mngr

<?end if?>

<?if:IN_GROUP_BY=’0’?>

display        field1      field2      fiedl3  field4 

<?end if?>

Thanks again.