Print Page | Close Window

Format specific values in the column. Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 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=22545 Printed Date: 29 Apr 2024 at 1:21pm Topic: Format specific values in the column. Posted By: mh9876 Subject: Format specific values in the column. Date Posted: 09 Feb 2018 at 9:55am I'm trying to format specific values in the same column of crystal report. The column should show all the other numbers as decimals, except for 100. 100 should be shown as a whole number. This is what I did. In format field, Number tab, customize, For Decimal I entered following formula; If {@Numeric2} = 100 Then 1 Else 1.0 The problem is that it is not rounding 100 as a whole, instead, showing 100 as a decimal as well like 100.0 Replies: Posted By: DBlank Date Posted: 12 Feb 2018 at 2:43am right click on the field select format field select number tab select customize button select the formula (x+2) for Decimals use if currentfieldvalue = 100 then 0 else 1

Print Page | Close Window