Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Performance (2003)

    I have a query that runs really fast. When I try to run a report off of it - it runs really slow. The little green dashes go fast and then it stops and it says at the bottom that it is formatting page - press ctrl break to stop. Is there anything wrong or am I just impatient.....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Performance (2003)

    Can you preview the report eventually or does it get stuck on "Formatting page ..."?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Performance (2003)

    It gets stuck on formatting page - I press control break to end it.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Performance (2003)

    Perhaps it gets stuck on setting the page breaks. Have you set the Page Break property of any of the report sections to "Before Section" or "Before and After Section", and/or set the Keep Together property of any section to Yes, and/or set the Keep Together property of a field in the Sorting and Grouping window to "Entire Group"? If so, experiment with turning off these properties.

Posting Permissions

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