Show Summary Report on another table

Question

I have a PO table (Purchase Order) where I do a report grouping by "Accounting Code" and showing summaries.

I would like to show this summary table on the related project table and be able to use these number in other calculations.

laurathacker · Answer

In your Account Codes table. You will need summary fields pulling up the totals of the fields you have summarized in your details table to generate a table-report of all Account Codes with those summary values.&nbsp; Note/remember that summary fields will total "everything" in the child table; sometimes you have to write additional criteria to segregate total information by other values, such as date ranges.

russellbeaubien · Answer

So what your saying is I cant link this report but i can recreate it from the account codes table and use it the way I want?

laurathacker · Answer

The summary report you are displaying is the same as a normal table report in your parent Accounting Codes table displaying total-summary fields from the other columns in your report; yes.

russellbeaubien · Answer

Ah! I see now, thank you for the help.

Forum Discussion

Show Summary Report on another table

Related Content

Summary Reports

Moving Fields from One Table to Another

Maximum Summary field not working

Summary report w/multi-select field

Summary report cross tab sort?