This is the Blackbaud Community Best Practices blog.

How To Excel At Exporting In Excel

Community Member, Marie Stark, shows you how to master the art of exporting in excel. Give this blog a "LIKE" to vote for it to win the bbcon blog contest!
Have you ever spent hours formatting a Crystal report, only to be told, “Great, but I need it in Excel”?

Exporting a custom report to Excel often results in mismatched headers columns, and totals, as well as merged cells that are impossible to work with.

Here is how to create a “clean export” of a Crystal report to Excel. This report is not designed to for viewing on the screen, but it will create a perfect Excel spreadsheet.

 
  1. Instead of using a text box, create formulas for each field heading. Each formula will contain the desired column heading, such as “Last Name”
  2. Add all your header formulas into the page header section of the report.
  3. Add your detail fields in the detail section and line them up under the correct header.
  4. Make all fields the same size. In each section of the report, you can right click, then “Select All Section Objects”. Then click on one of the fields, right click, select “Size”, then “Same Size”.
  5. Put all the fields next to each other. Do not leave any space between the fields.
  6. Create your custom report.
  7. After your run your report, export it. Select the format Microsoft Excel (97-2003) Data-Only.  On the next screen, (Format Options), select Tabular Format.
Posted by Crystal Bruce on Sep 3, 2018 8:22 PM America/New_York

Leave a Comment

Log in to post a comment.

Good luck, Marie Stark‍!
  • Posted Tue 04 Sep 2018 09:32 AM EDT
Great and useful advice Marie!!
Thank you!
Maryann
  • Posted Tue 04 Sep 2018 10:51 AM EDT
Great article!
  • Posted Tue 04 Sep 2018 12:14 PM EDT
Excellent.  Thanks Marie
  • Posted Tue 04 Sep 2018 02:28 PM EDT
Good Job Marie.
  • Posted Tue 04 Sep 2018 02:36 PM EDT
Marie, thank you for your detailed process! You rock!
  • Posted Tue 04 Sep 2018 02:37 PM EDT
Thank you for these helpful instructions!
  • Posted Tue 04 Sep 2018 03:33 PM EDT
Great!
  • Posted Wed 05 Sep 2018 03:46 PM EDT
This is Great! Thanks Marie, its very useful.
  • Posted Fri 07 Sep 2018 09:29 AM EDT
Thanks for the post. We are struggling a LOT with reports we can manipulate. It is incredibly rare that I need just an out of box report...or that the recipient doesn't want to manipulate the data for their own purposes.
  • Posted Thu 13 Sep 2018 09:28 PM EDT
Very helpful! Mahalo!
  • Posted Thu 15 Nov 2018 02:24 PM EST