Reporting Services tablix will not allow me to freeze column header AND Rows
Trying to modify an existing rdl RS report in Visual Studio 2017. It currently freezes the column header when scrolling down, but when I try freeze the four left-most columns so they will stay in view when scrolling right, I get an error that the report definition is invalid. We've successfully done this on another report, and as far as I can tell, the basic setup between the two reports is the same. The only difference I can see is that the report that works doesn't have any grouping on it. Is that the culprit? (I just started a new job... I will be more specific in details once I actually get my own system/logins/etc - it would seem that Higher Ed works a leeeetle more slowly that K-12! - I just wanted to see if there was a quick yes/no answer out there! PS: a "veteran" already gave up on this, so it would be super awesome to fix this as a noob in my new position! ;-))
visual-studio reporting-services ssrs-tablix rdl
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
add a comment |
Trying to modify an existing rdl RS report in Visual Studio 2017. It currently freezes the column header when scrolling down, but when I try freeze the four left-most columns so they will stay in view when scrolling right, I get an error that the report definition is invalid. We've successfully done this on another report, and as far as I can tell, the basic setup between the two reports is the same. The only difference I can see is that the report that works doesn't have any grouping on it. Is that the culprit? (I just started a new job... I will be more specific in details once I actually get my own system/logins/etc - it would seem that Higher Ed works a leeeetle more slowly that K-12! - I just wanted to see if there was a quick yes/no answer out there! PS: a "veteran" already gave up on this, so it would be super awesome to fix this as a noob in my new position! ;-))
visual-studio reporting-services ssrs-tablix rdl
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51
add a comment |
Trying to modify an existing rdl RS report in Visual Studio 2017. It currently freezes the column header when scrolling down, but when I try freeze the four left-most columns so they will stay in view when scrolling right, I get an error that the report definition is invalid. We've successfully done this on another report, and as far as I can tell, the basic setup between the two reports is the same. The only difference I can see is that the report that works doesn't have any grouping on it. Is that the culprit? (I just started a new job... I will be more specific in details once I actually get my own system/logins/etc - it would seem that Higher Ed works a leeeetle more slowly that K-12! - I just wanted to see if there was a quick yes/no answer out there! PS: a "veteran" already gave up on this, so it would be super awesome to fix this as a noob in my new position! ;-))
visual-studio reporting-services ssrs-tablix rdl
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
Trying to modify an existing rdl RS report in Visual Studio 2017. It currently freezes the column header when scrolling down, but when I try freeze the four left-most columns so they will stay in view when scrolling right, I get an error that the report definition is invalid. We've successfully done this on another report, and as far as I can tell, the basic setup between the two reports is the same. The only difference I can see is that the report that works doesn't have any grouping on it. Is that the culprit? (I just started a new job... I will be more specific in details once I actually get my own system/logins/etc - it would seem that Higher Ed works a leeeetle more slowly that K-12! - I just wanted to see if there was a quick yes/no answer out there! PS: a "veteran" already gave up on this, so it would be super awesome to fix this as a noob in my new position! ;-))
visual-studio reporting-services ssrs-tablix rdl
visual-studio reporting-services ssrs-tablix rdl
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
asked Nov 13 '18 at 20:30
Laura BryngelsonLaura Bryngelson
114
114
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51
add a comment |
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51
add a comment |
1 Answer
1
active
oldest
votes
Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53289040%2freporting-services-tablix-will-not-allow-me-to-freeze-column-header-and-rows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
add a comment |
Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
add a comment |
Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
answered Nov 21 '18 at 22:11
Laura BryngelsonLaura Bryngelson
114
114
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53289040%2freporting-services-tablix-will-not-allow-me-to-freeze-column-header-and-rows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I think you will find your answer here: stackoverflow.com/questions/52764073/…
– Strawberryshrub
Nov 14 '18 at 6:00
Yeah, I tried that. Same error: The definition of the report is invalid. The Tablix 'table1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedRowHeaders of tablix.
– Laura Bryngelson
Nov 21 '18 at 21:51