Hello Friends
please help me with this standard report where in when i open the report file the data labels( this is from hidden values in the file) goes away in its place just message showing as "cell range" when i run the same standard report on my database is also the same problem it doesn't show the data labels which are hidden in the file.
Please help me to fix this issue.
Enclosed standard report , standards report image with correct data labels and report image what i get with loosing data labels.
Warm regards
Ravi - Hong Kong
Date
Votes
2 comments
-
Jet Reports Historic Posts I am using Excel 2010 , if I try with excel 2013 its showing the proper labels , may be 2010 doesn't take cell range
Thanks -
Jet Reports Historic Posts I am also using Excel 2010, and don't currently have access to a 2013 version to test on.
but I find it interesting that your data labels are pointing to column P (top 10%, 11-25%, and so on) instead of to column U.
Using 2010, if I manually change the labels, I still have the CELLRANGE error, but if I remove the data labels and update the reference to column U, then I can get them to appear as expected.
Oh - and one more thing, I also noticed that the labels are looking for a "value", I changed that to "Category Name"
If this were my report, I'd try updating the label references, and see if the report will run correctly after that.
Please sign in to leave a comment.