Maximum Length of Report Reached in Report Designer- Bug?

We have reached the maximum length that Report Designer allows - 180 inches.
The problem is that we need to make the report longer. Also - it appears that
the maximum size for a rectangle is 60 inches - this also is too small. Does
anyone know how to report these items to Microsoft Reporting Services
Development as an enhancement request / defect?According to the MS webinar, the page problem has been fixed. The
webinar info has been posted to the WIKI:
http://www.reportingservicesfaq.com/ow.asp?SP2ForRS%3F
jstocker101 wrote:
> We have reached the maximum length that Report Designer allows - 180 inches.
> The problem is that we need to make the report longer. Also - it appears that
> the maximum size for a rectangle is 60 inches - this also is too small. Does
> anyone know how to report these items to Microsoft Reporting Services
> Development as an enhancement request / defect?|||You might be refering to 883501 but that is a different bug. The
details of that bug are related to an error message you get when you
export to Excel. Here is that article:
http://support.microsoft.com/kb/883501
But the problem we are having would not be fixed by Reporting Services
Service Pack 2. Again, the Report Designer tool does not allow you to
create a report larger than 180 inches, and rectangles are limited to
inches. After reviewing the bugs fixed in Reporting Services SP2, none
of the fixes address this issue.
This is a major problem because you cannot create a large report in
Reporting Services!!
Jerry wrote:
> According to the MS webinar, the page problem has been fixed. The
> webinar info has been posted to the WIKI:
> http://www.reportingservicesfaq.com/ow.asp?SP2ForRS%3F
>
>
> jstocker101 wrote:
> > We have reached the maximum length that Report Designer allows -
180 inches.
> > The problem is that we need to make the report longer. Also - it
appears that
> > the maximum size for a rectangle is 60 inches - this also is too
small. Does
> > anyone know how to report these items to Microsoft Reporting
Services
> > Development as an enhancement request / defect?|||In SP2, the maximum height or width for any object is 160 inches. I'm
interested in the scenario that requires such a long report. Can you design
your report as subreports and combine the subreports together in one large
report?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<jstocker@.gmail.com> wrote in message
news:1109014748.413769.319290@.f14g2000cwb.googlegroups.com...
> You might be refering to 883501 but that is a different bug. The
> details of that bug are related to an error message you get when you
> export to Excel. Here is that article:
> http://support.microsoft.com/kb/883501
> But the problem we are having would not be fixed by Reporting Services
> Service Pack 2. Again, the Report Designer tool does not allow you to
> create a report larger than 180 inches, and rectangles are limited to
> inches. After reviewing the bugs fixed in Reporting Services SP2, none
> of the fixes address this issue.
> This is a major problem because you cannot create a large report in
> Reporting Services!!
>
> Jerry wrote:
> > According to the MS webinar, the page problem has been fixed. The
> > webinar info has been posted to the WIKI:
> >
> > http://www.reportingservicesfaq.com/ow.asp?SP2ForRS%3F
> >
> >
> >
> >
> > jstocker101 wrote:
> > > We have reached the maximum length that Report Designer allows -
> 180 inches.
> > > The problem is that we need to make the report longer. Also - it
> appears that
> > > the maximum size for a rectangle is 60 inches - this also is too
> small. Does
> > > anyone know how to report these items to Microsoft Reporting
> Services
> > > Development as an enhancement request / defect?
>|||We require one long report because when we export to PDF, we need the
report to display each section as a bookmark to PDF and subreports do
not exhibit this appearance after conversion to PDF. In other words,
create a rectangle in report designer, then export to pdf and you will
notice that the rectangle will appear as a navigation tab on the left
within Acrobat reader. We have reached the limit of 160 inches and we
need to add more tabs to the report.
Regardless of whether the workaround you suggest is valid, the point is
that there should be no limit to the length of a report. That should be
up to the developer.
Albert Yen [MSFT] wrote:
> In SP2, the maximum height or width for any object is 160 inches.
I'm
> interested in the scenario that requires such a long report. Can you
design
> your report as subreports and combine the subreports together in one
large
> report?
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> <jstocker@.gmail.com> wrote in message
> news:1109014748.413769.319290@.f14g2000cwb.googlegroups.com...
> > You might be refering to 883501 but that is a different bug. The
> > details of that bug are related to an error message you get when
you
> > export to Excel. Here is that article:
> > http://support.microsoft.com/kb/883501
> >
> > But the problem we are having would not be fixed by Reporting
Services
> > Service Pack 2. Again, the Report Designer tool does not allow you
to
> > create a report larger than 180 inches, and rectangles are limited
to
> > inches. After reviewing the bugs fixed in Reporting Services SP2,
none
> > of the fixes address this issue.
> >
> > This is a major problem because you cannot create a large report in
> > Reporting Services!!
> >
> >
> >
> > Jerry wrote:
> > > According to the MS webinar, the page problem has been fixed. The
> > > webinar info has been posted to the WIKI:
> > >
> > > http://www.reportingservicesfaq.com/ow.asp?SP2ForRS%3F
> > >
> > >
> > >
> > >
> > > jstocker101 wrote:
> > > > We have reached the maximum length that Report Designer allows
-
> > 180 inches.
> > > > The problem is that we need to make the report longer. Also -
it
> > appears that
> > > > the maximum size for a rectangle is 60 inches - this also is
too
> > small. Does
> > > > anyone know how to report these items to Microsoft Reporting
> > Services
> > > > Development as an enhancement request / defect?
> >|||I have the exact same problem. Did you solve this problem - and how did you solve it
From http://66.102.9.104/search?q=cache:RcuHA1_q0zkJ:www.developmentnow.com/g/115_2005_1_0_0_455194/Maximum-Length-of-Report-Reached-in-Report-Designer-Bug.htm+"reporting+services"+"maximum+height"&hl=da&ct=clnk&cd=7&gl=d
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Maximum height for table

How do I set the maximum vertical size of a table? I would like to set it based on total vertical size in inches or a maximum number of rows returned.

Thanks for any help.

Brad

Click View -> Properties window. The dimensions for a table/matrix can be changed in this window.

|||

Hi Greg,

Do you know how does this height create any difference, what i mean is usually this doesnt restrict the table from expanding or so.

|||So you're saying that you want to cut off the rest of your data if it goes past the height you specify?

|||

Hi Greg -

I don't think I stated my question clearly. What I'm trying to do is limit the number of rows returned in my table. So for example, if the dataset connected to my table contained 30 rows, is it possible to cap the number that are returned to 20? If not, is it possible to set the "canGrow" property to a maximum height?

Thanks.

Brad

|||

I would do this in your SQL query.

SELECT TOP 20 * FROM .....

|||

Yes, but unfortunately I am in a situation where I cannot control the results of the stored procedure. I am only able to use pre-existing SPs and build the report.

Brad

|||

Please try visibility condition of that section, use =iif(rownumber(nothing)>=20,true,false).

Priyank

|||

That's a good thought but unfortunately does not do exactly what I need. Using my example from earlier, that code returns 20 rows of data, and then 10 blank lines. My table is still expanded to the full 30 rows however.

Any other ideas?

Thanks.

Brad

|||

Are you using it in the visibility of the section and not for the indivisual textbox. What i mean to say is select the complete detail section of the table and then in the visibility condition of the section write this condition, It shold supress the complete sectiona dn shold not give you blank rows.

|||

I had selected the textbox and the full table, but not the detail portion of the table.

Putting the code in the detail portion worked like a charm, thank you!