Hi Johnny, While auto exporting report to excel by saving it in .xls u have 2 make sure all the controls in report are aligned, if you have to insert some gap in report then add a blank control as saving report to excel will take those controls and format it in row and column wise any blank space with out control skip that and it will not export it in desired format.
cheerzzzzzzz:) -- Regards Deepankar http://axgeek.blogspot.com/ 2008/10/13 johnny tang <[EMAIL PROTECTED]> > Dear all, > There was the problem about report to excel in AX, i selected the export > type is HTML, and specify a target file with an xls extention, but when i > opened the file, the formatting was wrong. Do you have any idea on how to > export the report to excel in AX? > Any suggestion would be appreciated. > Thanks. > > > Best Regards, > Johnny Tang > > ------------------------------ > 雅虎邮箱,您的终生邮箱! <http://cn.mail.yahoo.com/> > > >