We help IT Professionals succeed at work.

Reports - cross tab display

SMadhavi
SMadhavi asked
on
Hi I hav edata for a report that needs to be displayed in a cross tab format.

the data is

T      C1        C2              Q              A        S
T1   SSS       DDD        qUES1    ANS1        2
T1   SSS       DDD        qUES2    ANS2       1
T1   SSS       DDD        qUES13   ANS3       5
T3   BBB       QQQ       QUES1     ANS 1     3
T3    BBB       QQQ       QUES2     ANS A     7
T3   BBB       QQQ       QUES3     ANS 3     3


i NEED TO DISPLAY THIS RESULT SET IN REPORTS IN THIS FORMAT. i USE CROSSTAB FORMAT
       C1        C2              QUES 1      qUES2     QUES3      QUES4     QUES5  
T1  SSS   DDD             2                   1               5
T3   BBB       QQQ       3                   7              3


nO IDEA HOW i CAN DO THIS.

aNY HELP WILL BE APPRECIATED. nEW TO REPORT FORMATING AND DISPLAYING DATA IN APARTICULAR FORMAT.

tHANKS

yrks

wHAT HAPPENS IS THAT THE T1 IS DISPLAYED 3 TIMES.  i WOULD LIKE THIS DATA TO BE DISPALYED AS

                 C1        C2              Q              A        S


Comment
Watch Question