A few tricks working with Crystal Report Designer

  • Holding CTRL key, you can select multiple objects and copy/move then as a whole group.  This is very useful when you have to make more space to add more columns, or copy columns from another report.
  • Sometimes after the data is exported to Excel, some (newly added) columns will mysteriously appear at the end of the Excel file, instead of in their intended location in design view. To fix it,  select these column headers, use UP arrow key to move them out the page header, then move back so that there is 0 top margin.
  • When export to Excel file in data only format, always uncheck “Simplify page headers”, otherwise some column headers will disappear.
This entry was posted in Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s