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!
-
Calculate Hold Time
I have tweaked the suggested code as follows: whileprintingrecords; global StringVar Array UsersArray; global NumberVar Array HoldTimeArray; BooleanVar CurrentUser:=false; numbervar x; If {q_hist.REASON} = "Held" and next({q_hist.ITEM_ID}) = {q_hist.ITEM_ID} then For x := 1 to...- aporras
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Calculate Hold Time
Unfortunalety, it is a lot more likely to have a high number of users than just a couple. But thank you for your input.- aporras
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Calculate Hold Time
The table (which is a part of a workflow database and captures the history for items going through workflow) has the following structure (I am only listing relevant fields): UserID, ItemID, Reason (can be "Held", "Viewed", "Cancelled", "Routed In"...- aporras
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
