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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Results from SUM Function Doubled
I'm using Crystal SQL Designer to create my SQL. This seems to be working, but on some records the result of the SUM function is being doubled - but not all records. I've checked the data and it all looks fine, so I don't quite understand what's going on. Here's my SQL: SELECT DISTINCT...- madaw
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 1 Formulas
-
SQL Expression Editor
I'm new to crystal reports and I'm having problems with the syntax of the SQL Expression Editor. I using 3 tables. The main table(A) has most of the info that I want to display. Table(B) and Table(C) both have amounts I want to display on the detail line based on the unique id from Table(A)...- madaw
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
