Click here to Skip to main content
15,895,777 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have created custom group with custom sorted value by using ' in specified order ' in Crystal Report.
If there is no record the above created groups then i want to write my own text there.

Like:

Group 1
Record1
Record2
Record3
Group 2
Record1
Record2
Group 3
'No Record'


Here is Group 1 and 2 have records (fetched from Database) but there is no record in Group 3 from Datebase. So, I want to write my own text like 'No Record'.
Posted
Updated 24-Jun-14 23:48pm
v2

1 solution

Apply formulas in Crystal Report.

Take 3 text fields that are hidden in crystal design and name them according to your group.
Now when u fetch data from your database insert formula in crystal provided by your group name.
Suppress in your texts that are not in use

Refer this link : HOW TO Create Crystal Report Formulas - Easy Simple Tutoria or Suppress field in Crystal Reports
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900