• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

SQL Report Server 2008 Mulit-Column SubReport

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?
  • 2
1 Solution

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?
dtflaAuthor Commented:
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.
dtflaAuthor Commented:
I have installed SQL 2008 on a test server and attempted a report that would have one column on the main report and 2 columns on the subreport.  The parent properties did indeed propagate to the subreport as only one column displayed for the subreport.  So this has not changed from RS2005 to RS2008.

It is a shame.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now