compare values within subreport to main report

• shaw-275827

  SSC Enthusiast

  Points: 172

  More actions

  October 10, 2006 at 8:42 am

  #170665

  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.

• shaw-275827

  SSC Enthusiast

  Points: 172

  More actions

  October 12, 2006 at 12:14 pm

  #665580

  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