Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress text - Underlay sectcion issue 1

Status
Not open for further replies.

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
 
Create a formula {@true} and place it in GH#1b and suppress it:

whileprintingrecords;
booleanvar flag := true;

Then select the text box in the page header->format text->common->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true; //note no colon

-LB
 
I always learn new things each time I post a new question.
I would have never thought of the colon.....

LB,

Your solution worked. STAR for you!!!!

Wishing you and everyone in this forum a VERY HAPPY NEW YEAR!!!!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top