Setting a cell's background colour using a field's value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jennifer - 29 Sep 2005 09:00 GMT

Hi there

I am wanting to dynamically set the background colour of a textbox by
using a colour value passed from the data.

How would i go about this?

thanks,
Jennifer

Reply to this Message

BALAJI K - 29 Sep 2005 12:30 GMT

Hi Jennifer,

In the Backgroud property of the textbox set this property
= Fields!iColorValue.Value

Thanks
Balaji

>Hi there
>
[quoted text clipped - 5 lines]
>thanks,
>Jennifer

Reply to this Message

Jennifer - 29 Sep 2005 17:49 GMT

Thanks very much - i get this error when trying that:

The background color expression for the textbox 'colour' refers to
the field 'iColorValue'. Report item expressions can only refer to
fields within the current data set scope or, if inside an aggregate,
the specified data set scope.

'colour' is the name of my field being passed in (which contains the
value "red").

Any suggestions?
thanks in advance...

Reply to this Message

alison - 29 Sep 2005 22:58 GMT

Hey Jen,
Try this.
In the textbox properties for background color use the expression =Me.Value

It worked for me with a textbox I simply typed Red in. When I previewed it
came up red.

> Thanks very much - i get this error when trying that:
>
[quoted text clipped - 8 lines]
> Any suggestions?
> thanks in advance...

Reply to this Message

Jennifer - 30 Sep 2005 08:40 GMT

thanks Alison.

this is the error is get when trying that:

The background color expression for the table 'table1' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_table1'.

Perhaps i am being totally stupid here, but please bear with me...

thanks,
Jenn

Reply to this Message

alison - 30 Sep 2005 15:48 GMT

Are you trying to set the color for the whole table? Or a textbox.
Your error message looks like it applies to table1. You should only be able
to use this method for a single textbox, as a table contains many values.

> thanks Alison.
>
[quoted text clipped - 8 lines]
> thanks,
> Jenn

Reply to this Message

BALAJI K - 30 Sep 2005 11:09 GMT

Hi Jennifer,

If the field name is color

then your expression should be like that
= Fields!colour.Value

copy this expression and paste it in Backgroud property of the textbox.
It will work.

Let me know if this doesnt work

Balaji

>Thanks very much - i get this error when trying that:
>
[quoted text clipped - 8 lines]
>Any suggestions?
>thanks in advance...

Reply to this Message

Jennifer - 30 Sep 2005 12:08 GMT

Hi

I followed your directions completely and this is the resulting error:

The background color expression for the table 'table1' contains an
error: [BC30456] 'value' is not a member of
'ReportExprHostImpl.EH_table1'.

Any other ideas?

thank you!

Reply to this Message