I have an application with 3 tables (Programs, Project, Milestones). Programs table is master for all others.
Can I build a report (Not a Form) in/at the Program table, that displays the Milestones (not a link but actual Milestone Name, Status from the Milestone table) for that related Program?
If you don't mind your Program information being repeated on the report you can add the fields that you would like to report on as lookup fields on the Milestones table, then create the report in the Milestones table. I know you mentioned that you wanted to build this in the Program table, but figured I would give you an easy solution. The only other way to accomplish this (that I know of) is by writing a script that pulls the necessary data and displays it the way you want it.
Thank you!! I have created a report at the Milestone table and it does give me what I want, but it doesn't look "pretty". As you stated, the Program information get repeated and It's almost out of control.
Do you know how I would write such a script, or where I might get information on how to do this?
Thank you!!
If you "Group by" the Program, then you don't need to show it as a column in the report. You can have multiple groupings if you want to show multiple Program fields and don't want columns for them. If you want to control the formatting a little more of the "Grouping", you can create a formula text field that combines the Program fields in the layout you want and then can use that formula as your "Grouping".
Hope that helps, Keira
Here is an example of what I'd like to accomplish. Detail information about the Milestone, would come from the subordinate Milestone table, but the report would be at the Master Program table to ensure correct data at the Program level is brought in.
If you want to try to do this in QuickBase, without needing a script, my suggestion was to use the report you have created in the Milestones table, but Customize the Report:
(1) In the "Sorting/Grouping" section of the report builder, select "Custom sorting/grouping" and then select "Sort and Group from low to high by" Program Name. You can hover over that first grouping and use the green plus sign to add another one below it. On the new line select "Sort and Group from..." "Accoutable". Add grouping lines for Status and Comments.
(2) Remove the 4 Program fields that you "Grouped By" from "Your Columns" in the "Columns to Display" section of the report.
Note: This will only work well if you have Milestones for every Program. If you want to include Programs that do not have any Milestones, they would not appear in this report.
Hope that helps, Keira
