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
| Company | LVR, Inc |
| I need it... | Yesterday...Come on already |
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.
© 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.
I have edited the crystal report to have the correct column headers now. There is some initial time investment but it save times moving forward
also the Excel comes in old format with .xls extension and need to be upgraded each time to function with other reports.
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.
So much time is wasted editing these reports into something usable.
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.
I agree. This is a much needed improvement.