Search results for query: *

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...

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...

I need to pull information out of a SQL db using a query. I need to generate a final status of "Locked"or "Unlocked" for each computer in our organization. In order to find out whether the PC is locked down, I have to evaluate what is contained in the SMX_Local_Admins_DATA.Account00 field for...

Hello Everyone, We are preparing to upgrade to Business Object XI and are in "clean-up" mode. I am needing to produce a Crystal Report that lists all reports that are published and what folder they are under. The closest thing I have found to getting the results I want is the use of the Query...

Hello Everyone, I am using Crystal Enterprise version 10. We have 10 concurrent licenses and, as you can imagine, that is not enough for our 200+ users. We are in the process of getting a processor license, but I am wondering if there is any way that I can tell WHO is using each of the 10...

I have a report that I am putting together about desktop PCs. I am pulling the information out of a SQL db and the end result is a graph that says how many PCs are "locked down" and how many PCs are "unlocked". In order to find out whether the PC is locked down, I have to evaluate what is...

Hello, I am trying to access a crystal report using a URL, but do not know how to construct the URL. I have tried many different combinations and looked on the Crystal support website, but the solutions seem to all be very different. Can anyone give me the syntax for this? Thank you in...

I need to use the Crystal SQL Designer, but I do not have it installed on my machine. I have Crystal Reports Advanced 9 installed with all options installed on the local hard drive. Where do I get Crystal SQL Designer?

Hello, I am using Crystal 9.0 to report on a SQL 2000 database. I have an open date field and a close date field. I am able to calculate the time between these two dates, but what I would like to do is this: Say the open date is on Friday at 4pm and close date is on Monday at 8am. I only want...