Hello,
I have a question which I am sure someone can tell me which way to go. I have a table that has records with three columns which are name, date and value. I would like to have my grid grab all the unique dates in my database and make them column captions and grab the unique names in my database and make them row captions then place the value in the appropriate row and column. here is an example;
Any help will be GREATLY appreciated!
Andrew
I do not think that this is an Infragistics Grid issue. It is a SQL Database pivot table query. If you can construct the pivot query to get the results, then assign that result set as the DataSource to the grid.
Norm