Posted on: 1/21/2014 9:52:22 PM | Views : 652

We have a report we need to generate and display on the page. I had started with a FormView control to bind all the data to the page and variables. But i need to display multiple record rows from the db on the one page..
My test right now returns 2 rows (28 columns) from the query
On the page i need to it to layout and look like this.. now, i have a DataSet that is being returned and used to bind to the formview.. which means i get back 2 rows of 28 columns that i need to display below.

The upper portion is pretty straight forward as that is the same for each row, but the values i need to display in the columns below.. since i get back 2 rows, i need to know how i can display row 1 data in column 1 and row 2 data in column 2 of the page layout.
Am i going about this the wrong way? is it something i need to handle within SQL? Do i need to return 4 d ...

Go to the complete details ...