Hidden table details row and whitespace issue.

I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer
From http://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comOn Jul 24, 12:56 am, sash<she...@.hotmail.com> wrote:
> I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer.
> Fromhttp://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporti...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
There are not very many options available in this scenario. If you
haven't already selected decrease to accommodate contents in the
properties of the table control, I would suggest doing that first. The
most effective way to handle this is to manage it in the stored
procedure/query that sources the report. That way you can pass the
criteria back to the stored procedure and it can decide rather to
return a particular row in the returned dataset. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Hidden items, whitespace

Hi,

i have an issue with hidden items causing whitespace on the output of a report. The last page of the report contains a table, which may be hidden if certain conditions are met. However the final page is still rendered even though it contains nothing. The page does have a header and footer, but the page is still rendered if i also conditionally hide all the elements in the header or footer.

Ideally i would like the last page to not be rendered if that table is hidden. Is there any way to achieve this?

Thanks,

sluggy

Do you have a pagebreak before the table? If you hide the contents of the table, you would still get the last (blank) page. But if you hide the table (by setting table visibility property), you shouldn't get the page.