2 Replies Latest reply on Dec 21, 2011 1:04 PM by kmcnair1

    Record Numbering a Sub Summary Part

    kmcnair1

      Title

      Record Numbering a Sub Summary Part

      Post

      I need some insight on how to number records on a sub-summary part.  I've been searching for an answer for quite some time so I've decided to become a first time poster to the forum.

      I have a database that tracks projects and their related services.  One project can have many services.  I have a layout that displays records from the services table that are sub summarized by a region and by project name/id.  I'd like to number the projects on the layout.  The @@ function doesn't work because it's numbering the services not the projects listed and since most projects have more than one service, the number is not sequential using @@ . 

      Do I need a count field in the project table that counts the project's name?  I've create a field in the project table that is a summary field that is to be a count of project name.  When I add that field to the sum-summary part, it numbers each project with the number one, so that isn't quite right. 

      Any insight would be greatly appreciated.

        • 1. Re: Record Numbering a Sub Summary Part
          philmodjunk

          Is this the structure of your Report?

          Project 1
             Region 1
                Service 1
                Service 2
                Etc.
             Region 2
             Etc.
          Project 2
          Etc.

          And it's the projects that you want to order sequentially from 1 on this report?

          • 2. Re: Record Numbering a Sub Summary Part
            kmcnair1

            Yes.  I'm trying to number the projects on the report. 

            There is actually 3 sub-summary parts.  I didn't include the 3rd one becasue I wasn't sure it was relevant and I didn't want to add any confusion.

            The report looks this this:

            Delivery Type 1
              Region 1
                 Project 1
                    Service 1
                    Service 2
                    etc.
                 Project 2
                    Service 1
                    Service 2
                    etc

            Region 2
               Project 1
                 Service 1
                 Service 2
                 etc.
              Project 2
                etc.

            Delivery Type 2
              Region 1
                 Project 1
                    Service 1
                    Service 2
                 Project 2
                    Service 1
                    Service 2

              Region 2
                Project 1
             etc.

             

            Since the report shows records from the services table the @@ numbers all the services even though I put the @@ next to the project name field in the project name sub-summary part.  I want to number the projects starting at 1 throughout the report.  No resetting of the count.

             

            Thank you!!!!!