• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

Expression for comparing two fields from two different tables - ReportViewer & Visual Studio 2005

Hi,
I need to compare two fields from two different tables but on the same dataset. I need to make sure that if these two fields are equal on both tables then their background color will be changed.

I don't know how to build an expression for this.

Can someone give me an example for such expression?

Any help will be highly appreciated!
Thank you all!
0
nahumba
Asked:
nahumba
1 Solution
 
mankowitzCommented:
dim ds as dataset
dim x,y as integer

for x=0 to ds.tables("Table1").rows.count-1
for y=0 to ds.tables("Table2").rows.count-1

if ds.tables("Table1").rows(x)("Field1")=ds.tables("Table2").rows(y)("Field2") then
 ' .... change colors .....
endif

next y
next x
0
 
nahumbaAuthor Commented:
Thx!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now