David, I suggest setting the recordsource for the report in code (in the "Open" event of the report). This way you'll be able to work in Design view more efficiently.
Eric > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of David Pearson > Sent: Tuesday, November 08, 2005 6:13 AM > To: [email protected] > Subject: [AccessDevelopers] Report Design Very Slow > > Hello all, > > I am frustrated by this. I have a query that lists all order > lines that have yet to be shipped, this queries numerous > tables link by ODBC to SQL Server 2000. This query runs nice > and quick and all reports based on it do to. > > Now I have built a cross-tab query on the previous query. > This again runs nice and quick but as soon as I make it the > data source for a report it become unworkable, every click in > report design takes over a minute. > > Anyone got any ideas??? > > Regards > > David Pearson > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
