hello everybody out there. generating report is slow especially when the records are large and there are many tables to which we need to query. i want to know is there anyway we can make these queries faster or optimize the code in anyway so that i can generate my reports on a fly. i am using vb6 with mssql7 and crystalreports 8.5.