Passing Parameters to a subreport using VB

[jonnymadill]

Hi,

I'm trying to pass parameters into a subreport of an RPT file. The problem is, these values aren't known until the 'housing' RPT file has been run (it executes a stored procedure on an ORACLE db). Once the results from the housing RPT are obtained it then passes some of these values as parameters to a subreport.

I've been told I need to loop through each section of the housing RPT and determine any subreports (thanks surfinggecko), but I was wondering is it possible to grab the values of fields from the RPT file in the VB code?

Could I identify the fields and then pass them into the subreport using the 'subreport' object in VB?

Thanks again for any help.