Report" as a report variable

Victor Warner Wed, 29 Jul 2009 03:57:06 -0700

Robert,

Thank you for the information, problem solved.

I am very grateful.

Victor

Robert Pollard wrote:

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
  

_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Re: [Dataperf] How to duplicate "number of records in Section/Page/Report" as a report variable

Reply via email to