cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in Exporting crystal report 2011 Format into MS Excel

Former Member
0 Kudos

Hi Experts,

I am having trouble exporting exact format from crystal report 2011 to MS Excel.The Numbers and text is in correct format but borders are missing for totals at group level.

Below Image is the crystal Report format

Below image is the MS Excel Format we are not able to see the borders.

its urgent requirement. Any help really appreciate.

Thanks in Advance

Sowjanyak.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Sowjanya,


As a workaround, you can enable the Top and Bottom borders for the fields you've highlighted.


Line and boxes are not exported to Excel as Raghav suggested however, you can insert a Text Object, reduce its height to a minimum and enable the top or bottom border to create a make-shift line that'll work when exported to excel.


-Abhilash

Former Member
0 Kudos

I agree with Abhilash

This is also what I did in my P&L design so that my report will look really good.

Former Member
0 Kudos

Hi All,

Thanks for your valuable suggestions...

its working right now.


Thanks,

Sowjanyak.

Answers (1)

Answers (1)

raghavendra_hullur
Active Contributor
0 Kudos

Hi,

Lines and Boxes will not be exported into excel format in Crystal Reports.

Please check  for more info:

There is an idea created in idea place (Details are available in above link) for adding the same.

Thanks,

Raghavendra