7 Replies Latest reply on Nov 16, 2009 8:42 AM by raybaudi

    Total Record count

    sly_1

      Title

      Total Record count

      Post

      Hello Again,

       

      Im having an issue and i cant put my finger on it.

       

      I have a main layout called (student enrollment)

      I then created a list report view.

      i would like to add a total record count on the list so i know how many students i have.

      so say i sort the list by enrolled students ( it will give me a count on that )

      i sort by disenrolled students ( it will give me a count on that)

       

      I welcome any ideas and solutions

       

      Thank you

       

      Sly

        • 1. Re: Total Record count
          raybaudi
            

          slyomega wrote:

           

          so say i sort the list by enrolled students ( it will give me a count on that )

          i sort by disenrolled students ( it will give me a count on that)


          I suppose that you was thinking about finding, not sorting.

           

          The function to use is: Get( FoundCount ) and the field must have the storage option setted to UNSTORED

          • 2. Re: Total Record count
            sly_1
              

            Thank you for the response but for some reason its not working. Im not sure what I'm doing wrong as I followed your steps to the letter.

             

             

            Sly

            • 3. Re: Total Record count
              mrvodka
                 Try using a summary field with count. (If you have a primary ID key which you already should have, then use that field to count )
              • 4. Re: Total Record count
                raybaudi
                  

                Did you create a calculation field with calc:

                 

                Get( FoundCount )

                 

                and store option setted to "Do not store..." ?

                • 5. Re: Total Record count
                  sly_1
                    

                  mr_vodka

                   "Try using a summary field with count. (If you have a primary ID key which you already should have, then use that field to count ) "

                   

                  How would I go about this.

                   

                  I have a student ID field that is a unique serial number and I can use that to summarize it.

                   

                  I'm just not on how to do it with summary.

                   

                   

                  thank you

                  • 6. Re: Total Record count
                    mrvodka
                      

                    Create a new summary field in Student Enrollment. There you will see an option for count. It will make you choose from a list of fields. I was thinking that you would have a StudentEnrollmentID field that serves as your primary key. However, if you dont and your studentID field always has a value, then you can use this instead.

                     

                    Once you create the summary field, put it on your reports layout. You should have a subsummary report grouped by "enrollment status". If I understand your structure correctly that is...

                     

                     

                     

                    • 7. Re: Total Record count
                      raybaudi
                        

                      raybaudi wrote:

                       

                      I suppose that you was thinking about finding, not sorting.


                      Was my supposition wrong ?