Hi,
Im having a problem, which I would imaginge has a very simple solution; I developed a crystal report which is connected to a table (table1) in a database. The field im working with which holds unique values is the uni# field. I have the report set up to display information in a bar chart and on a table. However, I want it so that when there is no information to display (ie no records), a message (in a text box) is displayed on screen saying something like "no data found".
I tried creating a formula called "nodata" which contained the following code:
if ({Datatable1.uni#} = 0) Then
'no data found'
and i dragged this formula into the details section. However, when i run the report, no message is displayed, whether there is data on the screen or not.
can anyone please help me with this issue?
thanks.
J