Showing posts with label visible. Show all posts
Showing posts with label visible. Show all posts

Monday, March 12, 2012

Programmatically set position of report items

Hi All. I have a report with various items (lines, textboxes) that may or may not be visible, depending upon the values of other report items.

In one list, there is a horizontal line of textboxes and lines. If a line in the middle of it all is set to hidden=true, then all the controls to the right of it are shifted to the left. If it is set to hidden=false then they are shifted back to the right.

Is there a way to fix the position of controls (something like ReportItems!txtTextbox.left=0.444 etc.)? According to BOL, the only property in the ReportItems collection is Value.

Any help is appreciated. D. LewisTry grouping items inside of a container. A rectangle with no visible border can be very useful to keep other items from shifting on the page.

Friday, March 9, 2012

Programmatically hiding chart on the report page.

I need to show or hide a chart on my my report based on the result of the
dataset.
I tied to assign an expression to Visible.Hidden property of the chart like
that "=First(Fields.Visible.value)" WHERE I assigned 0 or 1 to the 'Visible'
column of my dataset. It did not work. Is there a way to do that?
Thank you,The result of the Visibility.Hidden expression has to be a boolean value and
not an integer value.
Try this instead:
=(0 = First(Fields.Visible.value))
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon Gold" <SimonGold@.discussions.microsoft.com> wrote in message
news:A7C5B8B9-5D26-43EE-B82B-0EAF7418AA7F@.microsoft.com...
>I need to show or hide a chart on my my report based on the result of the
> dataset.
> I tied to assign an expression to Visible.Hidden property of the chart
> like
> that "=First(Fields.Visible.value)" WHERE I assigned 0 or 1 to the
> 'Visible'
> column of my dataset. It did not work. Is there a way to do that?
> Thank you,
>