Dynamic layout & whitespace

Hi,

I have a report that, among other things, contains 3 tables laid out side-by-side horizontally. The first table is conditionally visible and when it is hidden the report contains whitespace instead of the table. The problem is that this causes an unappealing visual look because the other 2 tables look shifted too much to the right.

What is the recommended way for dealing with situations like this? There doesn't seem to be support for specifying the location (i.e. top, left) of elements based on expressions. Am I "stuck" with having to create multiple flavors of the report?

Thanks,

Vitaly

Any help is appreciated! :)

Thanks,

Vitaly

|||

Can someone from the SSRS team please shed some light on this?

Thanks

Dynamic images at runtime

I have a report that comes with one main image and 15 other images that needs to be visible as needed at fixed position to the main image. Adding all the images is easy but managing the visibility is not working. What is the best way to do it? I am looking for sample but have come up empty.

When using a url, you can leverage the expression property to have the dynamic image location.

Or are you meaning a dynamic number of images? That would be tough - probably need to build the rdl yourself w/ .net

|||Thanks for replying I don't have the option to use url, the application will an exe, factory safety related one main image and 15 smaller images added as needed in fixed position relative to the original image.|||it's still hard to figure out exactly what you want to do here. can you give more details in order to better help people answer your question?|||What I am trying to do turns out to be complicated but I have found two samples from the Reporting services news group posted by Microsoft employee Bruce Johnson [MSFT] of how to create it. I have an image and I need to add 15 smaller images to that image at runtime. The two samples I found are Simulated Dynamic Visibility.rdl and ConditionallyDisplayAnImage.RDL. These are doing what I have in mind I could not load the rdl into VS Team suites so I have to create mine based on the content of these two files. I had assumed this should be simple task but it comes with tricks which I just found today. Thanks again for your help.|||

This problem is solved the main part was a cursor yea but my code was due by the close of business, the numeric values representing the images were passed by a cursor in a stored proc which is added to the expression. It works in my box, I will know by Monday if it blows. If you know a better solution please let me know.

Dynamic columns

I am setting visible property for column based on user input. This works
fine. However, I need to be able to change the width to 0 for the column as
well so the report will not print blank pages. A matrix is NOT an option.
Report is too complicated. Unfortunately there is no expression option for
the column width. Is there any way of setting this to 0 or autosize' Also
need to adjust the body width dynamically.On May 29, 3:32 pm, Sherminator
<Shermina...@.discussions.microsoft.com> wrote:
> I am setting visible property for column based on user input. This works
> fine. However, I need to be able to change the width to 0 for the column as
> well so the report will not print blank pages. A matrix is NOT an option.
> Report is too complicated. Unfortunately there is no expression option for
> the column width. Is there any way of setting this to 0 or autosize' Also
> need to adjust the body width dynamically.
Unfortunately, there are not very many options available if a matrix
control is not an option. You could try putting the table control(s)
in a rectangle. Also, you could try to rearrange the columns according
to the ones most likely to be invisible. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It's not a matter of the columns not showing, so the order doesn't matter.
They do hide, however blank pages print because the body is over 18 inches
when all columns are populated. Unfortunately, the tablecolumn element is not
available thru the ReportItems collections. If it were I could reset the
width of the empty columns to 0 using a function and adjust the body width if
it too were available thru the ReportItems collection, however, those
elements are not available to my knowledge.
"EMartinez" wrote:
> On May 29, 3:32 pm, Sherminator
> <Shermina...@.discussions.microsoft.com> wrote:
> > I am setting visible property for column based on user input. This works
> > fine. However, I need to be able to change the width to 0 for the column as
> > well so the report will not print blank pages. A matrix is NOT an option.
> > Report is too complicated. Unfortunately there is no expression option for
> > the column width. Is there any way of setting this to 0 or autosize' Also
> > need to adjust the body width dynamically.
>
> Unfortunately, there are not very many options available if a matrix
> control is not an option. You could try putting the table control(s)
> in a rectangle. Also, you could try to rearrange the columns according
> to the ones most likely to be invisible. Sorry that I could not be of
> greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>