I am not sure if my question sounds silly. I have a table that has a few columns like date,source,race and state. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number of calls for each state,each source and race distinctly.
source state race
star sel ind
newstraits KL malay
mlymail pahang china
i need to display the report as
date star newstraits mlymail sel Kl pahang ind malay china
10/2/2006 2 3 4 1 2 4 5 6
I'm not sure if this can be done because what i need to do seems like getting the values of a column and displaying it as a new column.
I hope my question is clear.
i Hope someone can,if you dun find this question clear,please reply.
Thnk you in advance.