K
Kendra
Hello,
My report is structured like this:
Report Header
Page Header
Jurisdiction Header
Zone Header
Date Header
Detail
Jurisdiction Footer
Page Footer
Report Footer
Within my Jurisdiction header, I currently have a data
summary section that gives the following sums:
Total number of units built =sum([Units])
Total number of exempted units built =sum([ExUnits])
Total amount of fees paid =sum([Fees])
Total amount of fee credits given =sum([Credits])
Total amount of construction credits given =sum
([ConCredits])
Total amount of fee obligation =sum([Obl Fees])
The data is an aggregation of the data provided in the
date section.
The problem with this data is that it doesn't break the
sums into their respective land uses (Single Family,
Multifamily, Industrial, etc..). The date section is in a
format like this:
Date Land Use Units ExUnits Fees
Aug-2003 Single Family 5 5 1500
Aug-2003 MultiFamily 2 0 4700
Aug-2003 Industrial 4 6 5400
How can I make it so that my summary section disaggregates
the data by land use (single family, etc...). The client
is interested in seeing the reports show this, as it is
not very meaningful to say 500 units were built if you
don't know what kind of land use each land use is
associated with.
Thank you for your time. Feel free to email or repost for
clarification,
Kendra
My report is structured like this:
Report Header
Page Header
Jurisdiction Header
Zone Header
Date Header
Detail
Jurisdiction Footer
Page Footer
Report Footer
Within my Jurisdiction header, I currently have a data
summary section that gives the following sums:
Total number of units built =sum([Units])
Total number of exempted units built =sum([ExUnits])
Total amount of fees paid =sum([Fees])
Total amount of fee credits given =sum([Credits])
Total amount of construction credits given =sum
([ConCredits])
Total amount of fee obligation =sum([Obl Fees])
The data is an aggregation of the data provided in the
date section.
The problem with this data is that it doesn't break the
sums into their respective land uses (Single Family,
Multifamily, Industrial, etc..). The date section is in a
format like this:
Date Land Use Units ExUnits Fees
Aug-2003 Single Family 5 5 1500
Aug-2003 MultiFamily 2 0 4700
Aug-2003 Industrial 4 6 5400
How can I make it so that my summary section disaggregates
the data by land use (single family, etc...). The client
is interested in seeing the reports show this, as it is
not very meaningful to say 500 units were built if you
don't know what kind of land use each land use is
associated with.
Thank you for your time. Feel free to email or repost for
clarification,
Kendra