Hi there

I am running a crosstab query which prompts me for a parameter entry
how can i run the query from a report and get the results to a report dynamicaly

thanks

You don't need to run the query separately. The report will run the query all by itself. Sometimes, reports need to run a query more than once. If this is what is happening, it will prompt you each time it needs to run the query. To resolve this issue, the only solution is to use a form to gather the parameters rather than prompting for them. Change the query to reference the form fields instead of prompting. Don't forget to change the parameter also.