PO Spend Report - Filter data by date
Hi everyone, I have a relationship with Company<Purchase Orders I am summarizing a numeric field on the Company Table from the Purchase Orders Table for Total Committed Costs This way I can s...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIvan
I see two alternatives.
1. Create an <ask the user> Report on the PO table and make a summary report there, by company.
2. Create a single Record in a single table with Record ID = 1 and have the date range the. Make a relationship to all POs. Make a summary totals by company using that global date filter. Put the embedded report of companies as a Report Link field on the single global date record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I see two alternatives.
1. Create an <ask the user> Report on the PO table and make a summary report there, by company.
2. Create a single Record in a single table with Record ID = 1 and have the date range the. Make a relationship to all POs. Make a summary totals by company using that global date filter. Put the embedded report of companies as a Report Link field on the single global date record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------