compare values within subreport to main report

I was wondering if anyone knew how to take a value from a subreport and
compare it to a value iwthin the main report. We are trying to see if
the value in the subreport is greater than the value returned in the
main report. We want to make the value test red if it is greater than.
I know how to compare these values if they were in the same report, but
when it comes to subreports I am lost. Any ideas? Thanks in advance.

One way to do this would be to pass hidden parameters to the subreport.

Here is one example of parameters passed.

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/

|||

I figured out the solution. You have to send the value you want as a parameter over to the subreport.

Right click on the subreport go to properties > Parameters tab and pass in the field you want off the main report
Then go to your subreport and add the extra parameter under Report Parameters
Now you have access to the value from the SubReport in Main Report

Thanks for your help!