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!
-
Conditional Count and Sum Formulas
Hi Ken, Thanks for the reply. I actually found the problem, solved it and it created another problem. The problem was nested in a little deep into the report. All is solved and working fine now. Thanks again!- cbauer357
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Conditional Count and Sum Formulas
Ken, Thanks for your reply. I tried your idea for the first formula, but it did not work. The other formulas in the additional fields are summing so, it would not work there. Any other suggestions on how to troubleshoot this? I know the SQL is correct and is pulling the correct information...- cbauer357
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Conditional Count and Sum Formulas
I have a problem with some conditional formulas. I am using Crystal 8 and SQL Stored Procedures. The SQL Stored Procedure brings back all of the data needed. I have three formulas as follows: If {spRptSubmittalsActivity;1.STATUS_ID} = 2 then Count({spRptSubmittalsActivity;1.NEED_ID}...- cbauer357
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
