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 TouchToneTommy 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. MarsianStar

    Treat the first record only.

    Crystal 11, Heat, SQL server, tables calllog assignmts For each call there is either one assignment and it is resolved by first level. Or it was reassigned to second level. I would like to list the re-assigned calls only along with rest of the assignments. sample data CallID Date...
  2. MarsianStar

    SQL Query formula replacement for Crystal Formula.

    Hello, I am using Oracle and CR XI. This is the command that I am using. The second code is for a formula in the report that I am also using, but because the field is not indexed, it takes about an hour to run. I would like to insert an equivilant formula in the SQl query to make run faster...
  3. MarsianStar

    Last record of the second table.

    Hello All, CRXI & Oracle, Call Center Enviroment. I would like to show the last journal entered in each ticket selected. want it to look like this Incident#(Num) Account(Num) Name(Str) ---LastJournal(memo) Each incident could have a lot of journals, I am only interested in the very last one...
  4. MarsianStar

    Simple Average for Groups

    Hello All, Using Crystal XI and Oracle. Ultimate Goal: A call center environment. I would like to calculate the "average" calls we get by weekday, then summarized hourly, then put all of that in a table just like a cross tab. Tried but Failed: A crosstab, It puts up the sums of all days or...

Part and Inventory Search

Back
Top