Print Page | Close Window

1 Crosstab field but contains two data type value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12292
Printed Date: 03 May 2025 at 12:16am


Topic: 1 Crosstab field but contains two data type value
Posted By: yhlai
Subject: 1 Crosstab field but contains two data type value
Date Posted: 10 Feb 2011 at 9:28pm
Dear all,

How can I set a crosstab summerized field with both string and numeric data type? Because this field have both numeric and string value, I need to show numeric type for numeric value and string type for string value, so that when exported to excel the numeric field can be selected by mouse and see the SUM at the right bottom of the excel (If all are set to string type excel will not SUM these values).

Thanks.



Print Page | Close Window