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 derfloh 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: DocLore
  • Content: Threads
  • Order by date
  1. DocLore

    Wrong data from View (CR 8.5, Oracle 8i, ODBC)

    Dear all, I have a problem with date data from an Oracle view in a CR 8.5 report: a wrong date is displayed in the report, although SQL (TOAD, SQL*Plus) displays the correct data. The view uses a decode function that selects the latest date of two different fields. CR seems to calculate this...
  2. DocLore

    In a Cross Tab : I need COUNT and not DISTINCT COUNT. How???

    Hi all, I use a cross tab to count A's (row) per B's (column): B1 B2 B3 Total A1 1 2 4 7 A2 2 3 2 7 Total 3 5 6 14 B1, B2, B3 are groups with lots of b's in each group. In each b, I can have a lot of instances of A1, A2. However...

Part and Inventory Search

Back
Top