Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: djeddie
  • Order by date
  1. djeddie

    Bulk Editing Formulau

    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.
  2. djeddie

    Bulk Editing Formulau

    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"...
  3. djeddie

    Bulk Editing Formulau

    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...
  4. djeddie

    Bulk Editing Formulau

    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...
  5. djeddie

    Bulk Editing Formulau

    Excellent tip Thankyou for that!!
  6. djeddie

    Bulk Editing Formulau

    Hi, How do i convert a formula to a function?
  7. djeddie

    Bulk Editing Formulau

    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...
  8. djeddie

    Running Fortnights

    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...
  9. djeddie

    True Weekly Movement

    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...
  10. djeddie

    True Weekly Movement

    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...
  11. djeddie

    True Weekly Movement

    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...
  12. djeddie

    True Weekly Movement

    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...
  13. djeddie

    passing rank through a sub report

    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...
  14. djeddie

    passing rank through a sub report

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

    passing rank through a sub report

    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} =...
  16. djeddie

    Ranking involving running total

    Actual Availability needs to be a running total becuase it summarises the ACT_AVAIL field where SCHED_AVAIL <> 0.
  17. djeddie

    Ranking involving running total

    Hi All, Firstly, im using Crystal Reports XI and ODBC Now, 1. I have a running total field to calculate the Availability of each staff member. #Actual_Availability 2. I have a formula showing the Adherence percentage of each staff member. @Adherence =...
  18. djeddie

    Rotating x-axis label to 90 degrees

    Hi lbass, Im actually trying to rotate the axis label 90 degrees, not the bar.
  19. djeddie

    Rotating x-axis label to 90 degrees

    Okay, Im losing my cool here............ Using crystal XI and created a stacked bar graph with time along the x-axis. No matter how many times i resize the chart and muck about, when i select 90 degrees for the rotation of that axis, it wont work. What do i have to do to make this stupid...
  20. djeddie

    Display All Formulas in a Report

    kskid, Thanks for trying but that was not what i wanted. Once again thanks anyways. dgillz, Cheers for the tip, but it didnt actually export the forumlas themselves. What i want is a way to export the formula name and the actual formula as well to have in a document.

Part and Inventory Search

Back
Top