Forum Discussion

JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
6 years ago

Combining multiple Pages to One for a Single Report

I have a table in which 100+ projects reside. I have another table of phases that are connected to the projects (sometimes multiple phases to a single project). I also have a table of support tickets ...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You should be able to do this with your existing relationships.

So you have 

Project < Phases
Project < Support Tickets

Can you say in words what the report is that you want?

I want a report of all ......... where ...... is true

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
JaimeStrawderma's avatar
JaimeStrawderma
Qrew Cadet
6 years ago
Hi Mark,

Thanks for your help. I do have relationships as you have listed. Basically each project will have a status of open or closed. The phases are linked to the project name and have statuses of open or closed. The support tickets are linked to the project name and also have statuses of open or closed. A report is being pulled from each table, project, phase, and support ticket based on the open and closed status to audit continuity. My thinking was that I add all of the tables into another table and pull just one report from the new table. Are you saying I can create a report based on the three separate tables?

------------------------------
Jaime Jaime
------------------------------
  • JaimeStrawderma's avatar
    JaimeStrawderma
    Qrew Cadet
    6 years ago
    To be more clear, I need a report that shows all of the projects, all of the phases, and all of the support tickets and what the status is of each one.

    ------------------------------
    Jaime Jaime
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      What about if we can easily do a report of all the support tickets, listing columns for the Project and its status as well as each Phase and it's status.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JaimeStrawderma's avatar
        JaimeStrawderma
        Qrew Cadet
        6 years ago
        That sounds like just what I need.

        ------------------------------
        Jaime Jaime
        ------------------------------