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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Total Groups that has a certian field populated in the group
I got it, When i setup the running total i set it to evaluate at @line# and for some odd reason it would not count the first line of random groups. I set a formula on evalute to @line# > 0.00 and it worked not sure why but so far it looks like its working. Thanks lbass!- Jell0b0y
- Post #8
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Total Groups that has a certian field populated in the group
Your correct lbass it should have been a 2. For some reason it is not adding the first line of every other group simmilar to below (Carton ID) (CC) (CT) (Qty) (line#) 00000111515 00000111515 VA LB 2.00 1.00 00000111515 VA TX 2.00 1.00 00000111515 VA LB...- Jell0b0y
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Total Groups that has a certian field populated in the group
I found and issue with my logic and it causing my totals to be doubled. The forumla that lbass gave me does exactly what i wanted by not counting the groups that doesn't contain VA. I found out that the data is on my report twice and i can only count it once. The duplicate records are the one...- Jell0b0y
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Total Groups that has a certian field populated in the group
That is exactly what i needed lbass thank you very much!- Jell0b0y
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Total Groups that has a certian field populated in the group
Total certian Groups I am trying to only total a group that has atleast one field that is populated with a sting of VA. I have it Grouped by Carton ID and the VA and TX is a Code and type of the carton. I need to know the total units in a carton if a VA is in the group. I have tried...- Jell0b0y
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Rows to Colums
Hello, I am trying to make a field in that displays in rows to show in colums. The field is "IDCASE00".IDLTYP" it has three entries OSS, RSV and TRL. When I run the SQL below I get the following results SKUA 100 RSV SKUA 125 OSS SKUA 200 TRL but I need it to be like the following SKUA...
