Search results for query: *

No dont think this is the case. If we forget about the cross tab report and just look at the detail. If I group be ethier @EngCode or @Short code it works and just shows the one group. Its the cross tab that doesnt work. I think I will delete the cross tab and start again

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 have as I said used 2 attempted formulas @EngCode is {FSCALL.FSCALL_ALLOC_TO} [2 TO 8] @shortcode is ({FSCALL.FSCALL_ALLOC_TO} [1 TO 8]) I just use one of the above as a row field Column fields are @backboilers which is if{FSCALL.FSCALL_CALL_TYPE} ="EASV" AND {FSCALL.FSCALL_CATEGORY}=...

No I have checked again . I show another example and the results it give in the detail section. The details section looks fine its ONLY when I put eith @EngCode or @SortCode as a row in the cross tab field @engCode @shortcode value A1234567RE A1234567...

To Madawc, this makes no difference To Lbass What do you actualy mean by using my formula@EngCode as the rowfield? I have created the formula and now dragged it in to the crosstab using the cross tab expert wizard. But as I say it doesnt group correctly

the row label is @EngCode and this is set to -{FSCALL.FSCALL_ALLOC_TO} [1 TO 8] I may get for instance 8MFENTON xxx 8MFENTON y If I edit the formula to just show -{FSCALL.FSCALL_ALLOC_TO} then the result would show 8MFENTO xxx...

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

thanks this worked great

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?

thanks this works fine and I have amended the datediff formula also.

Mmmm this is weird. - the first part I mean. I had this myself but could not beleive the results I get tt time({tt}) 12.00 00:00:00 11.45 10:48:00 12.40 09:36:00 9.45 10:48:00 8.40 09:36:00 This is crazy not only are figures wrong but sometimes they give diffenet...

9.45 would be 9 hours 45 in the morning 12.40 would be 12:40 in the afternoon etc. The database I am using is very bad . some dates and times are in date format and some are not Once I get this conversion I then need to subtract from the CurrentTime , so maybe I also need to convert Current...

forgot to emphasise that the number format is shown in decimal format. PLease can somebody help me

thanks this works, any idea on the other time diff question I had?

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 want to join the data together not use subreports or import the data into Access. Question is how do I do the link as I must only link on first 8 characters

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

Yes this also worked, I used the current field value a long time ago and forgot about it, thanks again . As I asked earlier are we limited to the small range of colours?