Supress a field in grand totals in cross tab
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21484
Printed Date: 01 May 2024 at 5:56pm
Topic: Supress a field in grand totals in cross tab
Posted By: achandana01
Subject: Supress a field in grand totals in cross tab
Date Posted: 13 May 2015 at 9:30am
Hi,
I have the following fields in crosstab
Acc_Count
hours
LOS
however suppressed LOS in grand totals section right click then format field --> click on supress and its supressing the field. The only issue here is when I am trying to export in excel sheet its messing up the format of the report and makes it looks weird.
Is there a way how to do without messing the format of the report ? Btw I use standard excel option not data only.
Thanks,
-------------
chand
|
Replies:
Posted By: achandana01
Date Posted: 14 May 2015 at 7:30am
Can someone help me out please?
-------------
chand
|
Posted By: Erik
Date Posted: 14 May 2015 at 10:26am
You might need a blank text cell to fill in for where you suppressed the LOS value. When you export to Excel, it looks at each cell as a placeholder in the column, and if one is missing things could get shifted to the left.
It would be helpful if you could provide a screenshot.
|
Posted By: NewLabRat
Date Posted: 13 Nov 2015 at 9:30am
|
I have the same issue with a suppressed crosstab field and the export to Excel. Is there any way to force the program to not reserve a space for the Excel export? The crosstab screen display looks great but the export is a mess! How would I create a "blank text cell"?
|
|