You might try putting the crosstab query data into a table for the short term and use the new table for report design. You can always change the datasource on the report when you are done. TJ
--- David Pearson <[EMAIL PROTECTED]> wrote: > 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 > > > > > ============================================================= > The information in this Internet email is confidential and intended for the > sole use of the addressee(s). Copying, disclosure or re-use, in any way, of > the information contained in this email by anyone other than the addresse(s) > is unauthorised. We accept no legal responsibility for the content of this > message. Any opinions or views presented are solely the responsibility of > the author and do not necessarily represent those of Siddall and Hilton Ltd. > and any of their subsidiary companies. If you have read this email in error, > please return it to the sender and remove from your system. > Siddall and Hilton Ltd. and any of their subsidiary companies may monitor the > content of emails sent and received via its network for the purposes of > ensuring its compliance with its policies and procedures. > ============================================================= > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
