Link to home
Start Free TrialLog in
Avatar of vbnetcoder
vbnetcoder

asked on

datasets connect to text boxes

How would i connect i dataset to a text box

The dataset is like this

Blue1  hexvalue
Blue2  hexvalue

etc.

I want to select which color for the specific text box
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

I'm not sure if I fully understand what you're asking.  I understand that you have a dataset which contains colors and you somehow want to use those colors in combination with a textbox.  Is it your aim to color the textbox using a color from the dataset?  How is the "color dataset" linked to your regular dataset?

I'll try to clarify using an example.  Let's say your report is displaying a product list and each product category has its own color.  In that case I would combine the "color dataset" query with the regular dataset's query.  This will make the field containing the color available for use within the tablix and you could use a simple expression to set the textbox color.  This expression would go into the BackgroundColor property of the textbox:

=Fields!TheHexValue.Value

This assumes that TheHexValue contains "hexvalue" which you mentioned in your question.
Avatar of vbnetcoder
vbnetcoder

ASKER

In this case my color dataset is my complete dataset.


It is my aim to color the textbox using a color from my textbox.  So, in the data example i gave i might select Blue1 for one textbox and Blue2 for another ...and so on.  I want to be able to  select the colors.
So, imagine a 2 textboxes on a report. I want to attach to select blue1 for the first one and blue 2 for the second.  How?
ASKER CERTIFIED SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
TY