Victor You need to set rv100 to 0 in the two-level header, and not in the first page header.
Robert On Tue, Jul 28, 2009 at 2:56 AM, Victor Warner <[email protected]> wrote: > Brian, > > Thank you for the reply. I have already tried what you suggested but I > am missing something, and have tried various options and I feel very lost! > > These are the steps I used to create the report: > > 1. The report contains fields for names of client and the type of > problem they are facing (consumer law, employment law, landlord and > tenant and so on) among others > > 2. There is an index with the type of problem as the first field in the > index > > 3. The report has a two level report created on the type of problem > > 4. In the two level footer the type of problem field is added and I used > Ctrl-F7, 5 to get a total for the group > > 5. Running the report based on 1 to 4, produces for each type of problem > the total (count) number of clients who asked for help, eg > > consumer law 3 > employment law 4 > landlord and tenant 4 > > 6. To get the total (count) number of clients via a report variable the > following was added to the report > > (a) First page header: Added report variable 100 containing 0 > (b) Report body: Added report variable 100 containing rv100 + 1 > (c) Two level footer: Printed report variable 100 > > 7. Adding the elements described in 6 produces the following: > > consumer law 3 3 <-----the last number being the printed > result for rv100 > employment law 4 7 > landlord and tenant 4 11 > > > I have tried so many variations but I am getting nowhere. Help with this > would be really appreciated. > > Victor Warner. > > > Brian Hancock wrote: > > Hi Victor, > > > > Create a Report Variable, and in the report of the record being processed > > increment it with the formula RVx + 1. > > > > Bye > > Brian > > > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Victor Warner > > Sent: Monday, 27 July 2009 6:03 PM > > To: [email protected] > > Subject: [Dataperf] How to duplicate "number of records in > > Section/Page/Report" as a report variable > > > > I would very grateful to know how it is possible in to get totals for > > the following: > > > > 1. In a two level report, for each group I just select in Ctrl-F7, 5 to > > get a total for the group. > > 2. But I cannot "use" that total elsewhere. > > 3. Is it possible to create a total for each group with Report Variables > > and how would do it? > > > > Victor Warner. > > _______________________________________________ > > Dataperf mailing list > > [email protected] > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > _______________________________________________ > > Dataperf mailing list > > [email protected] > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > -- Robert Pollard Information Habitat: Where Information Lives http://habitat.igc.org/ [email protected] 1.212.864.3156 http://friendfeed.com/climatechange3
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
