September 6, 2008 01:36pm pdt

1. chrismc 160,789
2. mlmcc 136,405
3. PFrog 111,752
4. jgv 105,501
5. rickchild 50,445
6. tshel 45,099
7. RWrigley 39,404
8. Yurich 28,248
9. peter57r 23,185
10. mark_wills 21,650
11. bdreed35 18,900
12. chapmandew 17,060
13. James0... 11,920
14. gdupadhyay 11,850
15. angelIII 11,520
16. nmcdermaid 11,500
17. EugeneZ 10,925
18. CRXIuser... 10,700
19. frodoman 10,060
20. ValentinoV 9,500
21. PedroCGD 9,200
22. wykabryan 8,850
23. analliah 8,450
24. zx10r 7,890
25. WilyGuy 7,500

1. chrismc 378,053
2. simon_kirk 325,252
3. mlmcc 289,649
4. PFrog 230,052
5. Yurich 198,317
6. jgv 105,501
7. frodoman 80,287
8. RWrigley 57,204
9. peter57r 54,647
10. rickchild 50,445
11. tshel 45,099
12. JestersGrind 44,855
13. bdreed35 43,525
14. Hillwaaa 36,822
15. ABaruh 25,650
16. angelIII 23,870
17. dnsvh 22,192
18. mark_wills 21,650
19. rhinok 20,394
20. CRXIuser... 18,694
21. chapmandew 17,060
22. amyhxu 16,580
23. rscowden 16,375
24. nmcdermaid 14,414
25. IdoMillet 14,200

07.24.2008 at 01:54AM PDT, ID: 23591373

	[x] Attachment Details

Help needed to create a report that will count the number of "True" in multiple fields.

Asked by rgn2121 in Crystal Reports Software, SQL Reporting

Tags: Crystal Reports, VB.Net, VS 2005

I am using Crystal reports inside VS 2005 and had questions about a report I am trying to create.
I have pasted some sample data below under "--------Data-----------" and have pasted how I want the results to show under "-----------Results--------------".

I am trying to Group by a field and then count the total number of "True" for each Group and each field in the table.

Right now I have a Group defined and it seems to work fine. I also have tried the create formulas for each of my fields (isMan, isBox, etc.) as such,
if {isBoxed}=True
then 1
else 0
I then did a summary on those formulas, but for each of my fields, the result was the same. If RED mnaufactured was 4 then they were all 4. I have looked at the data and the data is as it should be...can someone help please?
Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

           
           
             --------------DATA------------
ItemID   Color  isManufactured   isBoxed   isShipped   hasArrived
1234     RED        True          False      False       False
1235     Blue       True          True       True        True
1236     Green      False         False      False       False
1237     Red        True          True       False       False
1238     Red        True          True       True        True
1239     Green      True          True       True        False
1230     Blue       True          True       False       False
 
-------------Results----------------
COLOR-         isManufactured   isBoxed   isShipped   hasArrived
RED            
                    3              2          1           1
Blue
                    2              2          1           1
GREEN
                    1              1          1           0

           
         

Keywords: Help needed to create a report that will…

	Title
1	Group and count in Crystal Reports
2	Summary on Formula Field
3	Summary of non-Suppressed Fields
4	When using Count(fld, confld, con…
5	formatting within a formula field
6	Trying to count the instances of 'Lev…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Help needed to create a report that will count the number of "True" in multiple fields.

Asked by rgn2121 in Crystal Reports Software, SQL Reporting

Tags: Crystal Reports, VB.Net, VS 2005

About this solution