Passing data between the main report and the subreport

rbuser

Hi,

I can filter on dates in my main report, However, I want the subreport to
also filter on these dates when the user fills them in. How do I pass these
parameters between the Main report to the Subreport?
I cannot join the tables by date as that doesnt work.

Regards

Simon

nardmoseley

- if you are using the Data workspace (DADE) to link querys, then RB will
generate special linking SQL for the detail query that propogates the search
criteria from the master. To view the linking SQL, position the mouse over
the dataview and press ctrl+left mouse.

- if the query's are not linked, then you can use the TdaSQLBuilder class at
run-time to modify the detail query. TdaSQLBuilder was introduced in RB 9
along with two events, Report.InitializeParameters and
Report.BeforeOpenDataPipelines. These events occur prior to any dialogs
being shown and prior to the datapipelines being opened.

Here is an example

www.digital-metaphors.com/tips/ApplyAutoSearchValueTo2ndQuery.zip


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com