Submit your Suggestions for Spectrum

Fix excel export (export data only) to have column headers align correctly

Nearly all reports that are exported to excel (with the option export data only), column headers to do not line up with the appropriate column that contains the data. It requires several modifications. Reports need to be pulled and supplied to our parent company and also during our financial audit and the export data only function is needed to provide data in an organized, filterable fashion

  • Guest
  • Mar 13 2025
  • Planned
Company LVR, Inc
I need it... Yesterday...Come on already
  • Attach files
  • TJ Miller commented
    02 Oct 20:54

    As I have used this ability, I have found that I believe the problem is with Crystal and how it creates columns for the report header and page headers. and then tries to do the data columns. Column alignment in the report wreaks havoc on the logic of Crystal trying to figure out what goes where.


    For reports that you use frequently, it is not too much effort to create a sheet that has a macro that will perform the manipulation of the columns. It is not perfect, but seems easier than trying to recreate the canned reports in a different tool.

  • Jennifer Carver commented
    02 Oct 16:41

    So much time is wasted editing these reports into something usable.


  • Dean Nelson commented
    27 Jun 21:45

    Absolutely. I'm not sure if this is a Spectrum problem or a Crystal Reports problem, but it would be great if it could be fixed. Sometimes the header row is only off by one column so it's an easy cut and paste to move them, but other times the headers are all over the place.

  • Lorraine Erickson commented
    16 Apr 16:06

    I agree. This is a much needed improvement.

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

1515 SE Water Avenue, Suite 300, Portland, OR 97214 |  800.333.3197  | Contact Us | Terms of Use | Privacy | Support Policies

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.