Recent content by djeddie

Andrew&lbass, I sorta understand how you are trying to help me but i think i may not be explaining myself properly so firstly i want to thankyou for your extreme patience with me.

Hi Andrew, To answer your question, when i create the custom function it converted by {@Site} formula from this: select {@group} case "The Jokers", "ICU", "Vanguard": "Perth case "Jumping the Shark", "Invincibles": Sydney to this: Function (stringVar v1) select v1 case "The Jokers", "ICU"...

Hi lbass, in my database table the team name is in the format like this: City - Team_Name And everytime someone changed their mind about the structure of the teams Perth (for example) would be split into 2: Perth1 - Team_A Perth1 - Team_B Perth2 - Team_C etc and then they would restructure...

Hi Andrew, I gave it a go and i couldn't get it to work so i would like to show you what i need to be done and maybe you can shed some light. I have 2 formaule. A formula called {@group} and a formula called {@site}. The {@group} formula looks at the team name field in my database and...

Excellent tip Thankyou for that!!

Hi, How do i convert a formula to a function?

Not sure if this is the right place to ask so here goes. I have a report with about 6 subreports and all have the same formula in it to group teams together. Whenever a team is added i need to go into each subreport and add it manually. Is there a way for me to update all instances of the...

Hello, I am trying to create running fortnight group and noticed that a similar question was answered in thread767-914201. My reports is designed to show the emplyee churn rate week-by-week. Currently i have been able to do this over a single fortnight only and i would like to be able to do...

I have been thinking about how i have been trying to explain what i want and i've come up with another description. Basically, is there anyway to verify if a particular record exists anywhere in the previous group or in the next group? If i have one group being date_dump which is always a...

Here is an example of what the data looks like (date_dump is a weekly snapshot) DATE_DUMP STAFF POSITION 20070405 John Senior 20070405 Harry Senior 20070412 John Senior 20070412 Harry Senior 20070412...

synapsevampire, I have told you what the expected output is. You do know what is in {@Position}, the example says "Customer Service Rep". The code for the action is my initial request. If there was a field that indicate the movement each week then i would have been able to accomplish this...

Hi All, Using Crystal XI on SQL Heres what i need. I need to create a report that shows the true movement per week) of staff in different positions. i.e. Customer Service, Management etc I have a table that contains employee details for each week as a snap shot, so, there can be emplyees...

One more query, By using this method which is working so far, is it possible to create a formula to put on the main report which says "up" if the rank on the main report is higher than the one in the subreport and "down" if the opposite occurs?? Or is there any way to refer to a field in a...

lbass, That worked brilliantly YOU ARE A GOOD MAN!!!!! Thankyou synapsevampire, Thanks for the input.

Hi All, Using Crystal XI on a sql database i have created a report which shows the following information on the detail line: Staff Name | Team Name | @adherence | @rank the rank formula looks like this: if {@adherence} = nthlargest(1,{@adherence}) then "1" else if {@adherence} =...