Advanced Conditional Styles

[msawyer]

Hello!

I have a report where Page1 contains data from Query1 and Page2 contains data from Query2.  Is it possible to set up a conditional style to see if the value of a field from Page1/Query1 shows up in Page2/Query2?

For example, Page1 has a field titled Key with value of 12345.  Can I set a conditional style to highlight that cell if the value 12345 shows up in a specific field from Page2?

[katdbc]

I think you can do that  by filtering the page 2 query by the page 1 query .

Example : create a query with just a key in page two. Then add a filter for the key   like [key] in (query1frompage1.key)

So now you would have all the keys from the previous page.

Then you can use this data item in the conditional style.

Let me know if this works.