To render correctly the report with dataset for 25 column to Excel what would you use
A.
Matrix
B.
Rectangular
C.
Table
D.
Lists
Explanation:
http://technet.microsoft.com/en-us/library/cc966445.aspx
Data Regions
One of your first critical design decisions is which type of data region to use in your report.
Reporting Services offers the following types of data regions:
Tables A table represents data, row by row. The columns are static in that they do not
expand, but the rows expand downward. Thus, as a table grows, it pushes the data beneath
it downward. You can also group data within the table.
Matrices
A matrix, or crosstab, is like a table, but both columns and rows can expand to
accommodate data. A matrix can push other report objects downward and outward on the
report page. You can group data and also nest columns and rows within the matrix.
Lists
A list is a freeform data region that is often used for creating forms. You can nest lists within
lists to group data.
Charts
A chart is a graphical representation of data. Reporting Services offers a wide range of chart
formats. Your choice of data regions may depend on the type of data you are using, what
you want the report to look like, and how you are rendering the report. For example, reports
rendered to Microsoft® Excel® tend to work better when using a table instead of a list.