Going crazy

Ok, what is the secret, I give.
I have a report with a couple sub reports. The sub reports seem to want to
spread to the complete width of the report plus more causing multiple pages
to be used (for the information that is pushed off the right edge).
I have tried to use tables, rectangles etc. but i cannot get the contents of
the report from spreading. It appears the rectangle works for the report but
the sub reports spread out as much as possible.
I have tried putting the sub reports in rectanges, grids and still have the
problem
I am using vs.net 2005 and sql 2005
Help please.Two things matter here. The design of the subreport and where you put the
subreport on the page. Run the subreport by itself, how big is it? Look at
the layout properties of the subreport.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dave" <dave@.discussions.microsoft.com> wrote in message
news:39888271-A207-4302-843F-16B1CA1E6B74@.microsoft.com...
> Ok, what is the secret, I give.
> I have a report with a couple sub reports. The sub reports seem to want
> to
> spread to the complete width of the report plus more causing multiple
> pages
> to be used (for the information that is pushed off the right edge).
> I have tried to use tables, rectangles etc. but i cannot get the contents
> of
> the report from spreading. It appears the rectangle works for the report
> but
> the sub reports spread out as much as possible.
> I have tried putting the sub reports in rectanges, grids and still have
> the
> problem
> I am using vs.net 2005 and sql 2005
> Help please.
>