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