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
DavidI think that's normal, because crystal create a connection to your database to verify the number of user connections. So I think that you must put the following formula in your report:
if count ({command.USER}) < 2
then "No User Login to Database"
To verify what I say just print the field {command.USER} to see his value.|||Hi ariqa,
Use the following formula
if isnull ({command.USER})
then "No User Login to Database"
Madhivanan|||Hi Machuet & Madhi,
Thanks for your cooperation.
Yours solution helped me.
Thanks
Regards
David
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment