Columnar Subreports

[TimT]

I need to create a columnar report and subreport that would have the same
columns.
Main report:
Rows: Total Income, Total Expenses, Book Income, Taxable Income, Tax etc...
Columns: Divisions

Subreport:
Rows: Expense Details (this is a variable because some division might only
have one expense and others might have all)
Columns: Divisions

Issue: Not every division will have the all the same expense details but I
need the formatting to remain consistant so I can set up a report to show all
divisions income activity.

 

[Duane Hookom]

We don't know anything about your tables. I expect you can use crosstab
queries where you have entered all the possible Divisions in the Column
Headings property.