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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ChrisH1

  1. ChrisH1

    Formula Editor

    Finally got it working by inserting the report itself as the sub report and then hiding the main one, so only the subreport was visible. Many thanks for helping me get there.
  2. ChrisH1

    Formula Editor

    Im seeing records returned for employees that have not worked on job A012621. Im trying to get the report to only display records for those staff with time on A012621 but still show the other jobs they have worked on. At the moment Im seeing everybody and every job. Any ideas ?
  3. ChrisH1

    Formula Editor

    Your quite right, not sure what I was doing there. Still have a problem with this being a standalone formula : if {SYJOBTRN.JOB} = 'A012621' then totext({SYJOBTRN.JOB},0,"") else 'Other Jobs' this generates too many argumnets for this function the {SYJOBTRN.JOB} is a string so I removed the...
  4. ChrisH1

    Formula Editor

    Many thanks, Im actually modifying en existing report but an error now appears when adding in the above that too many arguments have been given to this function. {SYJOBTRN.WORK_STAGE} >= ' ' and {SYJOBTRN.WORK_STAGE} <= 'zzzzzzzzzzzzzzzz' and {SYJOBTRN.ACTIVITY_CODE} >= ' ' and...
  5. ChrisH1

    Formula Editor

    Hi Im trying to run a report in Crystal 8 with the following formula included {Job} is equal to 123456 but what I want the report to do is display all records for employees that have allocated time to 123456 but display all the jobs that they have booked to as well as. I just cant think of a...
  6. ChrisH1

    Excel Formula

    Thanks for the help
  7. ChrisH1

    Excel Formula

    Using Excel 2000 I have a spreadsheet where I need : To change the colour of a cell to red when the value falls below that of another cell and if the value is say 10% higher than another cell then I need it to be green. I presume this would be via a formula. Could anyone provide a sample...
  8. ChrisH1

    Summary Problem

    Person is the same as personnel code Using the groups outlined above I get the following sample data. Joe Bloggs w/e 07/04/07 Workstage Hours 1234 33.5 4321 1 What I want to add is the summary of 33.5 + 1 I have tried putting the quantity value in...
  9. ChrisH1

    Summary Problem

    Using Crystal 8 I have a crystal report in the form of a weekly timesheet. The format as follows PH - Contains the Company name, Timesheet Users name and week ending date. GH1 - Week Ending Date GH2 - Personnel Code GH3 - Workstage GF3 - Contains the Workstage field and the quantity of...
  10. ChrisH1

    Cross Tabs

    Thanks for the advice. Although it works there are two issues. 1. When an export to excel is run it looks as if only one cross tabs data is being exported. Theres only one summary appearing. 2. A minor issue is that the summary data in the crystal report starts in synch but with half a dozen...
  11. ChrisH1

    Cross Tabs

    Using Crystal 8 Having not used Cross Tabs much, can someone please point me in the right direction. Currently my Cross Tab is as follows : Rows Workstage @Name Column Week Ending Date Summarized Field Sum of amount Sum of quantity Example output 23/09/06 30/09/06 FARC...
  12. ChrisH1

    Parameter Selection

    I have set up a new fomula called Office as (?Office) = " " You mentioned "In selection, include @OfficeCheck - this is taken to mean that record should be selected when @OfficeCheck returns 'True'. " I dont understand what you mean by " In selection" What do I do with the formula ? Thanks
  13. ChrisH1

    Parameter Selection

    Using Crystal 8 I have a report using one parameter that Im having problems structuring. The user needs to be able to select the offices the report displays. I have used the following parameter Called Office Type = String Allow Multiple Values = Ticked Allow editing of default values when...
  14. ChrisH1

    Portrait Landscape

    Hi Im using Crystal 8 The Crystal I use is published via Citrix and Im currently having printing problems. My company is looking into this (albiet very slowly) The printing isnt a huge probelm but what Im finding is that some of the landscape reports I have been working on are reverting to...
  15. ChrisH1

    Radio Buttons or Pick List

    Thanks that did the job nicely !
See more

Part and Inventory Search

Back
Top