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 fields rendering on server only!

I have a report with a matrix in which I conditionally hide one of the data
columns. This is working properly in preview on my development studio but
when I deploy to the report server it is showing these hidden data columns
when it is not supposed to - if I export the rendered report from the server
... it exports to pdf and excel with the data columns properly hidden - so
how can I fix this ... I cant understand what is happening. Please help as
release date is approaching. Thank youUpdate on this - I put the same conditional expressions on the border
property of the columns I want hidden and also the background color of the
column that gets conditionally colored - this seems to work although it
doesnt explain why it worked w/out that in dev studio AND why it exported
correctly - the only problem being on the server in html format. Still would
like to know why because if I had known that then I could have saved a lot of
time. Thanks
"MJT" wrote:
> I have a report with a matrix in which I conditionally hide one of the data
> columns. This is working properly in preview on my development studio but
> when I deploy to the report server it is showing these hidden data columns
> when it is not supposed to - if I export the rendered report from the server
> ... it exports to pdf and excel with the data columns properly hidden - so
> how can I fix this ... I cant understand what is happening. Please help as
> release date is approaching. Thank you