Subreport record selection

[Ladyhawk]

How do I make the record selection formula to be the same as the main report selection formula?

Ladyhawk.
** ASP/VB/Java Programmer **

 

[synapsevampire]

Copy and Paste?

This depends on how you're setting the record selection formula, if it's a canned record selection formula built into the report, then just copy and paste it, if it's dynamic, you'll need to set them both through code.

If you're using parameters, then you'll need to set those in each case too, or link the sub to the main on the parms.

-k

 

[Ladyhawk]

I am setting it through asp code...

Set session("oRpt&quot = session("oApp&quot.OpenReport(path & ReportName, 1)

if Request.QueryString(&quot;Selection&quot <> &quot;&quot; then
if Session(&quot;oRpt&quot.RecordSelectionFormula <> &quot;&quot; then
Session(&quot;oRpt&quot.RecordSelectionFormula = Session(&quot;oRpt&quot.RecordSelectionFormula _
& &quot; AND (&quot; & Request.QueryString(&quot;Selection&quot & &quot&quot;
else
Session(&quot;oRpt&quot.RecordSelectionFormula = Request.QueryString(&quot;Selection&quot
end if
end if


but I don't know how to access the subreport in the code.

Ladyhawk.
** ASP/VB/Java Programmer **

 

[Ladyhawk]

Never mind... figured it out.

Ladyhawk.
** ASP/VB/Java Programmer **