Mixing
ssrs report - textbox create gap space
I have a report with parameter to select the name and a textbox with expression field name. Below text box the a dataset table.
When I run the report, by default it will return all name on the table and HIDE text box.
When I select name in parameter, it will return for that name and SHOW text box.
I don't have any issue at this point.
BUT I do have problem that the textbox create a gap between header and the table WHEN I run the report by default (not select name in parameter).
My goal is to some how REMOVE THE GAP so the table can move up right below header. ONLY show when name is select on parameter.
reporting-services ssrs-2012
edited Jan 3 at 3:26
Dale Burrell
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
add a comment |
I have a report with parameter to select the name and a textbox with expression field name. Below text box the a dataset table.
When I run the report, by default it will return all name on the table and HIDE text box.
When I select name in parameter, it will return for that name and SHOW text box.
I don't have any issue at this point.
BUT I do have problem that the textbox create a gap between header and the table WHEN I run the report by default (not select name in parameter).
My goal is to some how REMOVE THE GAP so the table can move up right below header. ONLY show when name is select on parameter.
reporting-services ssrs-2012
edited Jan 3 at 3:26
Dale Burrell
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
I think this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I will upload image soon
– Tsang
Jan 2 at 23:08
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
Thank you for your info
– Tsang
Jan 3 at 15:18
add a comment |
I have a report with parameter to select the name and a textbox with expression field name. Below text box the a dataset table.
When I run the report, by default it will return all name on the table and HIDE text box.
When I select name in parameter, it will return for that name and SHOW text box.
I don't have any issue at this point.
BUT I do have problem that the textbox create a gap between header and the table WHEN I run the report by default (not select name in parameter).
My goal is to some how REMOVE THE GAP so the table can move up right below header. ONLY show when name is select on parameter.
reporting-services ssrs-2012
edited Jan 3 at 3:26
Dale Burrell
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
I have a report with parameter to select the name and a textbox with expression field name. Below text box the a dataset table.
When I run the report, by default it will return all name on the table and HIDE text box.
When I select name in parameter, it will return for that name and SHOW text box.
I don't have any issue at this point.
BUT I do have problem that the textbox create a gap between header and the table WHEN I run the report by default (not select name in parameter).
My goal is to some how REMOVE THE GAP so the table can move up right below header. ONLY show when name is select on parameter.
reporting-services ssrs-2012
reporting-services ssrs-2012
edited Jan 3 at 3:26
Dale Burrell
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
edited Jan 3 at 3:26
Dale Burrell
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
edited Jan 3 at 3:26
Dale Burrell
3,39952655
edited Jan 3 at 3:26
Dale Burrell
3,39952655
edited Jan 3 at 3:26
Dale Burrell
3,39952655
3,39952655
asked Jan 2 at 22:11
TsangTsang
197
asked Jan 2 at 22:11
TsangTsang
197
asked Jan 2 at 22:11
TsangTsang
197
197
I think this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I will upload image soon
– Tsang
Jan 2 at 23:08
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
Thank you for your info
– Tsang
Jan 3 at 15:18
add a comment |
I think this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I will upload image soon
– Tsang
Jan 2 at 23:08
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
Thank you for your info
– Tsang
Jan 3 at 15:18
I think this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I think this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I will upload image soon
– Tsang
Jan 2 at 23:08
I will upload image soon
– Tsang
Jan 2 at 23:08
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
Thank you for your info
– Tsang
Jan 3 at 15:18
Thank you for your info
– Tsang
Jan 3 at 15:18
add a comment |
1 Answer
1
active
oldest
votes
You can do this as long as your table is not a matrix (as the column groups prevent you from merging cells).
Add a new row to the top of your table, then select all the cells in that row and merge them.
Now resize the single cell you just created so that it's roughly big enough to hold all the content.
Right-Click the cell and do Insert->Rectangle
Now either add new controls or copy and paste your existing ones into the rectangle.
Right-Click the row header and select "Row visibility", set it to the expression you are currently using to show/hide your text boxes.
That should be it. I did a quick test to try it out and it works perfectly (in this simple scenario). I've put some background colours in just to make it clearer but this is what the design looked like...
The row visibility was simply set to my parameter value =Parameters!HideTopRow.Value=1 . The textboxes in the yellow section are just some arbitrary values from the dataset.
When I run with the option set to 0 I get this..
When I run with the parameter set to 1 I get this.
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
add a comment |
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%2f54013849%2fssrs-report-textbox-create-gap-space%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
You can do this as long as your table is not a matrix (as the column groups prevent you from merging cells).
Add a new row to the top of your table, then select all the cells in that row and merge them.
Now resize the single cell you just created so that it's roughly big enough to hold all the content.
Right-Click the cell and do Insert->Rectangle
Now either add new controls or copy and paste your existing ones into the rectangle.
Right-Click the row header and select "Row visibility", set it to the expression you are currently using to show/hide your text boxes.
That should be it. I did a quick test to try it out and it works perfectly (in this simple scenario). I've put some background colours in just to make it clearer but this is what the design looked like...
The row visibility was simply set to my parameter value =Parameters!HideTopRow.Value=1 . The textboxes in the yellow section are just some arbitrary values from the dataset.
When I run with the option set to 0 I get this..
When I run with the parameter set to 1 I get this.
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
add a comment |
You can do this as long as your table is not a matrix (as the column groups prevent you from merging cells).
Add a new row to the top of your table, then select all the cells in that row and merge them.
Now resize the single cell you just created so that it's roughly big enough to hold all the content.
Right-Click the cell and do Insert->Rectangle
Now either add new controls or copy and paste your existing ones into the rectangle.
Right-Click the row header and select "Row visibility", set it to the expression you are currently using to show/hide your text boxes.
That should be it. I did a quick test to try it out and it works perfectly (in this simple scenario). I've put some background colours in just to make it clearer but this is what the design looked like...
The row visibility was simply set to my parameter value =Parameters!HideTopRow.Value=1 . The textboxes in the yellow section are just some arbitrary values from the dataset.
When I run with the option set to 0 I get this..
When I run with the parameter set to 1 I get this.
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
add a comment |
You can do this as long as your table is not a matrix (as the column groups prevent you from merging cells).
Add a new row to the top of your table, then select all the cells in that row and merge them.
Now resize the single cell you just created so that it's roughly big enough to hold all the content.
Right-Click the cell and do Insert->Rectangle
Now either add new controls or copy and paste your existing ones into the rectangle.
Right-Click the row header and select "Row visibility", set it to the expression you are currently using to show/hide your text boxes.
That should be it. I did a quick test to try it out and it works perfectly (in this simple scenario). I've put some background colours in just to make it clearer but this is what the design looked like...
The row visibility was simply set to my parameter value =Parameters!HideTopRow.Value=1 . The textboxes in the yellow section are just some arbitrary values from the dataset.
When I run with the option set to 0 I get this..
When I run with the parameter set to 1 I get this.
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
You can do this as long as your table is not a matrix (as the column groups prevent you from merging cells).
Add a new row to the top of your table, then select all the cells in that row and merge them.
Now resize the single cell you just created so that it's roughly big enough to hold all the content.
Right-Click the cell and do Insert->Rectangle
Now either add new controls or copy and paste your existing ones into the rectangle.
Right-Click the row header and select "Row visibility", set it to the expression you are currently using to show/hide your text boxes.
That should be it. I did a quick test to try it out and it works perfectly (in this simple scenario). I've put some background colours in just to make it clearer but this is what the design looked like...
The row visibility was simply set to my parameter value =Parameters!HideTopRow.Value=1 . The textboxes in the yellow section are just some arbitrary values from the dataset.
When I run with the option set to 0 I get this..
When I run with the parameter set to 1 I get this.
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
answered Jan 3 at 22:28
Alan SchofieldAlan Schofield
6,54511021
6,54511021
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%2f54013849%2fssrs-report-textbox-create-gap-space%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 this is a case where an image would help explain your question.
– Dale Burrell
Jan 2 at 23:04
I will upload image soon
– Tsang
Jan 2 at 23:08
AFAIK that is not possible... I have seen a hack which apparently works, but I haven't tested it social.technet.microsoft.com/Forums/sqlserver/en-US/…
– Dale Burrell
Jan 3 at 3:48
Thank you for your info
– Tsang
Jan 3 at 15:18