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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Eliminate Nulls in Grouping
I have a field that I need to group on that frequently has nulls. The data source is a SQL stored procedure. I created the following formula. IF {sp_ProductionSchedule;1.job_no} = "1" THEN "LINE 1" ELSE IF {sp_ProductionSchedule;1.job_no} = "2" THEN...- marksimm
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How do I SumIf in a crosstab report??????
I am using Crystal 7. I have a crosstab report that has customer and year in the row area, a formula which translates a period number(1,2,etc..) to a label(Jul,Aug,etc..) in the column area, and the sales quantity in the summarized field. The report summarizes all months in the Total column...- marksimm
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 1 Formulas
