Multi Column Subreport

Hi,

I am trying to use a multi column report as a subreport. I want to know how can I do it without loosing multi column.

Thanks,

-Rohit

Can you be a bit more specific? Have tried something already and not got the expected behaviour? What exactly are you trying to do?|||

I have these reports which I am running separately. One of them is a multi column report also. I want to put together all these reports in one report, for that I am using these reports as subreports.

The problem I am facing is, when I use multicolumn reports as subreport, I loose the multicolumn part of it. All the data come as one single column. I am using Rectangle to hold the subreports. May be I am not doing it wrong.

Can you please help me, how can I bind all my individual reports into one single report and not loose any formatting (i.e.multicolumn and page size)?

Thanks a lot,

-Rohit

|||

I have these reports which I am running separately. One of them is a multi column report also. I want to put together all these reports in one report, for that I am using these reports as subreports.

The problem I am facing is, when I use multicolumn reports as subreport, I loose the multicolumn part of it. All the data come as one single column. I am using Rectangle to hold the subreports. May be I am not doing it wrong.

Can you please help me, how can I bind all my individual reports into one single report and not loose any formatting (i.e.multicolumn and page size)?

Thanks a lot,

-Rohit

|||I'm still not sure what you mean by multicolumn subreport. Are you using a table or a matrix in the subreport?|||

You know how there are multi column reports (news paper style)... the same way I have one of those multi column report. But I want to use that report in another report. I am useing "subreport" feature for this. But the problem is when I use that multi column (news paper style) report in the main report, I loose the multi column from the report. All the data comes in one single column. So my question is how can I use my multi column report in another report without loosing multiple columns ability.

Thank You,

-Rohit

|||

Hi,

I am having exactly the same issue. Did you ever find a resolution to this problem? Are you using SQL Server 2005 and VS 2005?

Thanks,

Amy Bolden

|||

Hi Amy,

I am also facing the same problem and it seems that we cannot have multiple column sub reports.

Refer to the reply provided by MS in the following post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=105411&SiteID=1

Regards,

Ashish

|||

Dear Ashish,

I finally broke down and called Microsoft and they confirmed this as well. Fortunately they have a money back guarentee on service calls if they are unable to provide a solution so at least it didn't cost the company any money.

Thanks for your help!

Amy

Multi Column Subreport

Hi,

I am trying to use a multi column report as a subreport. I want to know how can I do it without loosing multi column.

Thanks,

-Rohit

Can you be a bit more specific? Have tried something already and not got the expected behaviour? What exactly are you trying to do?|||

I have these reports which I am running separately. One of them is a multi column report also. I want to put together all these reports in one report, for that I am using these reports as subreports.

The problem I am facing is, when I use multicolumn reports as subreport, I loose the multicolumn part of it. All the data come as one single column. I am using Rectangle to hold the subreports. May be I am not doing it wrong.

Can you please help me, how can I bind all my individual reports into one single report and not loose any formatting (i.e.multicolumn and page size)?

Thanks a lot,

-Rohit

|||

I have these reports which I am running separately. One of them is a multi column report also. I want to put together all these reports in one report, for that I am using these reports as subreports.

The problem I am facing is, when I use multicolumn reports as subreport, I loose the multicolumn part of it. All the data come as one single column. I am using Rectangle to hold the subreports. May be I am not doing it wrong.

Can you please help me, how can I bind all my individual reports into one single report and not loose any formatting (i.e.multicolumn and page size)?

Thanks a lot,

-Rohit

|||I'm still not sure what you mean by multicolumn subreport. Are you using a table or a matrix in the subreport?|||

You know how there are multi column reports (news paper style)... the same way I have one of those multi column report. But I want to use that report in another report. I am useing "subreport" feature for this. But the problem is when I use that multi column (news paper style) report in the main report, I loose the multi column from the report. All the data comes in one single column. So my question is how can I use my multi column report in another report without loosing multiple columns ability.

Thank You,

-Rohit

|||

Hi,

I am having exactly the same issue. Did you ever find a resolution to this problem? Are you using SQL Server 2005 and VS 2005?

Thanks,

Amy Bolden

|||

Hi Amy,

I am also facing the same problem and it seems that we cannot have multiple column sub reports.

Refer to the reply provided by MS in the following post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=105411&SiteID=1

Regards,

Ashish

|||

Dear Ashish,

I finally broke down and called Microsoft and they confirmed this as well. Fortunately they have a money back guarentee on service calls if they are unable to provide a solution so at least it didn't cost the company any money.

Thanks for your help!

Amy

Multi column report as a subreport

I have a table report where amoung other things there is a list of names
from another data set. I don't want the names to print in one column because
the list maybe more than one page. I can create a multi column report for
just the names and when printed or print preview will display in multiply
columns (good). But when I add that report as a subreport to my main report
I believe it ignores the subreport's 'report properties' and uses the main
'report's properties'?
Any suggestions?
JohnI found this in 2005 Books online, I would guess that 2000 is the same.
Apparently the column setting is inherited from the parent report.
Denny
SQL Server 2005 Books Online
Writing Multi-Column Reports
Updated: 5 December 2005
You can design a report that uses a multi-column layout, similar to a
traditional newspaper column where data flows down multiple adjacent
columns. A multi-column layout applies to the entire report. It is not
possible to specify a multi-column layout on the top half of the report, and
a tabular layout on the bottom half of the report. When you specify a
multi-column layout, the report server creates each column as a series of
very narrow pages that are rendered in close sequence, giving the appearance
of multiple columns. Properties that you set at the page level are applied
to each column in the report. You can define as many columns you want.
For best results, use data regions that provide repeating rows of data (for
example, table or list box). A list box placed within a multi-column report
will display data from the top left of the page to the bottom left of the
page, and then continue the list in the adjacent column at the top of the
page. If you want to use text boxes or images, put them in a list so that
they repeat in each column.
If you are accustomed to using subreports to embed a separate report within
a parent report, be aware that you cannot use subreports to get the same
outcome in a multi-column layout. In a multi-column report, a subreport
inherits the column settings of the parent report. This means that if you
define a multi-column layout on a subreport, the subreport ignores the
column settings that are specified for it. It also means that you cannot use
subreports to create a free-form or single column layout within the
multi-column report. Subreports that you include in a multi-column report
always use the column settings of the parent report
"johnsh" <johnsh@.axiumae.com> wrote in message
news:%23%23usVHbhGHA.4368@.TK2MSFTNGP03.phx.gbl...
>I have a table report where amoung other things there is a list of names
>from another data set. I don't want the names to print in one column
>because the list maybe more than one page. I can create a multi column
>report for just the names and when printed or print preview will display in
>multiply columns (good). But when I add that report as a subreport to my
>main report I believe it ignores the subreport's 'report properties' and
>uses the main 'report's properties'?
> Any suggestions?
> John
>