Table from two columns [modified]
-
Hi everyone, I am looking at creating a table that lists the number of records based on two columns in a view. Meaning that the two columns refer to an x and a y axis in the table and the cell should be the number of records in the view for that combination. ie if we had hair colour as an x axis and age as the y axis i would have a layout like this hair colour ----> a g e | | | ^ then each cell across would display the number of records for each hair colour at a particular age. I need to create it after a user sets a the options and parameters for the table and then clicks generate report. This page is opened up with the correct table. I have all the parameters and everything set up and being retrieved correctly i am just wondering how to display the data? ie what kind of control can i use and what kind of query will i need to populate the data...any help most aprreciateted. Cheers Cads -- modified at 10:03 Wednesday 13th June, 2007 I had a thought just now that maybe I could create this in SQL then just display it in a repeater control but again i don't know if this is possible? if someone can help I would be grateful.