Create Report from 2 Tablets Parent to Child
I need help creating a report from 2 related tables. Budget and Budget Amendments.
The report i need would be a basic bar graph that will show Budgets Executed and Budget Amendments Executed over the course of 2 fiscal years.
Currently, a budget can have several amendments, each of those amendments can be executed just like a budget. The bar graph I need will show a monthly view of the number of budgets that have been executed and the amount of amendments total that have been executed.
I've created a Summary field that's is all budget amendments where the execution date is not blank but putting this in a report doesn't work right because it doesn't actually get a date from the amendments table. Can anyone help me with getting this report to work?
I thought about doing this from the child table but I'm confused on how that would work. any help would be great.
The report i need would be a basic bar graph that will show Budgets Executed and Budget Amendments Executed over the course of 2 fiscal years.
Currently, a budget can have several amendments, each of those amendments can be executed just like a budget. The bar graph I need will show a monthly view of the number of budgets that have been executed and the amount of amendments total that have been executed.
I've created a Summary field that's is all budget amendments where the execution date is not blank but putting this in a report doesn't work right because it doesn't actually get a date from the amendments table. Can anyone help me with getting this report to work?
I thought about doing this from the child table but I'm confused on how that would work. any help would be great.
