how can I create a table where the number of rows are unknown at design time but the number of columns are fixed?
I dont think crosstabs work for this.
Thanks in advance
Post Edited by nsamagond at 05/21/2009 00:19
What you're describing is a typical tabular layout. It's handled by the built-in report wizard. You return a fixed number of fields from the data source. Then you display each in the detail band. The band is repeated for each row, so you don't need to know how many rows there will be.
I have a follow-up question.
I have several tables to display and in the detail band, but the way it works, as I understand, it only displays one table.
So, for example if my query returns a 100 rows which have 75 colums, I have to display 5 tables, each table have will have about 8 -13 random columns of the 75 columns and each of the 100 rows.
Post Edited by nsamagond at 05/21/2009 19:10
Could you start a new thread with this new question?
Please add a few details. I'm not at all sure what you mean by "each table have will have about 8 -13 random columns of the 75 columns". Maybe it's best to describe what you want to see in each of the 5 tables, then we can offer guidance about how to achieve it.