Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: Report headings shifting when add custom Post Reply Post New Topic
Author Message
Michele
Newbie
Newbie
Avatar

Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 4
Quote Michele Replybullet Topic: Report headings shifting when add custom
    Posted: 25 Jun 2019 at 4:40am
Every time I edit the Column heading text/name, and export the report as excel data only (or schedule it to run and save as that format), the whole column headings shift. Has anyone encountered that, and how do I get it to stop without using the original column name?

Column heading should be:

PID Last First Middle Category ID BB_ID(custom) PID Status
1   Smith Joe D       Staff      123 123                  1        Active



But what I'm seeing when I export or run scheduled report to excel data format is this:
(export, Microsoft Excel (97-2003) Data only, Destination disk file, Typical Excel Format)

(shifted headings)               BBID(custom) PID Last First Middle Category ID PID Status
1   Smith Joe D       Staff    123          123        1   Active

(No data under Middle heading and over)

It looks like everything is shifting to after the custom header, pushing all other headers over to after the custom header. Data is not lining up correctly under it, with the PID showing up as Last name.

Any ideas how to fix it? I'm pulling in duplicate headings and it's from different tables and we're looking for mis-matches, so they are not always expected to match, which is the purpose of the report. How do I get custom headings to not shift the headings and data? I need to label headings as custom so the report user knows what table/screen to fix the data in.

Crystal Reports says it's 2008 version, 12.6.0.1596.

Edited by Michele - 25 Jun 2019 at 4:48am
Accept that which is good
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1493
Quote kevlray Replybullet Posted: 25 Jun 2019 at 4:50am
The main thing that you have to do when exporting to Excel is to line up headings and columns and make them the same width.  There are some options when exporting to Excel as far as how it determines the column width (Whole, Report, Report Header, Page Header, etc.), you can try that option also.
IP IP Logged
Michele
Newbie
Newbie
Avatar

Joined: 21 Jun 2019
Location: United States
Online Status: Offline
Posts: 4
Quote Michele Replybullet Posted: 25 Jun 2019 at 5:02am
Where is that option? I made sure I chose left justify for the headings and field data in the report design.

The headings and fields below them look like they are the same width to me.

I deleted and re-added a heading I wasn't sure about but it still is re-arranging the headings over the data.

The BB ID header was a little higher so I deleted it and put it in again with the custom name and it looks like exported data is showing up under the heading right now. Thanks!!!

Edited by Michele - 25 Jun 2019 at 5:24am
Accept that which is good
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1493
Quote kevlray Replybullet Posted: 25 Jun 2019 at 9:08am
The option is when you export to Excel.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.