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!

  • Congratulations gkittelson 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: MHann
  • Order by date
  1. MHann

    Parameter Fields question

    I'm using version XI. The paramters are forced into the report by an SAP Infoset. Leaving the date blank was not an option it can either be null or there has to be a date. I was able to cheat it and put the dates as 12/31/9999. This will always pull the data I need. Only problem is it will...
  2. MHann

    Parameter Fields question

    Hello, I have 2 Parameters that came into my report from the database (BegDate & EndDate). I want to set these dates to default to the current date. While I can create a new parameter set to current date I'm having trouble doing so with these existing parameters. Any ideas? Thank you.
  3. MHann

    Transaction date question

    Hello, I'd like to pull the most recent promotion date for each employee in an organization but if a person has been promoted more than once get multiple lines. How can I only get the most recent date and a blank field if there is no promotion? Here is what I'm seeing: ID HIRE DATE...
  4. MHann

    Comparison Line Chart

    Forget the word trend. I'm not explaining myself well. All the perf scores are from the same date. I'm only trying to graph the company wide scores to a department like below. Example: Dept A: 5 excellent employees and 6 average employees. Company:50 excellent employees and 190 average...
  5. MHann

    Comparison Line Chart

    I'm charting on change of performance score. I'm trying to graph a comparison of the companies scoring trend compared to a specific department.
  6. MHann

    Comparison Line Chart

    I'm using version 10.
  7. MHann

    Comparison Line Chart

    I have data in a spreadsheet that contains performance scores for an entire company. I'd like to use Crystal to chart one department compared to the entire company from that spreadsheet. Is this possible? I've run into a wall. Thank you Example of spreadsheet: ID NAME DEPT TYPE(mgr or...
  8. MHann

    Search the whole column

    Thank you! Worked perfectly!
  9. MHann

    Search the whole column

    I'm trying to create a field that says "Supervisor" if the employee supervises another employee in the report.
  10. MHann

    Search the whole column

    When I use that formula it only compares the fields that are on the same row. I'd like to compare Employee 1's supervisor to the entire Employee column. I think I stated this incorrectly I also wrote my example wrong it should have been: Employee Supervisor @formula 1 2...
  11. MHann

    Search the whole column

    Ok. Thank you. I'll give it a try.
  12. MHann

    Search the whole column

    if {table.employee} = {table.supervisor} then //rest of formula Is there a way to do it when both fields are in the same table?
  13. MHann

    Search the whole column

    I'm trying to compare one field on one line against fields in a column on the same report. Similar to vlookup in excel. From below: If the formula is able to find an employee who is also a supervisor it will give a certain output. Is there a way to do this? Employee Supervisor @formula 1...

Part and Inventory Search

Back
Top