3 Replies Latest reply on Jan 26, 2012 8:38 AM by davidallen

    Sub-Summary issue?

    davidallen

      Hi everyone, thanks for the help for my last issue.

      Guess what, I have another.

       

      I am trying to build a report that will list multipule items for an employee.

      My desired report should look like this:

       

      ---------

      Department A:

      Employee Name, Employee Number, License, License Expiration Date

      License, License Expiraton Date

      etc (if applicable)

       

      Employee Name, Employee Number, License, License Expiration Date

      License, License Expiraton Date

      etc (if applicable)

       

      Department B:

      Employee Name, Employee Number, License, License Expiration Date

      License, License Expiraton Date

      etc (if applicable)

      ----------

       

      The department name, employee name and number are on my main table,

      the License info is in Credentialing Table. The two are related by Employee Number.

       

      Issue:

      Some employees have multipule licenses, some have none.

      I need to have the report show ALL licenses for those that have them, and then sort by date.

       

      I have tried using Sub-Summaries on the layout and in the script, to sort by department and employee,

      but how can I get the Licenses to show up? Another Sub-Summary and sort doesn't do it.

      Only one will show, how can I make that field repeat when there are more to display?

       

      Help Please,

      Thanks

        • 1. Re: Sub-Summary issue?
          karendweaver

          Base your report in the Credentialing Table.  Relate back to the employee table to display employee info, sort by the employee key and then by date - presto!  You will have all of the employees credentials together, sorted by date.

           

          You may not need a subsummary part unless you need totals…  But if you do - you can base the subsummary on the employee key. 

           

          Body parts are credentials - so all the credentials will show no matter how many there are..

           

          warm regards,

           

          Karen Weaver

          Desert Dog Technology, Inc.

          • 2. Re: Sub-Summary issue?
            LyndsayHowarth

            Hi David,

             

            On a layout for Licences table you can create a subsummary part for each of the following:

             

            - MainTable::Department which is sorted by that field

            - MainTable::Employee (Name -so long as the name is unique... or number) ... sorted by the one chosen

            Then the body part will show the licence detail.

             

            When you then sort by MainTable::Department, MainTable::Employee, Licence (date or whatever) the report should show correctly.

             

            HTH

            - Lyndsay

            1 of 1 people found this helpful
            • 3. Re: Sub-Summary issue?
              davidallen

              Thanks Everyone,

              you both pointed out my mistake,

              i was basing the report from the wrong table,

              once i changed that, it worked,

              thanks again.