Hi,

I am using a Crystal reports in order to get the information from the database (ORACLE 9).
The source of data is the script which I added via add command using ORACLE OLE Provider.

I would like to say that now I am trying to implement CR formulas in order to give the
 following message :
 "NO USERS LOGIN"

I wanted that when there is no user connected to the database Crystal Report gives this message.


In order to that I created the following forumla from the formula Tab, but it didn't give any
 message on crystal reoport, when no user login to the database:

Formula 1

if count ({command.USER}) < 0
then "No User Login to Database"

or

Formula 1

if count ({command.USER}) < 1
then "No User Login to Database"


I tried to drag this formula on various section of reports (Detail, Report header), but it
did'nt work.


But when I used greater than sign instead of using less than size, this formula works and
 gives the message.

For Example:

Formula 2

if count ({command.USER}) > 0
then "User Login to Database"

Could someone please inform what changes I made in the formula 1 in order to display the message
"No User Login to Database", when there is no user login to database.

I also like to say that the routine which I am using in the Crystal Report gives me information
of several Users who are connecting to the database.

Thanks

David

I would think that when you are running the report, you are then a user logged onto the system, so you would never have an instance when running this report of less than one user. Perhaps you need to set that number to <=1?