i have table which is containing group,route,date.
I have data lik this.
1. group route date
a1 3 1/1/06
a1 35 1/1/06
a2 4 1/1/06
want to show data lik that
dates 1 2 3 4 5 6 7
---------------------------------------
a1 3,32 2
a2 4 1
data like that.
thanks in advance
rakesh
