Sep 30, 2008 #1 hceco MIS Joined Mar 18, 2008 Messages 37 Location BR Hi. I have a report from CR8.5 that has data and a graphic. After export to Excel, the xls file has the graphic in blank. How can I export to Excel with graphic? thanks.
Hi. I have a report from CR8.5 that has data and a graphic. After export to Excel, the xls file has the graphic in blank. How can I export to Excel with graphic? thanks.
Sep 30, 2008 #2 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Did you want just a PICTURE of the chart in Excel, disconnected from an data, or a functional chart in Excel linked to the imported data? Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Did you want just a PICTURE of the chart in Excel, disconnected from an data, or a functional chart in Excel linked to the imported data? Skip, Just traded in my old subtlety... for a NUANCE!
Sep 30, 2008 Thread starter #3 hceco MIS Joined Mar 18, 2008 Messages 37 Location BR Just a picture Upvote 0 Downvote
Sep 30, 2008 #4 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US So how did you "export" this graphic and IMPORT into Excel? Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
So how did you "export" this graphic and IMPORT into Excel? Skip, Just traded in my old subtlety... for a NUANCE!
Oct 1, 2008 #5 CR85user Technical User Joined Jan 18, 2005 Messages 522 Location GB The OP simply means when a report contains a picture and the report is subsequently exported to xls. I have seen this previously however have not had a requirement to overcome the blank image. I will have a look into it and post back if I find a workaround. 'J CR8.5 / CRXI - Discovering the impossible Upvote 0 Downvote
The OP simply means when a report contains a picture and the report is subsequently exported to xls. I have seen this previously however have not had a requirement to overcome the blank image. I will have a look into it and post back if I find a workaround. 'J CR8.5 / CRXI - Discovering the impossible
Oct 1, 2008 Thread starter #6 hceco MIS Joined Mar 18, 2008 Messages 37 Location BR skipVought My report consist in: - Report Header = has a Cross tab - Report Footer a = has a chart Problem: when I export the report to excel, the file (xls) doesn't show the chart, only a box in blank. I think now is more clear the scenario. Upvote 0 Downvote
skipVought My report consist in: - Report Header = has a Cross tab - Report Footer a = has a chart Problem: when I export the report to excel, the file (xls) doesn't show the chart, only a box in blank. I think now is more clear the scenario.
Oct 1, 2008 #7 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Seems that EXPORT is somewhat deficient of your requirements. So you must go back and COPY the graphic and PASTE it into Excel. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Seems that EXPORT is somewhat deficient of your requirements. So you must go back and COPY the graphic and PASTE it into Excel. Skip, Just traded in my old subtlety... for a NUANCE!
Oct 1, 2008 #8 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Seems that EXPORT is somewhat deficient of your requirements. So you must go back and COPY the graphic and PASTE it into Excel which is why I asked the question about picture or data. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Seems that EXPORT is somewhat deficient of your requirements. So you must go back and COPY the graphic and PASTE it into Excel which is why I asked the question about picture or data. Skip, Just traded in my old subtlety... for a NUANCE!
Oct 1, 2008 #9 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Presumably, you will be doing this periodically. If it were me, I'd link a chart to the data in Excel and then just update the data. In fact, if it were me, I'd bypass the reporting application all together and get the data straight from the source (where CR is getting it). Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Presumably, you will be doing this periodically. If it were me, I'd link a chart to the data in Excel and then just update the data. In fact, if it were me, I'd bypass the reporting application all together and get the data straight from the source (where CR is getting it). Skip, Just traded in my old subtlety... for a NUANCE!
Oct 1, 2008 Thread starter #10 hceco MIS Joined Mar 18, 2008 Messages 37 Location BR The workaround I found is export to Excel 7.0 instead of Excel 8.0 The chart can be exported and viewed normaly. Thanks, Renato. Upvote 0 Downvote
The workaround I found is export to Excel 7.0 instead of Excel 8.0 The chart can be exported and viewed normaly. Thanks, Renato.