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! 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/
