Bar chart with complicated summary field
Hi, I need add a bar chart report to a system and I having trouble with one of the items. I have a table, let's call it YearMonthRevenueByContract that has the Year, Month, reference to a Contract ...
Forum Discussion
DonLarson
6 years agoQrew Elite
Luther,
Does this describe your application?
Your reports could be made at least two ways.
You can pass Related Contract Type to the Contract Revenue table and make the reports there. This will let you get the dollars by period and Contract Type. If you add up the number of Contract Revenue records that can easily exceed the number of Contracts
The other option is to create Summary fields in the Contract table for the Revenue where you use the Date in the Contract Revenue table as a filter. For example you could create
Revenue Month to Date
Revenue Year to Date
Now those dollars can be used in the reports built in the Contracts table and the number of Contracts will be equal to or greater than the number of entries in the report.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Does this describe your application?
Your reports could be made at least two ways.
You can pass Related Contract Type to the Contract Revenue table and make the reports there. This will let you get the dollars by period and Contract Type. If you add up the number of Contract Revenue records that can easily exceed the number of Contracts
The other option is to create Summary fields in the Contract table for the Revenue where you use the Date in the Contract Revenue table as a filter. For example you could create
Revenue Month to Date
Revenue Year to Date
Now those dollars can be used in the reports built in the Contracts table and the number of Contracts will be equal to or greater than the number of entries in the report.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------