Pass Parameters to subreport vb ocx
Posted on 2006-04-13
I have a report with a sub report in it. I have a parameter field in each that handles a date range in that sub report. How do I pass said date range from VB to that sub report? I would guess
q = Format(dtFrom.Value, "yyyy-mm-dd") & " 00:00:00.000"
r = Format(dtFrom.Value, "yyyy-mm-dd") & " 00:00:00.000"
strParm = "date(mgmtprod.rpt); " & q & "," & r & "; TRUE"
CR.ParameterFields(1) = strParm 'set the parm
CR.Action = 1
Where dtFrom and dtTo are drop down boxes with dates in them. and date is the paramter name and mgmtprod.rpt is the sub report. When I run this I get invaild parameter name.