Search results for query: *

This formula is giving me a "bad date-time format string" when I run the report, but shows no errors when checking the formula: if isnull({HDCAllCases.Closed Date}) then CurrentDateTime else datetimevalue({HDCAllCases.Closed Date}) Any ideas?

I was importing 14,000 records using Remedy Import. It was going great until the last 2000, then I got the following error "Failure during SQL operation to the database -- ORA-01653: unable to extend table ARADMIN. T238 by 45 in tablespace AR_DATA (ARERR 552)". I couldn't find anything wrong or...

The database has name of the person as one field, then the list of their pcs as another multi-value field. I would like to have the report split the multi-value field and repeat the name of the owner. For example, if I have 3 pcs, instead of my name once with 3 machine names in the other field I...

I cannot successfully open any ODBCs I created for Lotus Notes databases. When I select the ODBC, it doesn't seem to refer to the server or any other information from the ODBC I created. When I open a report written against a Lotus Notes ODBC, it requests a User Name and PW, and it doesn't...

I would like to grab the name from an email address: CN=John Doe/OU=CLE/OU=MS How do I split it so I only display John Doe?

I have a few Lotus Notes databases that I run reports against. Sometimes I click preview and Crystal just closes, no messages either. I have Crystal Reports 8 Professional. Is this a known issue?

I have created a SQL ODBC Connection to a database, which tests successfully. However, when I try to create a report, Crystal doesn't find the database when I click on the ODBC connection. When I select the ODBC, it returns "...no items found...". I have Crystal 8. The database is HP Systems...

I have created a SQL ODBC Connection to a database, which tests successfully. However, when I try to create a report, Crystal doesn't find the database when I click on the ODBC connection. When I select the ODBC, it returns "...no items found...". I have Crystal 8. The database is HP Systems...

Five concurrent licenses came with Enterprise 8. If someone closes their browser without logging out, it ties up a license for what appears to be 30 minutes. Is there somewhere I can edit this and log off idle licenses within 5 minutes?

Just installed Crystal Enterprise 8 Standard. Testing running reports I created, added a report that pulls data from Remedy. It keeps requesting my logon info for the Remedy ODBC, I enter it, requests logon info again. Looked at Instance report, error is "Cannot open SQL server.&quot...

Is Web reporting the only way to give people access to running Crystal reports that don't have Crystal installed on their pcs? I have 8.5 developer, how do I proceed?

We are switching help desk software from Remedy to Clarify. I have been reporting on Remedy with Crystal, was wondering if anyone had experience with reporting on Clarify.

When running an active link in Remedy 4.05.02 I recieve and error: "The instruction at "0x77f578d3" referenced memory at "0x00000048". The memory could not be "read"." The active link runs a macro that selects the highlighted Remedy HelpDesk case, pulls it...

I am trying to change the name in the active links to match the new server name. The old server name was remedy.picker.com and the new server name is remedy.cle.ms.philips.com. I was trying to do the following: 1.Export active links as server dependant. 2.Update active links by doing a...

I am trying to create a linked report from 2 excel spreadsheets. When I go into ODBC, Excel, and select my first spreadsheet, I can add it to the report. Crystal doesn't allow me to go back into the Excel selection and pick another. I added the one to Favorites, closed Crystal and reopened...

I have separate tables for archived records and active records. They have the same fields. For example, I want the case id fields combined into one case id field. Is there a way for Crystal to read archive case id and active case id as one field, case id?

I am trying to chart the amount of time our servers are down per month reporting off of Remedy. My report is set up "Chart values shown: for each month". There are several months when no cases were logged and I want those months to have the value 100. It is ignoring empty months. Do I...