×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

extra empty column when exporting to MS Excel

extra empty column when exporting to MS Excel

extra empty column when exporting to MS Excel

(OP)
I have a Crystal 10 report using SQL. For the extra spacing, I did the following and it worked for all columns except for one.
- all the headers and fields are the same height and are aligned at the top
-used guidelines to link column headers and fields together so there is no white space between them.

I have the extra space between the last 2 columns. One which is a database field and the other which is a formula.

Any suggestions on how to resolve this?

 

RE: extra empty column when exporting to MS Excel

Hi,
Try usng a formula using the Trim() function on the database field and place that in the report instead of the field itself.

(The database may be padding to fill the defined length regardless of the actual data length)

 

profile

To Paraphrase:"The Help you get is proportional to the Help you give.."

RE: extra empty column when exporting to MS Excel

I think you should test whether they are in fact attached to the vertical guidelines by moving the guidelines left and right. This really shouldn't happen if they are attached correctly.

-LB

RE: extra empty column when exporting to MS Excel

(OP)
lbass- they do move to the left and right this is why I don't understand why they are not working.

turbear - i tried that and it didn't help. It actually created 2 additional columns.

Any other suggestions?

RE: extra empty column when exporting to MS Excel

(OP)
Perhaps it may help if I state what the formula field contains.
It is as follows: @display =
whileprintingrecords;
stringvar x;
if len(x)>1 then
left(x,len(x)-1);
This is placed in the group footer.

In the details, there is another formula @accum =

whileprintingrecords;
stringvar x := x + {V_Custom_CorpTaxCode.owner_name} & " " &
(
if isnull({V_Custom_CorpTaxCode.ownercorptaxcode}) or {V_Custom_CorpTaxCode.ownercorptaxcode}= ' then
"" & ";" else
"(" & {V_Custom_CorpTaxCode.ownercorptaxcode} & ");"
)

It is placed in details and suppressed.

Then the last formula is called @reset = whileprintingrecords;
stringvar x:="";
it is placed in the group header which is suppressed.

 

RE: extra empty column when exporting to MS Excel

When you export, make sure you are using the section where your fields are located for the column width. Also, make sure that column labels are ALSO attached to the same guidelines.

-LB

RE: extra empty column when exporting to MS Excel

(OP)
The column labels are attached to the same guidelines.
I am choosing all fields and column labels and setting to same height. Is there anything else I should be doing?

RE: extra empty column when exporting to MS Excel

Even if section is suppressed Are all the Details fields attached to guides too?

Do you have any Header fields like Titles or dates. These should also be attcahed to guides otherwise they will introduce columns

When you export to Excel do you define which section should be used to determine Cell width?

Ian

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close