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 strongm 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 Jniland

  1. Jniland

    Average time in HH:MM format in crosstab

    Thanks for your help
  2. Jniland

    Average time in HH:MM format in crosstab

    I get to summary field->format field->common but there is no "displaystring". I guess I should've mentioned that I'm using Crystal 8.5.
  3. Jniland

    Average time in HH:MM format in crosstab

    Hi, I'm trying to put average time into a crosstab in HH:MM format, but there seems to be no way to format it this way. I've got an ELAPSEDMINUTES field which I convert to HH.MM elsewhere in the report, and I summarize it in group sections by using: Int(Average ({@Elapsed minutes}...
  4. Jniland

    Forcing column in cross-tab to appear even when there's no data for it

    Thanks for the replies I think I may have miscommunicated, I said "crosstab chart" but I really just meant crosstab, I'm not making a seperate chart. The information is all in one table, eg: Technician, ElapsedMinutes, WorkOrderNumber, type, etc.. Bob, 784, 12345, Project, etc.. Bob, 12...
  5. Jniland

    Forcing column in cross-tab to appear even when there's no data for it

    Hi, I'm trying to make a cross-tab chart for a weekly help desk report. The rows are technician names, the columns are work order types. There are 5 work order types, but some weeks there are no tickets for one of the types. I'd like for the cross-tab to still show that type as an empty column...
See more

Part and Inventory Search

Back
Top