4 Replies Latest reply on Nov 20, 2009 9:36 AM by philmodjunk

    Checkbox set and subsummary

    perrine

      Title

      Checkbox set and subsummary

      Post

      The checkbox set allows multiple value for a field.

      I would like to run a subsummary report on these multiple values.

      For exemple :

      My records are different issues, a ,b ,c .

       

      They can be characterized by their economic sector : agriculture, industry, business, transport. (it will constitute a checkboxset).

      For Issue A I will check agriculture and business

      For issue B I will check agriculture and Indutry

       

      and then I would like a report that releases:

       

      Agriculture

      IssueA

      Issue B

       

      Business

      Issue A

       

      Industry

      Issue B..

       

      But I can't manage to achieve that... It looks that the subsummary reports do not handle the multiple values for a checkbox set

       

      Do yo have an idea?

       

      Thank you for your help

       

      Perrine 

       

       

       

       

       

        • 1. Re: Checkbox set and subsummary
          comment_1
             No, this cannot be done by a sub-summary report, because you don't have enough records to produce such report. You need to create a related record in another table for each association of an issue with a sector, and produce your report from there.
          • 2. Re: Checkbox set and subsummary
            TSGal

            perrine:

             

            Thank you for your post.

             

            The reply from "comment" is correct, but there is another way to achieve the same results, although it is not the ideal way.

             

            You can create calculation fields for each of your checkbox entries, and then use a summary field to add up each of those checkbox fields.  Using your example, you would have three calculation fields:

             

            FieldA = If (PatternCount ( checkboxfield ; "FieldA" ) > 0 ; 1 ; 0 )

            FieldB = If (PatternCount ( checkboxfield ; "FieldB" ) > 0 ; 1 ; 0 )

            FieldC = If (PatternCount ( checkboxfield ; "FieldC" ) > 0 ; 1 ; 0 )

             

            Then, create a Summary field for each of the calculation fields.  That is,

             

            Total FieldA = Total of FieldA

            Total FieldB = Total of FieldB

            Total FieldC = Total of FieldC

             

            This will get you the desired results, but this does add a lot of extra fields to your table, especially if you have a Checkbox field with MANY options.

             

            TSGal

            FileMaker, Inc. 

            • 3. Re: Checkbox set and subsummary
              imgaryshap
                

              So how did the layout for the subsummary report work.

               

              i'm having the same issue and am able to keep an accurate count, but when I run a report based on the values inside the checkbox list, any item that has more than one box checked does not duplicate.   So using the initial example:

               

              If Issue A has agriculture and business checked off

              and Issue B has agriculture and Industry checked off, the ideal report would look like this when sorting by checkbox field:

               

              Agriculture

              IssueA

              Issue B

               

              Business

              Issue A

               

              Industry

              Issue B

               

               

              However when I'm running mine, if the record has more than one value checked, the value only shows up in the first.  so my report is looking like this:

               

               

              Agriculture

              IssueA

              Issue B

               

              Business

               

               

              Industry

               

              • 4. Re: Checkbox set and subsummary
                philmodjunk
                  

                The following thread appears to discuss exactly the same problem. Perhaps the suggested solution there may serve:

                 

                problems with checkbox sorts