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!

Search results for query: *

  • Users: Jniland
  • Content: Threads
  • Order by date
  1. 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}...
  2. 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...

Part and Inventory Search

Back
Top