locked
How to create a column group using two field values? RRS feed

  • Question

  •  

    Hello Friends,

                          I am creating a report in which I want to create group column using two field value. Is it possible to do so? We have a requirement in which we are fetching data from two different hierarchy.

     

     

                                 A B C D E F G H I J K

                             L  1 2 3....................4 5

                             M .............................

                             N .........................

                             O .......................

                             P

     

    The report matrix look like the above one. The elements A,B,C are coming from one hierarchy and D,E,F,G,H,I,J,K are coming from other hierarchy. But i have created one data set to fetch the values for the report. But while creating the column group I am getting both two diff fields so I am not able to use it in single Column group and I want to use only one column group.

     

    Can anybody help me out to solve this issue?

    Tuesday, March 11, 2008 9:25 AM

Answers

  • Hi,

    One data region can only be band with one dataset. So the matrix using two field values is not acceptable. You may try to combine these two datasets into one dataset. Such as using the UNION function in the SQL statement.

    Thanks.

     

    Wednesday, March 19, 2008 10:16 AM