D
DM - NPS
Hopefully I can explain this, I am very new to editing code so the more
details the better.
I have a report called rpt_history which has a sub report called
rpt_Acres_Treated_Sub. For each Area, the report shows assessments (from the
main report) and treatments (from the subreport)
In the details section of the parent report I have a AssessDate and
GrossAcre field. Which occurrs for each assessment
In the Expr1 Footer section of the parent report I have the subreport with a
Date and a PercentTreated field.
What I want to do is have a field in the Detail section that for each
assessment, it compares the date for that assessment to all the dates in the
subreport and if the dates are = it calculates GrossAcres*PercentTreated. If
there are no matching dates, I want to calculate GrossAcres*(average of all
PercenTreated)
details the better.
I have a report called rpt_history which has a sub report called
rpt_Acres_Treated_Sub. For each Area, the report shows assessments (from the
main report) and treatments (from the subreport)
In the details section of the parent report I have a AssessDate and
GrossAcre field. Which occurrs for each assessment
In the Expr1 Footer section of the parent report I have the subreport with a
Date and a PercentTreated field.
What I want to do is have a field in the Detail section that for each
assessment, it compares the date for that assessment to all the dates in the
subreport and if the dates are = it calculates GrossAcres*PercentTreated. If
there are no matching dates, I want to calculate GrossAcres*(average of all
PercenTreated)