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!
-
Counting a single instance of a one to many relationship?
Thanks lbass Worked for me too! regards- rockysewl
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Counting a single instance of a one to many relationship?
lbass Thank you for your quick response. Your answer gives me the completed cases. I actually want to count a single instance of those cases which do not have a "D*" Audit Point (PointCode not like "D*") however there may be one or more of audit point records for each case...- rockysewl
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Counting a single instance of a one to many relationship?
Hi I have 2 tables from a workflow audit database joined in an optional one to many relationship. The resulting dataset from the query based on a date range returns: Tbl-1 Tbl-2 Case1/StartDate/CancelledDate - PointCode1/Date1 Case1/StartDate/CancelledDate -...- rockysewl
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
How to write cumulative statistics
I assume this data is from a call centre monitoring system where primary data collected would be something like call_in (datetime), call_answered (datetime), etc. To total all the call details into a summary report that shows data specific to a date range and overall - you may use 2 methods...- rockysewl
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
