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 Chris Miller 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: *

  1. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Thank you I will give it a try and let you know how it works out.
  2. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Unfortunately there is no filed containing this data. I cannot create a table in my source so I will have to code it. I am trying to avoid having a separate report for each fleet by allowing them to select the appropriate fleet and bringing the training items and expiration dates along with...
  3. puzzles7

    2 Questions on a Crosstab in Crystal reports

    I'm still not sure we're on the same page. Currently my Summary field is the Issue Date for the Training class the mariner took. The classes can be taken at various times as many are taken online so there is no consistency. The complete class list varies by fleet as does the need to repeat...
  4. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Ok, let me try to explain this beter... I am pulling in the MAX{crew_training.issue_date} for each training item. Because SOMEONE is taking the class then it will simply show as a blank for theose mariners who do not have it. We only track issue dates for each mariner training because the...
  5. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Sorry, in strategy meetings all week. Let me explain a little better. Below I have shown an example of what I am looking for. The name of the mariners and the training titles will be dynamic. The dates are the dates that the mariners took the classes. Each class has a different timeline for...
  6. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Thanks so much. I was able to make your suggestions work. I also tricked the system into showing all my training items by creating a dummy person who has all the training. Now I just have one last question. How would I apply conditional formatting to the dates of issue when the expiration...
  7. puzzles7

    2 Questions on a Crosstab in Crystal reports

    Hello, I am very familiar with Access but it's been a long time since I've used Crystal and so I'm a little lost. I am working in Crystal 10 and I need to produce a crosstab that shows a list of dates when certain training has been completed for all people in a particular fleet. My Row...

Part and Inventory Search

Back
Top