- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Hiding null values in a column in SAP Crystal Reports
I am not sure where this formula is written. You have to write this formula in suppress part of Section Expert.
To open section expert, right-click Report Header → Section Expert click x→2 or suppress
Also, note that you can write the formula in any section where data is present in your report. Try below formula
ToNumber({Choice_.Choice1}) > 0 //You have to ensure choice1 should always a numeric value else report throws exception
- Related Articles
- Edit report generated from SAP Crystal Reports
- Using Filter to fetch specific data in SAP Crystal Reports
- In SAP Crystal Reports, removing extra white space between details sections
- In SAP Crystal Reports XI, return records that match multiple conditions
- In SAP Crystal Reports, Putting 2 pages of data into a single report
- Difference between SAP Crystal Reports and CR for Visual Studio
- Hiding a column in Data Preview in SAP HANA
- Suppressing the page header till the last page in SAP Crystal Reports 2008
- Displaying Records with maximum event number for each group in SAP Crystal Reports
- Hiding SAP ABAP table control column
- Check for NULL or NOT NULL values in a column in MySQL
- Display only NOT NULL values from a column with NULL and NOT NULL records in MySQL
- Python - Remove a column with all null values in Pandas
- Place a specific value for NULL values in a MySQL column
- Displaying distinct values in a column filtered on other column in SAP BO report

Advertisements