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: ChrisH1
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. ChrisH1

    Radio Buttons or Pick List

    Hi Using Excel 2000. I want to issue an excel document wherby the recipients can respond how often they use our reports. Eg. Daily Weekly Monthly Occasionally Never In excel can radio button be used or is there a way users can select responses from a pick list. If either of the above is...
  8. ChrisH1

    Specified Grouping

    Hi Im using Crystal 8. I have used specified grouping for the first time and it works as expected. However is there a way to get the specified named groups to display on the report. For example I have the a group based as follows : GH2 - SYJOBTRN.WORK.STAGE Sample records S00511 S00512...
  9. ChrisH1

    Parameter Field

    Hi Im using Crystal 8. The report Im developing has 3 groups (in the following order) Job Workstage Personnel I want the user to be able to choose a workstage range but I would like the report to generate everything if the user chooses not to use this parameter. How would I structure the...
  10. ChrisH1

    Identifying empty fields

    Hi I apolgise in advance if Im not presenting this logically. I have a report with the following data fields : SL.Account and Anal_Desc. eg. SL Account Code Anal Desc. 010063 Local Govt. Im pretty sure that there are SL Accounts without a decsription. How...
  11. ChrisH1

    Graphs - Legends and axis titles

    Hi I have a report that generates a graph. Im having a few problems editing the graph structure : The legend contains the formula titles from my report, is there a way to change this ? eg. Currently - Sum of @Inv CM Desired - Management Also the horizontal x axis is displaying the...
  12. ChrisH1

    Exporting Charts to excel

    I have a report that features a graph, if I try to export to excel the report data is fine but the graph is an empty box. Does this mean that charts/graphs cant be exported ? Im using Crystal 8 Thanks Chris
  13. ChrisH1

    Crystal User Guide

    Hi Im currently using Crystal 8 and have been using a help book called Crystal Reports : A beginners guide - David Mcamis. Its been very useful but I now need something that goes into a bit more detail. Can anyone recommend a good intermediate/advanced guide ? Im in the UK (I dont know if...
  14. ChrisH1

    Total % formula

    Im trying to write a formula that will generate a total profit %. In the GF I have used the following : if sum ({@Work Done},{JCPERTOT.COMPANY}) = 0 then 0 else (sum({@Profit Multi},{JCPERTOT.COMPANY})/sum({@Work Done},{JCPERTOT.COMPANY}))*100 I now want to do a grand total profit percentage...
  15. ChrisH1

    If then else statement

    Hi Im trying to create the following formula : If {job.unit} = "unit1" or "unit2" or "unit3" then {job.invoiced} Im getting an error with regard to a missing boolean. Can anyone please help correct my obviously poor attempt at a formula. Many Thanks Chris
  16. ChrisH1

    Shared Variables & Subreport

    I have a subreport with the following formula "whileprintingrecords; Shared CurrencyVar myTotal : = sum ({cash recieved}, {SLPAYHST.JOB})" I then placed the following formula in the main report within RFb (the subreport is in GF2a) "whileprintingrecords; Shared CurrencyVar myTotal; myTotal"...

Part and Inventory Search

Back
Top