Adding a custom header in cross tab report? 1

[jack91]

Hi,

Is there a way to add a custom header to a cross tab report?

I have:

column 1 column 2 column 3
row 1
row 2
row 3

What I would like to do is put a header name on top of row 1.I put a box object and typed in a name. -- This works fine for page 1, but for page 2 onwards the custom object box does not repeat.

Is there a way around this?

Thanks
Jk

 

[jack91]

I am using crystal version 10.

TIA
Jk

 

[ianoctdec]

Hi,

Try to insert another section for the group above the crosstab, set it to 'Underlay following sections', and put your label in that section.
The group section should also be set to <show header on each page>.

Dana

 

[jack91]

you mean create a new section in "section expert"?

 

[lbass]

You could create a formula like this:

whilereadingrecords;
"Row1 Label"

Add this as Row #1 in the crosstab expert. This will print to the left of the rows. I often then format the text to rotate 90 degrees, center it, and minimize the width of this label.

-LB

 

[jack91]

Lb,

I want the new row/fake row to be printed on *top of the row - or to the left of the columns , not to the left of the rows.

thanks
Jk

 

[jack91]

column 1 column 2 column 3
row 1
row 2
row 3

see the imaginary box that can form on top of row 1 and to the left of column 1?
This is where I need to denoted the header which is meant for the rows beneath.

Thanks
jk

 

[jack91]

not denote byt rather *place

 

[lbass]

I understood what you wanted, but was offering another alternative which is easier to achieve.

-LB

 

[jack91]

Lb, I will use your suggestion as a backup. But am open to suggestions to my OP question

TIA as usual
jk

 

[lbass]

In what report section is your crosstab located?

-LB

 

[jack91]

lB,

cross tab is located in the "Report header e".

This is then followed by a page header with many columns for details headers*and then followed by a details report with actual field values in the details section.

Thanks
Jk

 

[lbass]

For one thing, if you are referring to normal pages (not virtual pages to the right), you will not be able to do this unless you move the crosstab into a group header as per the suggestion in one of your other threads. If you feel you cannot do this, please explain why.

-LB

 

[jack91]

hi Lb,

The reason why i put the cross tab in the group header is to make a summary for the report. This followed by the details section makes it perfect for my purpose.

Now if I were to put this cross tab in the group section it will be * preceded by the details section -- which does not really help.Also I dont want a summary cross tab.for each group.

All i want is to place a small header on top of the row so viewers will know what the rows below represent. This is easily represented in MS excel (I believe also in CR 2008).

If i am not being clear please let me know, I can clarify further.

Thanks
Jk

 

[lbass]

This was explained to you in the other thread. The new outer group contains all records, so the summaries in the crosstab will still be for all records. You would place the crosstab in the group HEADER, NOT the group footer, and therefore details will appear AFTER the crosstab per your requirement. Please try this.

-LB

 

[jack91]

Fantastic that worked!
BUT something else causes an issue when i do this.

page header a --> which is the report title.
page header b --> is column name titles

How do i have the page header "b" *NOT to appear on top of the (fake)group header 1. **BUT still have it appear for all *other pages -- like details pages etc?.

Thanks
Jk

 

[jack91]

** continuing my last comment.

Is there a way to suppress page header b when cross tab (Group header 1) prints?

Thanks
Jk

 

[chelseatech]

You could create a formula that contains the heading you want. As it's a constant you might need to make it "WhileReadingRecords".

Then make that the first Column field to group by.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[lbass]

Create two formulas:

//{@true} to be placed in the report header and suppressed:
whileprintingrecords;
booleanvar flag := true;

//{@false} to be placed in the Group #2 header section (if it exists) or the detail section:
whileprintingrecords;
booleanvar flag := false;

Then go into the section expert->page header_b->suppress->x+2 and enter:
whileprintingrecords;
booleanvar flag;
flag = true;//note no colon

This assumes that you have "New page after" set on GH1.

-LB

 

[jack91]

When i create a formula and type

whileprintingrecords;
booleanvar flag := true;


I get:

booleanvar flag:= true; --> "the remaining text does not appear to be part of the formula".

please advise

Thanks
Jk