Recent content by cristle

Can anyone tell me how to go about uisng crystal Reports with a Java app. 1. Must the Crystal Report (2008) be developed using Eclipse 2. Can the report be created in Crystal Reports 2008 for windows 3. How can the report be called in the Java application 4. What licenses are required, e.g Is a...

Ian, I did try that but in a different way. I created a formula to test for the difference and used the formula in the select expert. I got some strange results, so I opted for a Sub-Report. i think that it may be a data problem. Thanks for your suggestion.

Hi, I'm trying to identify data that has changed bewteen two dates. I have one Table showing current data and a second table containing data stored at a particular point in time. I want to report on only the data that has changed since say 1st April (stored in the back-up table) I'm trying...

Thanks Turkbear, I'm used to windows myself. I've been contradicted on the need to install the Oracle Client on the CRServer, Like you I believe it has to be installed to access teh CMS Thanks again. Cristle

Hi, I'm installing Crystal Reports Server 2008 on Red Hat Linux 4. Oracle will be used to store the CMS and the Reporting database on a different server to where CRS2008 will be installed. Is the Oracle Cliemt required to be installed on the Crystal Reports Server 2008 and the TNSNames.ORA...

Does anyone know how to identify if call agents are adhering to their schedules, e.g. an Agent is scheduled in eWFM to take at break at say 10.00am 12.00pm, 3.00pm but in fact takes their break at say 10.30pm, 12.15pm, 2.00pm and another unplanned break at 4.00pm. The actual break times are...

LB, Thanks for you help yesterday. I now have a solution as follows, dateadd("n", remainder({DET_SEG.START_MOMENT},1440),dateadd("d",{DET_SEG.START_MOMENT}/1440,datetime (1899,12,30,0,0,0)) ) Cristle

HI LB, Any chance that you could give me the solution you have for 02/01/2008? Thanks Cristle

LB, Here's some more examples Moments Equivalent_Date_Time 56,804,310 31/12/2007 10:30:00 56,804,565 31/12/2007 14:45:00 Thanks Cristle

Interestingly, if I use the following formula dateadd("n",(525600*68),#30/12/1899#) I get 14/12/1967 12:00:00 where 525600 = mins in a year, 68 = 68 years However when I change the years from 68 to 69 I get 06/11/1832 12:00:00 Cristle

The "Moments" are only stored as Minutes so I don't think that's the problem. Here's some sample data. If I add 1440 minutes to your formula it it works , I wonder if it's failing because we'er traversing a century, Moments Equivalent_Date_Time 56,807,295 02/01/2008 12:15PM...

Thanks for your reply LB, However I'm still stuck, I have a value of 56,807,295 Moments that I believe is actually 02/01/2008 12:15PM. When I try your formula, dateadd("n",{DET_SEG.START_MOMENT},datetime 1899,12,30,0,0,0)) I get the result 26/11/1871 05:46:44. If you've any other thoughts...

I'm reporting off an application called eWFM using Crystal Reports XIR2. There is a field called Start Moment that contains the planned start time of say a lunch break. However the time is stored as "Moments", which I understand are actually minutes since 30/12/1899 12:00am. Does anyone know...

Does anyone know of documentation/books/tutorials for creating a user interface that will allow users to go directly to a folder in CE10 Enterprise, therby not usine ePortfolio? Thanks Cristle

I have successfully coloured alternate records in a Group Header. using the following code on a text box, if remainder(GroupNumber,2) = 0 then crBlue else crWhite However, this will not work where I use it in the detail section as some records are suppredded. Any ideas how I can do this in...