<div>
dtfla, <br />
<br />
Just to clarify are you talking columns like multiple columns in a table? or multiple columns on the report in general, like printing avery labels or some such?
</div>


dtfla,

Just to clarify are you talking columns like multiple columns in a table? or multiple columns on the report in general, like printing avery labels or some such?

<div>
In the properties of the Body section of any report, you can set the number of columns (by default it is set to 1). &nbsp; In my case I want the sub-report to have 2 columns and the parent report to have 1 column. &nbsp;This is not possible in Report Server 2005. &nbsp;The column property of the parent report passes through to the sub-report.<br />
I have a list of names in the sub-report that I would like to display in multiple colunns on the final report.<br />

</div>


In the properties of the Body section of any report, you can set the number of columns (by default it is set to 1).   In my case I want the sub-report to have 2 columns and the parent report to have 1 column.  This is not possible in Report Server 2005.  The column property of the parent report passes through to the sub-report.
I have a list of names in the sub-report that I would like to display in multiple colunns on the final report.


<div>
<div class="content wysiwyg-content">
SQL Report Server 2005 does not support subreports having multiple columns when the parent report only has one column. &nbsp;In other words, the properties of the parent report get passed to the subreport.<br />
<br />
Has this changed in SQL Report Server 2008? Can a subreport in 2008 have a different number of columns than the parent report? <br />
<br />
Or is there a way to get around this situation in 2005?
</div>
</div>


SQL Report Server 2005 does not support subreports having multiple columns when the parent report only has one column.  In other words, the properties of the parent report get passed to the subreport.

Has this changed in SQL Report Server 2008? Can a subreport in 2008 have a different number of columns than the parent report? 

Or is there a way to get around this situation in 2005?

SQL Report Server 2008 Mulit-Column SubReport

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.