I create my databases on A4V7 and report them on A5V7.
I want to report the batting averages for each player on my girls' softball
team and the position(s) she plays.
The only sections in my report are a Report Header and Detail section.
The Detail section includes the player's Name, the Positions she plays and
her Batting Average.
Hits and AtBats are numeric fields recorded in A4. The Batting Average is calculated in
the A5 report as Hits/AtBats
I set the Order of the report to Batting Average in Descending Order (highest
batting average to the lowest).
The Filter is is a flag in each player record that shows she is a member of this year's team.
The report I get (attached) is not exactly what I hoped for. The records do not appear
in descending order ot Batting Average, as players with zero batting averages are
sandwiched in between players with positive batting averages.
I had hoped that those with positive numbers would be reported first, in descending
order, and those with zero batting averages coming last in the report.
I have tried to create a Group in the report based on the calculated field Batting
Average. But A5 says it doesn�t recognize that field.
I hope this is a simple and obvious fix that just got by me. I will appreciate
any help here.
I want to report the batting averages for each player on my girls' softball
team and the position(s) she plays.
The only sections in my report are a Report Header and Detail section.
The Detail section includes the player's Name, the Positions she plays and
her Batting Average.
Hits and AtBats are numeric fields recorded in A4. The Batting Average is calculated in
the A5 report as Hits/AtBats
I set the Order of the report to Batting Average in Descending Order (highest
batting average to the lowest).
The Filter is is a flag in each player record that shows she is a member of this year's team.
The report I get (attached) is not exactly what I hoped for. The records do not appear
in descending order ot Batting Average, as players with zero batting averages are
sandwiched in between players with positive batting averages.
I had hoped that those with positive numbers would be reported first, in descending
order, and those with zero batting averages coming last in the report.
I have tried to create a Group in the report based on the calculated field Batting
Average. But A5 says it doesn�t recognize that field.
I hope this is a simple and obvious fix that just got by me. I will appreciate
any help here.
Comment