where have you written the validations to populate your temp table? you could create a class in which the validation and population of data can be done. Make sure that the class is run on the server (set the properties). Finally when the data is populated you could call the report from the class.
--- abdulabsi <[EMAIL PROTECTED]> wrote: --------------------------------- HI colleages, I have one design question.One of the reports i have made is based on two huge tables.Depending on the date interval,the reprot will fetch the data either from the old table ,or the new table or from both if the date interval mixes between the two tables. To treat the last case(MIX)I did create a temp table to be filled at run time from both base tables.and the report will read from the that temp table.Unfortunatily thespeed of viewing the reprot is unsatisfactory in cae of a mixed date range. I would be be Very thankful if you can propse any faster way that creating a temp table for processing the last case.. Regards, Absi.. Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT document.write(''); --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __________________________________ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 ------------------------ Yahoo! Groups Sponsor --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> 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/