I'm using Crystal 9, against SQL Server 7.
I am creating a report which shows instances of failed user logins, which is reporting against our system's Audit Trail Log.
I have one field called "Input" which has a long sequence of data, which I have stripped out into individual fields.
The Data within the Input field originally looks like:
<CONNECT CONTEXTBUSINESSUNITID=0" CONTEXTUSERID="0" CONTEXTLOGINID="0" CONTEXTUSERNAME=""><USERNAME>cafosprey</USERNAME><PASSWORD>caf012i</PASSWORD><BUSINESSUNITNAME/><WORKSTATION>2787CAF</WORKSTATION></CONNECT>"
I have now stripped this data into the following:
UserName Password Workstation
cafosprey caf012i 2787CAF
I now need to encrypt the password to show **** instead of the actual password, but the length of the **** has to match the number of characters returned by the password field.
Any ideas?
Also, I'm still having a problem with the "bad date format string" error that I posted yesterday, can anyone rack their brains for an answer....I know it's Friday, but I promise to buy you a beer if you help out with that one!!!
Thanks
Natasha
I am creating a report which shows instances of failed user logins, which is reporting against our system's Audit Trail Log.
I have one field called "Input" which has a long sequence of data, which I have stripped out into individual fields.
The Data within the Input field originally looks like:
<CONNECT CONTEXTBUSINESSUNITID=0" CONTEXTUSERID="0" CONTEXTLOGINID="0" CONTEXTUSERNAME=""><USERNAME>cafosprey</USERNAME><PASSWORD>caf012i</PASSWORD><BUSINESSUNITNAME/><WORKSTATION>2787CAF</WORKSTATION></CONNECT>"
I have now stripped this data into the following:
UserName Password Workstation
cafosprey caf012i 2787CAF
I now need to encrypt the password to show **** instead of the actual password, but the length of the **** has to match the number of characters returned by the password field.
Any ideas?
Also, I'm still having a problem with the "bad date format string" error that I posted yesterday, can anyone rack their brains for an answer....I know it's Friday, but I promise to buy you a beer if you help out with that one!!!
Thanks
Natasha