Trouble with subreport linking - subreport not reading criteria

J

JAA

I have two top 10 lists which need to be in one report. I created a report
based on one top 10 list, and included date criteria in the query. I created
a subreport in a similar design without the date criteria (but included the
date field in the query.)

I used the wizard to insert the subreport and linked the child and master
fields (date), however the query is not running correctly. The only way I
can get it to work is to enter the criteria in both queries which ends up
being requested 3 times when I run the report..

any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report asks for Parameter and Won't Display Subreport 7
Having a problem with a subreport 13
report with 'standard' subreport 4
Subreport in Report Obtains Wrong Date With Query Criteria 10
Linking subreport to report 4
report using a subreport based on a crosstab query 5
Blank records in SubReport to Total in Main Report 2
Subreport doesn't work with a query 0

Top