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!

*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.


Cross-tab within report excel download

Cross-tab within report excel download

I have a question using Crystal XI and exporting to Excel. The detail of the report is standard rows of data - I've learned how to export nicely to Excel without adding extra rows to the Excel output file. My question is that I now have a crosstab at the bottom of the report in the Report Footer section. I'm having a hard time formatting the crosstab to not mess up my columns.I can't line up the columns to the vertical guidelines already in the report. I'm having difficulties lining up the columns in the report to the guidelines in my report and within the crosstab I would like to make my data total fields line up to my vertical crosstab lines so I don't create extra columns in my exported Excel file. Anyone have a secret to do this?

RE: Cross-tab within report excel download


Your crosstab belongs on a separate sheet. It must be obvious considering the column problems you've been experiencing.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Cross-tab within report excel download

If you would like to show both the main report and the crosstb on the same sheet, you still need to put the crosstab on a separate sheet. However, using Excel's CAMERA feature, you can place a "picture" of the crosstab on the other sheet and position the picture anywhere you like.


glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Cross-tab within report excel download

You will need to make your main report columns the same size as your Crosstab columns. In addition your total columns must be same size as the data columns.

It might be that when run in crystal you get text cropping but once exported to Excel you can then get everything to fit, However your cross tab will then look at bit odd.

Generally speaking DON'T DO IT. Crystal and Excel do not get on and trying will reduce your life expectancy smile


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!


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