Skip to Content
0
Former Member
Mar 02, 2009 at 10:39 AM

very simple (i think) crystal reports problem

23 Views

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