I have a report which shows proper values when i run in the html format. but when i run the report in excel 2002 everything looks good except the summaries for few of the columns for which it appears as zero.The summaries are percentages and when i click the 0 in the excel, i see the actual value in the formula bar.eg: if its -14% in html, then the value in the formula bar will be .14
so in the data format: I gave the % symbol with number of decimal places: 2
I have attached the snap shot with both html and excel.
how should the data format should be.have any one faced this problem
Any help will greatly be appreciated.
Thank you
Just remove the data format and run the report in excel and see how it appears?
Sometime put a 2 at the solve order would help also...