Dynamic Grouping in RTF

Question

Summary

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.

Aqaimkha · Answer

Thanks for the reply, I guess I got it working as below. 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 group_by proj_mngr display proj_mngr display field1 field2 fiedl3 field4 field5 end group_by proj_mngr display field1 field2 fiedl3 field4 Thanks again.

Venkat Thota - BIP · Answer

upload RTF and xml , will send modified one , Thanks

Aqaimkha · Answer

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 1 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.