cancel
Showing results for 
Search instead for 
Did you mean: 

make crosstab label appear on all vertical pages

0 Kudos

Using SAP Crystal Reports 13 Support Pack 6 Version 14.1.6.1702

I have a crosstab report that has two labels above the column headings. These labels appear on the first horizontal pages but not on vertical pages or horizontal pages except the first.

How can I make them appear on all horizontal and all vertical pages?

In the image, I'm referring to Label10 and Label7

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Jeff,

Labels10 and 7 need to be moved to Group Header#1a (Point #6 from my workaround). Right now they're on the 1b section.

-Abhilash

Answers (5)

Answers (5)

0 Kudos

I have a similar issue where I have a Vertical report in WEBI and need to add a dimension to the report within a Header Column. This will dump values across the report for 3+ columns.
Stuck as I keep getting the dreaded #MULTIVALUE


structrpt.png
See Attached.

0 Kudos

That worked, Thanks Abhilash!

-Jeff

0 Kudos

Abhilash - Unfortunately that did not appear to fix the issue either. Here is a link to the report:

https://ln.sync.com/dl/967585a20/4eaazhkc-46wx7m4t-ngttj9e3-i6eapunx

Thanks for you help!

Jeff

abhilash_kumar
Active Contributor
0 Kudos

Hi Jeff,

Could you also make sure "Repeat Row Labels" is checked. This option is under the Crosstab Expert > Customize Style tab.

This works for me, however, if it still doesn't work for you please attach a copy of the report "with saved data" to dropbox/drive and I'll take a look at it.

-Abhilash

abhilash_kumar
Active Contributor
0 Kudos

Hi Jeff,

Try this please:

1) Create a formula with this code:

whilereadingrecords; 
"" 

2) Go to Group Expert > Move this formula to the pane on the right so that a group is created on this formula.

If there are any other groups in the list, move this formula to the top. This won't affect the other groups.

3) In the same window, select the Group > Options > Options tab > Check 'Repeat Group Header on each page' option.

4) Insert a Group Header 1b section.

5) Then move the Crosstab to this Group Header 1b section.

6) Move Label10 and Label7 to Group Header 1a section.

7) Right-click Label10 > Format Field > Common tab > Check "Repeat on Horizontal Pages". Do the same for Label7.

😎 Next, go the Section Expert > Select Group Header 1a > check Underlay Following Sections.

Hope this helps!

0 Kudos

I think I was able to follow your instructions. It did not appear to fix the issue of the labels not repeating on vertical pages. Any other thoughts?

Thanks,

Jeff