Is there any Real Crystal Report Guru ???

[kfshafi]

Hi Guru,

Could you help me to fix our below issue, thanks,

I am using Crystal Report Version 10 and after designing the report with the summary formula in Crystal Report Software and when I export the report to excel, the summary formula is not exporting to the excel sheet and only data image of the summary total is exported.

Our company requirement is that, the summary formual must be exported to excel sheet for further analysis.

Could you please help me to fix the issue?

Thanks you Guru & Best Regards.

[jawadhashmi]

Dear,

I have no idea how to do this. Might be there is some one to help you.

I think Crystal only exports the way the report looks not the logic being used in the Cryatsl.

Its better that you should create a template in Excel and then feed it using your application instead of exporting the Crystal Report to Excel.

Excel automation or filling the excel from any programming language would solve your problem.

If you find the solution to export the Cryatsl with formula then please reply to the post for others knowledge.

[jggtz]

One way could be (not practical) inserting a text in CR with the excel's formula syntax (example: =SUM(B1:B7) ) and once exported to excel it will give the result
As I said, it's not very practical because almost all the times we don't know in wich cells' number will the data be exported

[kfshafi]

Dear,

I have no idea how to do this. Might be there is some one to help you.

I think Crystal only exports the way the report looks not the logic being used in the Cryatsl.

Its better that you should create a template in Excel and then feed it using your application instead of exporting the Crystal Report to Excel.

Excel automation or filling the excel from any programming language would solve your problem.

If you find the solution to export the Cryatsl with formula then please reply to the post for others knowledge.



thank you jawadhashmi,
This solution is available in CR Version 8.5.

Could you breif the below in easy word again
"Its better that you should create a template in Excel and then feed it using your application instead of exporting the Crystal Report to Excel."

Best Regards

[jawadhashmi]

Great,

This is simple. just google with Excel Automation and you can fins a step by step guide for it any how.

Microsoft supports Excel Automation in its programming languages and also you can fidn the third party libraries to create excel files and to export then as well. But in this case you want the Excel to work with your formulas so you have to fetch the data in your application and then write it to the excel at their appropriate cells and I think all your formulas will apply there.

Also there would be a way to create a Template in Excel and put the data in the required cells after getting the data in cells the other cells having formulas will work and show the results.

Excel can be connected as ODBC source as well.

It depends on your requirement upto which level you want the automation.

Wish you best of luck.