2 Replies Latest reply on Mar 18, 2014 9:55 PM by PhilHarper

    combining table into one report

    hwachai

      Title

      combining table into one report

      Post

           

                projects A ----- task table A ( task title, user, status) 

           

                                         task table B ( task title, user, status)

           

                                         task table C ( task title, user, status)

           

                projects B ----- task table A ( task title, user, status) 

           

                                         task table B ( task title, user, status)

           

                                         task table C ( task title, user, status)

           

                ----------------------------------------------------------------------------

           

                I have main projects table, each project create different task table base on current project id. And each task table have its own task list....

           

                now my problem is to create a report showing the project with all the task.... like combining the task table into 1 list

           

                ---------------------------------------------------------------------------

           

                project A

           

                title   l   user    l   status  (sort by status)

           

                project B

           

                title   l   user    l   status (sort by status)

           

                 

           

                I m new on using filemaker pro 12. I recontructing the database input for my department next year, to replace current database structure that done by previous manager... really appreciate your help.

           

                 

           

                thanks

           

                hwachai

           

                 

           -----------------------------------------------------------------------------------------------------------------

           I think my explanation not clear enough, here is more detail information.... each task table have its own drop down menu and other specified fields.

            

      projects A -----  task table A ( task title - drop down menu, user, status, material, size) 

                                      task table B ( task title - drop down menu , user, status, contact, function)

                                      task table C ( task title - drop down menu, user, status, layout )

                                      task table D ( task title - drop down menu, user, status, duration, video size )

            

      projects B -----  task table A ( task title - drop down menu, user, status, material, size) 

                                      task table B ( task title - drop down menu, user, status)

                                      task table C ( task title - drop down menu, user, status, layout )

                                      task table D ( task title - drop down menu, user, status, duration, video size )

            

           The reason to separate all my table because, if I only create one record with so many details will be quite confusing.... I have total 9 task tables, each table have more than 15 tasks.

            

           Now my people need one report to keep track all the tasks for each project like below : -

            

      project A

                  title          l      user       l        status  (sort by status)      <---- i only need this 3 field

           -      Task AAA           Jimmy               in progress       (from table task A)

           -      Task BBB           Jimmy               in progress       (from table task A)

           -      Task CCC           Henry               in progress      (from table task B)

           -      Task DDD           Sandy              in progress       (from table task B)

           -      Task EEE           Victor               in progress       (from table task C)

           -      Task AAA           Sam                 in progress       (from table task C)

           -      Task BBB           Victor               in progress       (from table task C)

           -      Task CCC           Siva                in progress       (from table task D)

           -      Task DDD           Tony               in progress       (from table task D)

           -      Task EEE           Jimmy               in progress      (from table task D)

            

      project B

           -      Task AAA           Jimmy               in progress       (from table task A)

           -      Task BBB           Jimmy               in progress       (from table task A)

           -      Task CCC           Henry               in progress      (from table task B)

           -      Task DDD           Sandy              in progress       (from table task B)

           -      Task EEE           Victor               in progress       (from table task C)

           -      Task AAA           Sam                 in progress       (from table task C)

           -      Task BBB           Victor               in progress       (from table task C)

           -      Task CCC           Siva                in progress       (from table task D)

           -      Task DDD           Tony               in progress       (from table task D)

           -      Task EEE           Jimmy               in progress      (from table task D)

            

      ( click on the task title with direct to task detail )

           Please, need help on this. Combine the info into one table? get value from each table? can it be done using report / calculation by name?

            

           Thanks!!!

           hwachai                     

        • 1. Re: combining table into one report
          philmodjunk

               Your use of "table" here confuses things a bit.

               I think that you have two tables. I'll call them "Projects" and "Tasks".

               It appears that you have them linked in a relationship such as:

               Projects----<Tasks

               Projects::__pkProjectID = Tasks::_fkProjectID

               The field names may be different but the one to many relationship shown would match the examples you've posted

               If that's correct, you can set up a list view layout based on Tasks and include fields from Projects in a Sub Summary Layout part "when sorted by __pkProjectID" and set it to print above the body.

               This is a very simple summary report. To learn more about summary reports, see this thread: Creating Filemaker Pro summary reports--Tutorial

          • 2. Re: combining table into one report
            PhilHarper

                 @ PhilModJunk

            The problem with this is that if the project has no task linked, the project will not be listed. I have this same problem with Task and sub task reports (two tables, related) I want to create a report showing Tasks and sub tasks but many of my tasks don't have subtasks. I can't see how to create a report across two tables.

            I creating a Merged table the only way to do this, if so any pointers on how to automate that?