Hi Raj,
You may consider SQL Reporting Services which is bundle together with SQL 2000 or 2005. Hence is free and you can create and generate as many report as you like. Best Regards, GAN ________________________________ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of tatiraj Sent: Thursday, May 29, 2008 12:12 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] executing reports faster with sql database Dear fnds, I want to know wat is the best way to generate reports so that they execute faster with sql as the database. I am using the query in the report and adding date range(which is entered by the user in the dialog) in the fetch method. how to select tables so that the select queries dont take time to execute. Regards Raj. [This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person]