Issue When Exporting Crystal Report to Excel

[jopav613]

I'm using CR 2016 for a while now and have never come across this issue. In one of my reports, when exporting to excel (both with "data only" and regular excel export options) I lose a significant number of rows which contain data. I'm fairly sure all my rows and columns are aligned and sized properly as always. This is very frustrating and appreciate someone's help with this.

Thanks!

[DellSC]

You don't necessarily have to delete the formulas, instead you can comment them out using "//" at the start of each line of the formula and then putting a constant (empty string, the number 0, true/false, etc.) after the comment so that the formula still provides a result. From there, follow Janos' suggestion of working with half of the formulas and then half again until you find the formula that's causing a problem.

Also, are you using any subreports? Exporting subreports to Excel presents a number of challenges and, even if everything is lined up correctly, may not show the same results as viewing the report.

-Dell

[jopav613]

Thanks Dell. I'll test it out. Thanks!