Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting CrossTab (CR ver9) to Excel

Status
Not open for further replies.
JoyCR9

JoyCR9

MIS
Jan 13, 2004
70
CA
I have a cross tab report where I have editted the column headers using EDIT TEXT to be more meaningful for my audience (they are formulas...removed the @ sign).

When I export to Excel, the @signs reappear. Why? How to I get the editted text to export.

I am also curious to know why the suppressed grand total column is exporting. I have it suppressed in this Crystal Report 9 and it looks great on screen, just appears when exported to Excel 2000.

Regards,
Joy

 
Status
Not open for further replies.

Similar threads

milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
613
hilfy
hilfy
jlr123
  • Locked
  • Question
Date formula exporting to Excel as 1/0/1900
Replies
1
Views
211
pmax9999
pmax9999
Lucy_G
  • Locked
  • Question
Highlight whole row in a crosstab based on non crosstab info
Replies
2
Views
196
Lucy_G
Lucy_G
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
435
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
281
jchewsmith
jchewsmith

Part and Inventory Search

Sponsor

Back
Top