OpenReport and Subreports

  • Thread starter Thread starter Blah
  • Start date Start date
B

Blah

Hello,

I'm have a report and a subreport which is linked by an ID. However, I
can't limit the data return on the subreport at the same time as I limit
the data from the main report using the where clause of OpenReport.

So I got something like this right now:

OpenReport "Main",default view,, "CompID = "& ID &" and report!subreport!
report.Date = #" & inDate & "#"

Thanks in advance
 
Provide a form where the user can enter the limiting dates.

In the query that provides the data for the subreport, enter something like
this under the date field:
Between [Forms].[Form1].[txtStart] And [Forms].[Form1].[txtEnd]
The subreport will then read the dates from the form each time it needs
them. If the main report filters on these dates as well, it guarantees
consistency.
 
Hi Blah,

I am just checking on your progress regarding the information that MVP had
sent to you! Have you tried the steps MVP provided to you? I wonder how the
testing is going. If you encounter any difficulty, please do not hesitate
to let us know. Please post here and let us know the status of your issue.


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
Back
Top