Recent content by almaler

I have searched the Business Objects knowledge base and found articles detailing steps I have already taken. I already opened a case with BO a while back and am hoping to find the answer more quickly by expanding my audience.

I have just finished installing Business Objects Enterprise XI R2 Premium and when I try to connect to the .NET Admin Launchpad I receive the following error. I have found several articles online that say to grant the Network Service account write access on the referenced folder and I have done...

I have just finished installing BOE XI R2 Premium and when I try to connect to the .NET Admin Launchpad I receive the following error. I have found several articles online that say to grant the Network Service account write access on the referenced folder and I have done that, but that has not...

Thanks for expounding on that. That really helps out for daylight savings time!

Thank you, Bob - that is exactly what I needed.

So there is no way in Crystal Reports 10 to take a date and minus 6 hours?

I really don't have the option to purchase anything. I need a way to do this with the out-of-the-box Crystal Reports designer.

Hello Everyone, I have installed auditing for Crystal Enterprise version 10 and am looking at the sample reports. I have noticed that the TimeStamp field in the CMS_AUDITTABLE table is formatted like this: 2006-03-27(16:41:26:640) This is today's date at 4:41pm. The actual time that this...

I am using the following SQL query (given to me by SQLBill and SQLDennis) to return computer names and a status of each record. SELECT CSD.Name0, SMXLAD.Account00, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account00, (PATINDEX('%NAME=%', SMXLAD.Account00)+6), (LEN(SMXLAD.Account00)))) NOT IN...

Ok - it is working. I had to put in a quote and change the position to +6 since the account names are surrounded in quotation marks. This works!! Thank you!!!! SELECT CSD.Name0, SMXLAD.Account00, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account00, (PATINDEX('%NAME=%'...

OK, upon further inspection of the results set, it is not working exactly right. Machine names show up more multiple times and all but 6 machines show to be "Unlocked" which is definitely not the case. Any ideas?

I took out the AS clause and it worked beautifully!!!! Thank you SQLBill and SQLDenis!!!

SQLDenis, I got this error: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'as'.

Ok, I looked up PATINDEX and found that I needed single quotes around %NAME%, so I changed it to the below query, but now I am getting this error: Server: Msg 156, Level 15, State 1, Line 6 Incorrect syntax near the keyword 'FROM'. SELECT CSD.Name0, STATUS = CASE WHEN...

I forgot to mention that the join should be on the MachineID field. I did test this and I got an error that says: "Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'NAME'." SELECT CSD.Name0, STATUS = CASE WHEN (SUBSTRING(SMXLAD.Account0, (PATINDEX(%NAME=%...