Skip to Content
0

Edit Exported Excel Format

Aug 30, 2017 at 04:29 PM

27

avatar image
Former Member

Hello experts,

I'm new in Crystal Reports and need helps. I have Sage 300 ERP and using Crystal Report (Crystal Report 2011) to print and export report to excel. Now the question is how can i edit the excel template for exported data? My purpose is to create a custom exported excel which mean the excel is not 100% same as the print one.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Aug 30, 2017 at 04:32 PM
0

Simply adjust the report in CR Designer or change the selected export options so you get the output you want.

Try some things to see what the results are and then adjust accordingly.

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Sep 01, 2017 at 08:09 AM
0

If you mean you want two different layouts for PDF and Excel then you will need to use a parameter so that user can define Output type, ie PDF or Excel.

You then need to have two layouts in designer with conditional suppression on each section depending on the Parameter setting.

It is NOT possible to preview report in PDF and then export to excel in a different layout. You need to run as either PDF or Excel.

Ian

Share
10 |10000 characters needed characters left characters exceeded