Generate Invoice Report On Date Range
Currently have the following table relationship:
Here are my invoice table fields:
I need to generate a report based on "ask user" input of "Start Date" and "End Date" range to inclu...
Forum Discussion
Since your Invoices table is a child to the Project, you can have each Invoice be an individual record (and actually should do this), rather than having a single Invoice record with multiple dates, amounts, etc.
I would suggest changing your Invoice table to have just the following fields:
Once you do this, you can use the Invoice Date field to build your report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
I would suggest changing your Invoice table to have just the following fields:
- Invoice Date
- Invoice #
- Invoice Amount
Once you do this, you can use the Invoice Date field to build your report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendPhilip, since you have an invoice file with dates, you can construct an <ask the user> report to allow the user to select the date range.
You should be able to have two <ask the user> questions.
Where
[invoice date] is on or after <ask the user>
[invoice date] is on or or before <ask the user>
The other way to do this is simply to through the user into a full report and then show the Invoice Date as a Dynamic Filter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You should be able to have two <ask the user> questions.
Where
[invoice date] is on or after <ask the user>
[invoice date] is on or or before <ask the user>
The other way to do this is simply to through the user into a full report and then show the Invoice Date as a Dynamic Filter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------