Grouping in report builder or linking reports
Can someone help me with one of my reports?
I am using Microsoft SQL Server Report Builder but also have access to Microsoft Visual Studio 2008 on wards.
I will use example fields to describe;
I have a set of fields; Client Number, Client Name, Alert1, Alert2, .... , Alert9.
I would like the following grouping;
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
Alert 2
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
The problem I'm having is that because Alerts 1-9 are individual fields, it doesn't allow me to group like the example above.
Does anyone know of a way to do this? Is there a way to make combine the alert fields?
Alternatively, is there a way to create a report that can house 9 separate reports via a drop down as follows;
Report: Alerts
Dropdown: Alert 1, Alert 2, ..... , Alert 9
If you clicked Alert 1 it would load the following
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
combine report
asked Jan 3 at 10:51
jmgravelljmgravell
12
add a comment |
Can someone help me with one of my reports?
I am using Microsoft SQL Server Report Builder but also have access to Microsoft Visual Studio 2008 on wards.
I will use example fields to describe;
I have a set of fields; Client Number, Client Name, Alert1, Alert2, .... , Alert9.
I would like the following grouping;
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
Alert 2
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
The problem I'm having is that because Alerts 1-9 are individual fields, it doesn't allow me to group like the example above.
Does anyone know of a way to do this? Is there a way to make combine the alert fields?
Alternatively, is there a way to create a report that can house 9 separate reports via a drop down as follows;
Report: Alerts
Dropdown: Alert 1, Alert 2, ..... , Alert 9
If you clicked Alert 1 it would load the following
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
combine report
asked Jan 3 at 10:51
jmgravelljmgravell
12
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25
add a comment |
Can someone help me with one of my reports?
I am using Microsoft SQL Server Report Builder but also have access to Microsoft Visual Studio 2008 on wards.
I will use example fields to describe;
I have a set of fields; Client Number, Client Name, Alert1, Alert2, .... , Alert9.
I would like the following grouping;
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
Alert 2
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
The problem I'm having is that because Alerts 1-9 are individual fields, it doesn't allow me to group like the example above.
Does anyone know of a way to do this? Is there a way to make combine the alert fields?
Alternatively, is there a way to create a report that can house 9 separate reports via a drop down as follows;
Report: Alerts
Dropdown: Alert 1, Alert 2, ..... , Alert 9
If you clicked Alert 1 it would load the following
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
combine report
asked Jan 3 at 10:51
jmgravelljmgravell
12
Can someone help me with one of my reports?
I am using Microsoft SQL Server Report Builder but also have access to Microsoft Visual Studio 2008 on wards.
I will use example fields to describe;
I have a set of fields; Client Number, Client Name, Alert1, Alert2, .... , Alert9.
I would like the following grouping;
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
Alert 2
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
The problem I'm having is that because Alerts 1-9 are individual fields, it doesn't allow me to group like the example above.
Does anyone know of a way to do this? Is there a way to make combine the alert fields?
Alternatively, is there a way to create a report that can house 9 separate reports via a drop down as follows;
Report: Alerts
Dropdown: Alert 1, Alert 2, ..... , Alert 9
If you clicked Alert 1 it would load the following
Alert 1
Client Number | Client Name |
Client Number | Client Name |
Client Number | Client Name |
combine report
combine report
asked Jan 3 at 10:51
jmgravelljmgravell
12
asked Jan 3 at 10:51
jmgravelljmgravell
12
edited Jan 3 at 11:25
jmgravell
asked Jan 3 at 10:51
jmgravelljmgravell
12
asked Jan 3 at 10:51
jmgravelljmgravell
12
asked Jan 3 at 10:51
jmgravelljmgravell
12
12
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25
add a comment |
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1390119%2fgrouping-in-report-builder-or-linking-reports%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1390119%2fgrouping-in-report-builder-or-linking-reports%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
What software are you using? We cannot answer your question without this essential information. Please edit the question to include it.
– DavidPostill♦
Jan 3 at 11:08
Hi David, valid point! Thanks, I have edited the question to reflect what I'm using.
– jmgravell
Jan 3 at 11:25