Actually I was able to adjust all graphs and pages and make them delivered in pdf with my personal setting. The only issue I am still having is horizontal bar graph. For some reason this graph gets corrupted while being transferred into PDF. Report Builder reverses the below axis into negative numbers (in my case %) instead of positive and moves the vertical axis to the right instead of have it on the left (default setting).
Also I think the problem with delivering my reports in Excel only, relates more to file sharing issue and NOT Excel settings. Recently Adobe merged two our accounts dow jones and factiva. All reports I had created under factiva account, now can be ran under dow jones account with all previously built segments. The problem is you cannot see the segments when you run reports under dow jones account. When I try scheduling these reports to be delivered to me automatically in PDF, they all are being sent to me in Excel with the error message error462240_01.xml. Is there a chance to fix this problem?
- http://schemas.openxmlformats.org/spreadsheetml/2006/main">
error462240_01.xml
Errors were detected in file 'C:\Documents and Settings\zhosann\Local Settings\Temporary Internet Files\Content.Outlook\9YZS6PZB\TRAFFIC_TRENDS_PMNews_BND_TEST.xlsx'-
Removed Records: Shared formula from /xl/worksheets/sheet2.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)