Search results for query: *

I am using Crystal XI with Enterprise XI . I want to scedule a report on an Access 2000 db but I get the msg below: Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11\Data\procSched\CPL-CRYSTAL-SVR.reportjobserver\~tmp149c4e2dca10c70.tmp: Unable to connect: incorrect...

I am using cr XI. I have 10 string field containg engineer code (upto first 8 characters). When old event opened it puts RE in posion 9 and 10 I want to create a crosstab based on first 8 characters only -{FSCALL.FSCALL_ALLOC_TO} [1 TO 8] .It looks fine in detail data but when I put in crosstab...

I am using CR XI I want to extract records where a field ends with RE from a string. It can be at any position in the field thats why I need ends with functionality rather than specific position

I am using CR XI I have a string field relating to time 8 characters long wich I need to convert to time eg 07181244 left({FSCACT.FSCACT_CREATE_TIME},4) gives 0718 which I need to convert to 07:18:00. How can I do this please?

I am using cr XI How do I get a time diff in secs when I have the recorded time as a NUMBER eg 9.45 and want to get seconds difference compared to Data Time special field which is in time format? I want to flag up the record time against 'now' if greater than 2 hours for instance

I am using CR XI I want to restrict data from the following : {SP100_ACTIVITIES.EXPECTED_END} >= DateTime (2007, 07, 13, 00, 00, 00) to more generalised current date from 6:30 am onwards. Can some one help with the code syntax please

I am using CR XI I have data in ORACLE db in a field 12345678XX or 12345 XX . I also have data in an Access table 12345678 I want to link the 2. I have created a formula which extracts the first 8 charaters and this is fine but how do I link the results to the field in Access

Im using CR Xi. This should be easy but can get it to work. I have ' Sum of @NAC_FaultCode ' in my crosstab which gives zero I want to suppress so 0 doesnt show. I have highlighted in crosstab results preview. FormatField, Common, and in the supprees X-2 box put Sum of @NAC_FaultCode =0 but it...

I want to show a business hierachy using Crystal XI But it whatyou show as summation area I just want to show a list of engineers names not do any maths on the data Any ideas anyone? Accross the top would be various organisational layers and down the side would be the engineers role eg...

I am using Crystal XI I need to extract the postcode district of a postcode. I am using a formula as follows : left({FSLOCA.FSLOCA_POSTCODE},instr({FSLOCA.FSLOCA_POSTCODE}," ")-1) I have various formats to extract, the above only works when there is a space eg XXX YYYY or XXXX YYYY or XX YYY...

I am using CR XI. I have postcodes in table in following format : XXX YYYY XXXX YYYY etc There is no fixed numbers of characters but there is a space. What I need to do is extract data before the space and as you can see the space can be at a different position Can I then link the...