Prev: Report Builder: Views and Named Query's
Next: Subscription problem: Is there a max e-mail address size?
From: kent.eilers on 13 Jun 2008 09:22
could someone kindly post the syntax that will return the value of the
current header value for a matrix? I want to pull this information
into the row cells to determine background color.

i assume it would be something like column.header.value...??

thanks
From: Bob on 16 Jun 2008 12:33
The textbox which has the column header in it will have a name, which you can
refer to, eg my dynamic column header is in a textbox called source_value, so
I can put this in my BackColor property:

=Iif(Fields!source_column.Value="your_value", "Blue", "Transparent")

HTH
wBob

"kent.eilers(a)res-direct.com" wrote:

> could someone kindly post the syntax that will return the value of the
> current header value for a matrix? I want to pull this information
> into the row cells to determine background color.
>
> i assume it would be something like column.header.value...??
>
> thanks
>
From: kent.eilers on 18 Jun 2008 08:28
On Jun 16, 11:33 am, Bob <B...(a)discussions.microsoft.com> wrote:
> The textbox which has the column header in it will have a name, which you can
> refer to, eg my dynamic column header is in a textbox called source_value, so
> I can put this in my BackColor property:
>
> =Iif(Fields!source_column.Value="your_value", "Blue", "Transparent")
>
> HTH
> wBob
>
> "kent.eil...(a)res-direct.com" wrote:
> > could someone kindly post the syntax that will return the value of the
> > current header value for a matrix?  I want to pull this information
> > into the row cells to determine background color.
>
> > i assume it would be something like column.header.value...??
>
> > thanks

Thanks!
 | 
Pages: 1
Prev: Report Builder: Views and Named Query's
Next: Subscription problem: Is there a max e-mail address size?