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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ryanxr
-
Aggregate function for strings
blom, thanks for the info. it is a big dataset so i'll have to figure out something else. cheers. -
Aggregate function for strings
Hi, I'm trying to concatenate string values from the same field in different rows. I'd like to do something similar to the sum function with a group by criteria. For example, if my initial table looks like this: CASE_ID SUMMARY ------- ------- 15001 Text 15002... -
Maximum # of formulas in a CR
Is there a maximum number of formulas that can be created in a CR? I'm using CR 9. Thanks.- ryanxr
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
How to count the nth most frequent value
Hi All, I'm using CR9 and I would like to count the number of occurrences of the nth most frequent value in a given field. I have tried using the following two formulas: “select top 1” formula: if ({TableName.Field} = NthMostFrequent (1, {TableName.Field})) then 1 else 0 “sum top 1” formula...- ryanxr
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
