Recent content by MartUK

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?