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

 

[lbass]

Please paste the entire formula into this thread.

-LB

 

[jack91]

whileprintingrecords;
booleanvar flag := true;

 

[lbass]

Make sure the formula is set to Crystal Syntax, not Basic Syntax. Look in the toolbar above the formula area.

-LB

 

[jack91]

I will have to get back to you on this early mon morning.
I am enroute to leaving nyc for the weekend!

Have a wonderful weekend urself.

Regards,
Jk

 

[jack91]

Lb: For the formula suggestions to work I have to make sure I tell you the exact breakdown of the sections in the report.

RH a --> not being used now
RH b --> not being used now
RH c --> Bar chart being used in this section
RH d --> not being used now
RH e --> not being used now

PH a --> Title of the report and 4-5 parameter listings
PH b --> Titles of the columns
PH c --> not suppressed and being used for spacing on report
PH d --> suppressed and not being used

GH 1 --> fake group header-> cross tab report is placed here
GH 2 --> suppressed
GH 3 --> using underlaying of this section.

GF 2 and 1 suppressed as well as report footer.

With this what changes do i need to make with the formula suggestions you have given earlier.

Thanks Lb,
Regards,
Jk

 

[lbass]

The suggestion should work as is.

-LB

 

[jack91]

Lb,

I followed your suggestion but I found no changes.

regards,
jk

 

[jack91]

It worked!!

but one small issue.

When the details page starts, the first page does not show the column header while page 2 onwards its ok.

please advise
regards,
Jk

 

[jack91]

I played around it with it. It totally works!!

U Da BEST!!!

THANKS
Jk
PS: I have no choice but to re-consider your alternative for the original Question of how to add a header for the rows.

 

[jack91]

inoctdec:

How do i <show header on each page> ?

Thanks
Jk

 

[jack91]

inoctdec:/ Lb

Regarding my reply before this post.

I created a new group header 1 a. Put the header and underlayed it like inoctdec suggested.

I then did:
whileprintingrecords;
booleanvar flag;
flag = false;//note no colon

and it seems to work.

Please correct me if I am doing it wrong.

Thanks
Jk

 

[jack91]

Actually I put it in page header e - new one !

Thanks
guys

 

[jack91]

Ianoctdec: 2 questions regarding placement of headers above the cross tab:

Regarding your reply: How do i <show header on each page> ?

and secondly:

If I followed your suggestion, and if the cross -tab were to have new columns in the future will there be an issue of placement of another section for the group above the crosstab?

Thanks
Jk

 

[jack91]

LB: one question for you on your suggestion for suppressing and using the two formulas true/false flags etc.

I now want 2 different page headers.

One page header which is there now -- works fine for the page headers, -- BUT it is not suitable to have it also placed as a header where the cross tab report is there ------------------ because when the report evaluates the parameters (a bunch of parameters are placed in the page HEADER so when -)

anyways,

basically, is it possible to have 2 page headers, one header shows up for the cross tab report which was placed in the GH1.

and the other header shows up for the details section of the report.

I am presently trying to figure this out myself but would appreciate your input one more time on this.

Thanks
Jk

 

[jack91]

LB:
* regarding my last reply.

is it possible to have 2 page headers, one header shows up for the cross tab report which was placed in the GH1.

and the other header shows up for the details section of the report.

(((((The reason is:

I have put a summary of parameter selection on the top left hand corner of the PH a. -- this is good for ALL sections EXCEPT for GH1 'casue the PH a above GH1 is showing the parameters selection which I dont want to be shown.)))))

thanks
Jk

 

[lbass]

How did you get from "this totally works" to restating the problem? Please clarify the current report layout and where you are placing my formulas. Also restate the current problem. And please do not combine suggestions from different people unless directed to do so.

Finally, threads should NEVER get this long. Do not combine different issues into one thread or change your approach without explanation.

-LB

 

[jack91]

Current problem:

PH a --> Title of the report and 4-5 parameter listings.

The title of the report comes on top of the cross tab report where all cross tab is printed -- GOOD

But, the parameters listings/summary of what is being displayed on the page (which works well in the details pages) is being shown on the pages where cross tab is being printed. -- BAD

Layout: Title of the page
parameter 1: operating system
parameter 2:
parameter 3:

so in details section , every page will have a different parameter value.

Un-fortunately these parameters are being evaluated on pages where cross tab is being printed.

** What i want is only the title of the page to be printed until the details section. And once the details section starts the page header should show title of report plus the parameters.

(((I think maybe 2 different page headers can be created. One for the report title and an other one for the parameters. both of these page headers need to be shown on the details sections while printing. And only one page header needs to be shown when cross tab pages are being printed.))))



RH a --> not being used now

RH b --> contains title of report and //{@true} to be placed in the report header and suppressed:
whileprintingrecords;
booleanvar flag := true;

RH c --> Bar chart being used in this section
RH d --> not being used now
RH e --> not being used now

PH a --> Title of the report and 4-5 parameter listings
PH b --> Titles of the columns
PH c --> not suppressed and being used for spacing on report
PH d --> suppressed and not being used

GH 1 --> fake group header-> cross tab report is placed here
GH 2 --> suppressed
GH 3 --> using underlaying of this section.

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

GF 2 and 1 suppressed as well as report footer.

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

"New page after" set on GH1

 

[lbass]

So what page header sections do you want showing on the crosstab pages? Any? And both _a and _b should show on non-crosstab pages?

Also please explain what is currently happening with the above setup.

-LB

 

[jack91]

PH a --> contains both the title + parameters on the top left hand side.

PH b --> contains the title headings (about 8 of them, placed horizontally).


For the bar chart situated in RH d and the cross tab pages -----> I would like only PH a -- but just the title. ((**** for this purpose maybe Ph a can be split into 2 page headers, one page header section for the title and another page header section for the parameters????? ))).

For the details section:

I would like PH a and Ph b ---- > this is showing fine as it is now.

What is currently happening is:

Since PH a is not split into 2 sections, the parameters are also showing where the cross tab pages print.---> I want only the report title to print.


Thanks
Jk

 

[lbass]

There are no page header sections for report header sections, so just add the title to the top of your RH_d section.

Insert another PH section and drag the parameter display into the new PH_b section. If you want you can format PH_a to underlay following sections.

Format the PH_b the same way as the former PH_b (now PH_c). Then what issue remains?

-LB