Skip to Content
0
Former Member
Jul 14, 2008 at 08:25 PM

Crosstab ?

45 Views

Hello all,

My report has following columns to display

store string

avg1 number

avg2 number

avg3 number

avg4 number

grade string

The store values should be displayed horizontally and the avg values should be displayed corresponding to the store values.

using crosstab control we can achieve this format easily but the problem is with the grade column. The CR reading it as number type and displaying 1 as the value for each column.

roughly, i need to develop the report in the following way:

      store1   store2   store3   store4   store5   
avg1   99         99         99        99         99
avg2   99         99         99        99         99
avg3   99         99         99        99         99
avg4   99         99         99        99         99
grade  A          A          A          F          B

how can i resolve this issue or is there any other way without using crosstab control to achieve the above format.

Thanks in advance,

Vinesh