View Full Version : Graphs in reports


lamaar
09-16-2001, 07:13 AM
I have a report which contains only a graph. This report runs of a Query. The Query prompts the user for criteria - ie name and week number. When the report runs the Query is run twice for some reason, thus prompting the user twice. Is there any reason for this? Can anyone suggest a better way of doing this?

Thanks

Carol
09-16-2001, 08:03 AM
Is this a single report or a main report with a sub-report. If it is the latter, remove the parameter prompt from the sub-report.

Also check your query, make sure that you don't have the parameter prompt in both your criteria cell of the field and your overall query.