A report joins order headers and lines. Each order total is repeated for every line, then summed. What should be corrected?

1. The database character set
2. The query's grain and aggregation to avoid repeated header totals
3. The application's primary color
4. The session timeout value