I have an issue where I have a report with 4 tabs. One tab contains a Line Graph showing percentages on the y-axis and current through the previous 24mths dates on the x-axis for two data items. There is a list that also holds the numbers for this chart. Included on this page is a pie chart using a completely separate query to show the comparison between two data items.
When this is rendered in HTML, everything is correct. Percentages show properly, and the corresponding values for the dates work properly. The pie chart is also correct. When I select to download to Excel 2007, the percentages all show as 1% and the corresponding values all show as 1% even though the plotted points look like they are correct. The pie chart splits to 50%/50% even though it should be 96%/4%. I am not sure why it is not rendering to Excel correctly. Is there perhaps an admin setting for Excel that I need to set in the System setting for Report Service? I've had to do that for some other Excel rendering issues. I can't seem to find any information on this topic online though.
Quote from: Magdalina08 on 23 Mar 2021 11:57:53 AM
I have an issue where I have a report with 4 tabs. One tab contains a Line Graph showing percentages on the y-axis and current through the previous 24mths dates on the x-axis for two data items. There is a list that also holds the numbers for this chart. Included on this page is a pie chart using a completely separate query to show the comparison between two data items.
When this is rendered in HTML, everything is correct. Percentages show properly, and the corresponding values for the dates work properly. The pie chart is also correct. When I select to download to Excel 2007, the percentages all show as 1% and the corresponding values all show as 1% even though the plotted points look like they are correct. The pie chart splits to 50%/50% even though it should be 96%/4%. I am not sure why it is not rendering to Excel correctly. Is there perhaps an admin setting for Excel that I need to set in the System setting for Report Service? I've had to do that for some other Excel rendering issues. I can't seem to find any information on this topic online though.
Hi,
Is there anything funky going on in your report, such as embedded javaScript? This would run as intended when rendering the report as HTML but not in other rendering formats. What results do you get if you try rendering as PDF?
Cheers!
MF.
There is nothing embedded. Just a double line graph, list, and pie chart. I do have joins on the queries, but I don't think that should cause a problem. I also have a filter in order to only show current to last 24mths for dates. This shouldn't affect it either and definitely not have any affect on the pie chart as the query is unrelated.
When I opened it in PDF, the data and graphs looked fine. Seems to be an excel only issue.
I was able to get the Line graph to work properly by formatting my percentage with only the scale property, but the Pie chart is still moving to 50/50. Not sure why it changes in Excel.