I found that the subreport could not link to the main report using a stored proc. I'm guessing it is just like on the SQL side where you can not merge the result sets of 2 different stored procedures. This worked fine when I switched the reports recordsource to a UDF.
I have everything working great except for a couple of my
reports where I have subreports. My main report and my
subreport have the same recordsource which is a stored
procedure that I am passing variables to. I used this same
functionality on my old Front end db in Access 2000 and used
the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.