Advertisement

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
[+][-]07.24.2008 at 05:35AM PDT, ID: 22078359

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.24.2008 at 09:37AM PDT, ID: 22081023

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Crystal Reports Software, SQL Reporting
Tags: Crystal Reports, VB.Net, VS 2005
Sign Up Now!
Solution Provided By: mlmcc
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.24.2008 at 02:39PM PDT, ID: 22083804

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 07:25PM PDT, ID: 22085494

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 07:55PM PDT, ID: 22085651

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 08:15PM PDT, ID: 22085753

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 08:18PM PDT, ID: 22085760

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 08:19PM PDT, ID: 22085766

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 09:18PM PDT, ID: 22085947

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.24.2008 at 10:22PM PDT, ID: 22086149

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 01:06AM PDT, ID: 22086718

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 07:23PM PDT, ID: 22093495

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628