on 02-26-2019 12:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That worked, Thanks Abhilash!
-Jeff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.