Comparing fields from multiple datasets

I have one report with two dataset (one from a table and one from a Cube).
Within my report are two tables, one uses the â'Tableâ' dataset and one uses
the â'Cubeâ' dataset. The two dataset are similar (i.e. they return similar
data/fields).
I would like to compare some of the fields from the first dataset with some
of the fields from the second dataset and then use conditional formatting to
turn the text fields red if the two fields do not match.
I know how to write a conditional formatting expression for a cell within a
table but I do not know how to compare a value from one dataset with a value
from another dataset. Note: I do not want to compare aggregates; I want the
comparisons to be at the detail row level. Is it even possible? If so, how
is it done?
Would one possibility be to compare the values/contents of textboxes at the
textbox level? If so, how is that done?
Any info on this topic would be greatâ?¦ Thanks=IIF(ReportItems!txtTextBox1.Value = ReportItems!txtTextBox2.Value,
"BLACK", "RED")
Matt A|||That's a nice idea but it won't work. I'm trying to compare values from two
different datasets that reside in two different tables. I tried your code
(plugging in my textbox names) and it errors out.
Error 2 [rsReportItemReference] The Color expression for the textbox
â'BalanceAmtâ' refers to the report item â'CompositBalanceâ'. Report item
expressions can only refer to other report items within the same grouping
scope or a containing grouping scope.
I welcome any more suggestions you may have though.
Thanks,
Bill
"reportdude" wrote:
> =IIF(ReportItems!txtTextBox1.Value = ReportItems!txtTextBox2.Value,
> "BLACK", "RED")
> Matt A
>|||Try placing each dataset in the same control such as a listbox to
encompass scope-