Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blas53
Starting Member
15 Posts |
 Posted - 2005-11-02 : 15:56:43
|
| Hello,I need to generate a report that uses a dynamic table like this: In SQL Server I execute a query that creates a table that can have different number of columns depending on certain calculations and data. The problem is that this table does not have a fixed number of columns, hence making it difficult to vinculate each column in the table with a cell in a table or matrix in reporting services. I need to create somehow a dynamic table in RS so that it can hold this data brought by the dynamic table. Is this possible somehow?Thanks for your collaboration. |
|
|
jhermiz
3564 Posts |
Posted - 2005-11-08 : 12:16:54
|
Because your result set is dynamic you will need to use the MATRIX object in reporting services. Very simple works much like the TABLE object.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
Dynamic table