Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    37

    Question Unanswered: Crosstab queries, date parameters and reports

    I made a report from a crosstab querie which has two parameters for start date and end date. When I run the report it prompts me three times for a start and end date, but the querie itself only prompts me once. Any ideas on how to get the report to prompt just one time?

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Crosstab queries, date parameters and reports

    Does your query return only three records. Looks like the report is prompting you for the parameters as many times as the no of records returned. check your reports events. that could be a start.

    Originally posted by HomersDonut
    I made a report from a crosstab querie which has two parameters for start date and end date. When I run the report it prompts me three times for a start and end date, but the querie itself only prompts me once. Any ideas on how to get the report to prompt just one time?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •