Search results for query: *

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

Is it possible to use the thousand seperator on the left hand axis of a graph, e.g. 2,000 instaed of 2000? Also can you place a formula in the Title of a Chart? I know that I can place the formula in atext box above the Chart, but it would be nice to be able to place it in the Chart Title...

A Crystal Report based on a MSSQL Database and published to CE10. Is it possible to ensure that users only see data in the report if we use Active Directory (Windows Server 2003. In other words a user logs on and CE10 authenticates them using Active Directory and then when they view the report...

Thanks for replying pojour. The Data Type could be numeric or string, depending on the field. Your suggestion would work if all I needed was the min and the max, but I also need to display the values between the min and the max. Thanks Cristle

Hi I'm using Crystal Reports XI. I need to display a Range of Values, selected in a Parameter, and display the range in the Report Header. However I'm getting the message that a String Array is required If I select Discrete Values in my Parameter I can display them by creating the formula...

Many thanks Bob Cristle