ind123p
Programmer
- Sep 28, 2005
- 62
I am using CR XI.
I have a crosstab in Section GH1a and 2nd Crosstab in GH1b. In the Page Header I have two text boxes (Client and Staff) which I am trying to use as row headers.
In the Page Header I have checked underlaying the sections.
Client Staff Jan Feb Total
Hours Invoice Hours Invoice Hours Invoice
Staff P 5 $100 2 $50 7 $150
Staff Q 2 $50 3 $150 5 $200
Staff R 3 $150 4 $140 7 $290
Client A 10 $300 9 $340 19 $640
Staff P 5 $100 2 $50 7 $150
Staff Q 2 $50 4 $110 6 $160
Staff R 3 $150 4 $140 7 $290
Client B 10 $300 10 $300 20 $600
In GH1b I have the following cross tab
Total for P 5 $100 2 $50 7 $150
Total for Q 2 $50 3 $150 5 $200
Total for R 3 $150 4 $140 7 $290
I had to add this second cross tab to sum up for each Staff member.
My problem:
Client Staff appears in GH1b too which I do not want.. I want to suppress Client & Staff when section is GH1b and display when GH1a.
Is this possible ? HELP
I have a crosstab in Section GH1a and 2nd Crosstab in GH1b. In the Page Header I have two text boxes (Client and Staff) which I am trying to use as row headers.
In the Page Header I have checked underlaying the sections.
Client Staff Jan Feb Total
Hours Invoice Hours Invoice Hours Invoice
Staff P 5 $100 2 $50 7 $150
Staff Q 2 $50 3 $150 5 $200
Staff R 3 $150 4 $140 7 $290
Client A 10 $300 9 $340 19 $640
Staff P 5 $100 2 $50 7 $150
Staff Q 2 $50 4 $110 6 $160
Staff R 3 $150 4 $140 7 $290
Client B 10 $300 10 $300 20 $600
In GH1b I have the following cross tab
Total for P 5 $100 2 $50 7 $150
Total for Q 2 $50 3 $150 5 $200
Total for R 3 $150 4 $140 7 $290
I had to add this second cross tab to sum up for each Staff member.
My problem:
Client Staff appears in GH1b too which I do not want.. I want to suppress Client & Staff when section is GH1b and display when GH1a.
Is this possible ? HELP