Cross Tab page breaks and line space 3

[ipcm]

Hi,
I am on cr10 version, and need to insert a page break by status. I have read the other threads on this topic, but can't seem to implement it.

I have five status' FT, PT, ML , LT & NTC. I need to see the first two on one page and the next three on another, not seperate pages for each.

Additionally, I need a line space in the data section. Can this be done on a cross tab report?

Thanks

 

[Madawc]

Create a formula field, something like

if {status} in ["FT", "PT"] then "First Group" else "Second Group"

use this as a higher-order group. Include a [New Page After] on the group footer, or whatever. It can be made conditional to avoid unwanted page skips.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

I think Madawc meant to also say for you to place the crosstab in a group section. To get a blank display in the data section, create a formula:

whilereadingrecords;
0

Insert this as another summary field and then in preview mode, format field->number->customize->suppress if zero.

-LB

 

[ipcm]

Hi lbass,
THanks for your response, I didnt understand clearly. My crosstab is in GF2b at the moment. Which group section should it be in? Where exactly should I put Madawc's formula and the one you suggested "whilereadingrecords; 0" will this help create a blank line? Please be patient with me as I am new at this.
Thanks
ipcm

 

[madelca100]

Remember that you can't (can not) extrapolate Madawc's formula too much further since it relies on an alphabetic sort.

"First" sorts before "Second". "Third" will still work, but "Fourth" will cause problems.

If you want an alpha group to sort correctly I suggest using numbers with the apppropriate number of digits. Something like - "01 Group", "02 Group", etc. does the trick for me when I have 10 or more groups.

(Don't use "1 Group", "2 Group", etc. if you are setting up more than 9 groups because "1 Group" and "10 Group" will sort together.)

Another trick I use is to put an extra blank or two in front of the label to force it to sort first. Not always pretty but useful for a "Q&D" (quick & dirty).

So " ZZZ" (one leading blank) will sort before "AAA" (no leading blanks) and
" GGG" (two leading blanks) will sort before " ZZZ" (one leading blank.)

 

[ipcm]

Thanks very much, I will give it a try. How can I create lines between certain sections of the data.e.g.

A1
A2
A3
A4
B1
B2
B3
B4
Can I seperate the 'A' section from the 'B' section with a blank line between them

 

[lbass]

You are not indicating what your actual row field is--I'm not sure whether A1, A2, etc. are your actual row names. If they are, you can create a formula:

{table.rowfield}[1]

Add that as your first row. This will create subtotal row between A4 and B1, and if you suppress the label and cell results, you will have an empty row. You will also have a column on the left that you can suppress and resize to minimize the width.

-LB

 

[ipcm]

Lbass, I am new at this, I have created the formula how and where should it be inserted,so it creates the subtotal line. I understand the supress part once it is done.

Thanks
ipcm

 

[lbass]

Add it as your first row field in the crosstab expert. Since you already have a row field, when you add it, it will become the second row. While in the crosstab expert, select it and drag it into the first position.

-LB

 

[ipcm]

This worked beautifully, Thanks. I am now faced with a challenge to remove the vertical gridlines from the blank rows just created. The Gridline formatting doesn't work? Is there another way?