Hello Folks,
I am trying to create a table format where i have setup the page layout to A4 size. I populate the table with data that is received from the server and that is only single column,everything works fine. What i want is when the data is inserted into Col A i want the data to fill the Col B and so on when the page break occurs and then if that page has no space left it should start filling the data in the next page. when the data move to col b and so on it should also have headers.
I am looking for something like this https://stackoverflow.com/questions/22785823/how-to-repeat-table-in-one-report-side
As i was googling for this i found pointers to Tablix data regions but i am not sure how to use that on Excel.
Any guidance is appreciated.
I am trying to create a table format where i have setup the page layout to A4 size. I populate the table with data that is received from the server and that is only single column,everything works fine. What i want is when the data is inserted into Col A i want the data to fill the Col B and so on when the page break occurs and then if that page has no space left it should start filling the data in the next page. when the data move to col b and so on it should also have headers.
I am looking for something like this https://stackoverflow.com/questions/22785823/how-to-repeat-table-in-one-report-side
As i was googling for this i found pointers to Tablix data regions but i am not sure how to use that on Excel.
Any guidance is appreciated.