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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Wrong data from View (CR 8.5, Oracle 8i, ODBC)
The problem is solved. Actually, the date field in the Oracle view was somehow not of standard format, so SQL and CR interpreted the retrieved dates differently.- DocLore
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Wrong data from View (CR 8.5, Oracle 8i, ODBC)
I am using the CR Oracle ODBC driver. But where can I turn on the "Query Returns Results" option?- DocLore
- Post #4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
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...- DocLore
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 2 Data Access
-
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...- DocLore
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 1 Formulas
