I created two reports which my manager wanted to see together. So I made the one report a sub-report of the other with no link. The one report is a summary of figures by month and the other is a summary of the same figures by year. When I run the main report, I will be prompted for the same user input several times. I was able to get around this by creating a form and calling on the field for the input. The problem here is the length of time that it takes to run. Why does it prompt you several times to run the report just because I have a sub-report within? It will also run the queries again if I want to print the report. Again I can get around this by automatically printing the report but I am trying to get a handle on why this happens this way and if there is a way to fix this problem. Thanks in advance for any help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
problem using sub-reports
- Thread starter hermannd
- Start date
Similar threads
- Locked
- Question
- Locked
- Question