SAP Knowledge Base Article - Public

2775495 - How to save the default export options for a report in Crystal Reports?

Symptom

  • How to set the default export options for a report?
  • How to retain the options selected for the exporting format?
  • How to save the report default options for a specific exporting format in Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016 

Reproducing the Issue

  1. Open a report in Crystal Reports.
  2. Under the menu "File - Export", select a specific exporting format.
  3. Depending of the exporting format, it displays specific export options. 
          
    For example: If a report is exported to the format: "Microsoft Excel (97 - 2003 ) Data-Only", it will display the following exporting options:
      
    Export_Options_04.png     
        
           
    How to save these options for the report, so that the next time the report is exported to the same format, those options are retained?

Resolution

  • To save the export options for a report in Crystal Reports, follow the steps below:
        
    1. Open the report in Crystal Reports.
            
    2. Under the menu "File", select "Export - Report Export Options..."   
          
    3. In the "Set Default Export options" window, select the desired exporting options, and click "OK"
         
      For example: select "Export -   Microsoft Excel (97 - 2003)", and click "OK"

      Export_Options_05.png
       
            
    4. In  the "Export Options" window, select the desired format options for the report, and click "OK"
       
       Export_Options_06.png
       
           
    5. Save the report.
            
           
      Now, when exporting the report to the format you selected, it will use the exporting format options you selected as the default.    

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016