Search results for query: *

Nope, no subreports. I didn't even change it to see if this would make a difference, it was completely accidental - and also the only change I made since the previous test. Still, I'm not complaining. Thanks for your help anyway! Simon "I do not have to forgive my enemies. I have had them all...

Problem solved - I hid the detail instead of supressing it, and now it all adds up. Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

Ah, it seems I misunderstood - ignore my post, Madawc has the right (and better) answer. Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

I'd use the Split function to break off everything after (and including) the "@", then the Right function to get the 3 characters you need. I think this should do it: Right(Split(FieldName, "@", 1), 3) Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

Right, I've just tried your 3 formula method - and it gives me exactly the same number as the other methods. I'm starting to think that the formula is correct but something is going wrong elsewhere. Having tried these methods with another formula in the group, I encounter the same problem - the...

Which version of Crystal are you using? In V9 once you create a sum on the report, it shows up in the field list within the Formula Workshop. Have you tried: Sum(INVOICES.INV_AMOUNT) - Sum(INVOICES.PAID_AMT)? Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon...

I didn't think the formula I'm trying to sum was an influencing factor, which is why I didn't post it. It is... WhileReadingRecords; Local DateTimeVar d1 := {@Q1StartDate}; Local DateTimeVar d2 := {@Q1EndDate}; DateDiff ("d", d1, d2) - DateDiff ("ww", d1, d2, crSaturday) - DateDiff...

I'm using V9 of Crystal and the report is relatively simple, the basic structure looks like: Group 1 (Team) Group 2 (Name of Employee) Detail (Sickness record) I'm trying to sum a formula in the Group 2 Header calculating days employed (and thus totally unrelated to the detail), to appear in...

Good morning people, I'm hoping someone can help me with a little confusion I'm suffering from... I have 2 values, a formula (x axis) and a running total (y axis), and I want to display them in a bubble chart with the number of incidents of these two values represented by the size of the...

It works :D Thank you all for your help, you've just saved me another day of banging my head on my desk! Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

Still no joy, exactly the same error. It's just not finding the formula! :( Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

Cheers for the trimmed code firefytr, but I'm still getting the #name? error. I've amended my CountByColour function to match the trimmed version, and that works fine but the bold one gives me the same error even if I deliberately break the code. What would cause it to not show up in the User...

Cheers for the ideas, but I'm still getting the same #name? error when I try to use the formula. For some reason the CountByBold formula doesn't appear in the User Defined Fuctions list whereas the CountByColour does, could it be going wrong on this front? Both are pasted in the "ThisWorkbook"...

I'm trying to write a function that will count the number of cells within a range that are bold, despite having a function that counts cells of a particular colour I have not managed to adapt it for 'bold checking'. The colour function that works fine: Function CountByColor(sCountRange As...

I am on a roaming profile, but the laptop users have recently been converted from roaming to local. Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

I hope someone can help, as this is driving me barmy. We have a problem on our network, we can delete files and everything seems fine, but when we log back on the darn things are there again. We're running Server 2000, with the workstations and laptops all on XP. This usually happens with...

Petrovlis: Try using a different site, a Netherlands based one should solve that problem (and have more up to date maps, I thought I'd messed up when testing the above but it turns out MapQuest didn't have any of the streets I was looking for!) Simon "I do not have to forgive my enemies. I...

I'd love to write my own job description - I'd miss off anything I didn't like doing :D I actually got given mine this week, after being in this role 8 months! I quite like the variety of work, but it's a shame the pay is so appalling. Key Responsibilities Systems Administration - To...

Gah, that'll teach me to post during crisis moments at work! I didn't think it looked right, but after typing it six times I was beginning to forget what it meant... *beats himself with a dictionary* Simon "I do not have to forgive my enemies. I have had them all shot." - Ramon Maria Narvaez

It is possibly to have deju vu about having deju vu, so you could have "deju vu all over again" I have yet to have deju vu about having deju vu about having deju vu, which I am pleased about as my head hurts enough as it is just having seen myself seeing something else before. Simon "I do not...