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 Westi 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: kunzi
  • Order by date
  1. kunzi

    Distinct Average in Crystal Report?

    I have some duplicate records in my record due to the complicated table structures, and checking "Selecting Distinct Records" would only filter part of them. So now my report for one user is like this: Record Is Valid? a Yes a No b Yes c...
  2. kunzi

    Datediff in Oracle SQL?

    Table_1 left outer joins Table_2.
  3. kunzi

    Datediff in Oracle SQL?

    Suppose I have two SQL expressions now: 1. exp1 select date_1 from table_1 where blah blah 2. exp2 Select date_2 from table_2 where blah blah How can I get the date difference in hours between the two dates returned above? I guess simply exp1-exp2 won't work... Thanks!
  4. kunzi

    Weird SQL expression using Table Alias

    Hi all, I'm writing a SQL expression which is expected to return a date for each order. So I wrote one and drag it into Detail section: (SELECT Max(Coalesce("ORDER_SIGNED_MED"."CSGN_SIGNED_TIME","ORDER_SIGNED_MED"."VERB_SIGNED_TIME"...
  5. kunzi

    How to sort by calculated formula?

    Hi all, I'm using Crystal 2008 to create a report. The reports has one-level grouping by user name. Each user may have multiple tasks and each task has a duration in hours if it is complete. The details about those tasks and durations will be shown in drill-down. In the Preview tab, for each...

Part and Inventory Search

Back
Top