SSRS search text box (parameter) dependent dropdown lists cascading filter - SQL Reporting
I am having a situation where I can't proceed further with my report.
I have 2 parameters and the first parameter is a search text and user allowed to enter multiple search values and then the second parameter will get loaded and in the dataset to get loaded.
ReportParameter1- user should give text need to be search. It should allow multiple values.ReportParameter2- (Multi Selection dropdown) - If we pass single value inReportParameter1it is showing related dropdown list inReportParameter2. If multiple values are given inReportParameter1it should load all the values inReportParameter2related to the search words but it is not returning any dropdownlist.
Any help will be highly appreciated and I hope the explanation make sense?
Thanks,
For passing one parameter:
passing multiple values:
sql reporting-services parameters
edited Nov 20 '18 at 0:41
aduguid
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
add a comment |
I am having a situation where I can't proceed further with my report.
I have 2 parameters and the first parameter is a search text and user allowed to enter multiple search values and then the second parameter will get loaded and in the dataset to get loaded.
ReportParameter1- user should give text need to be search. It should allow multiple values.ReportParameter2- (Multi Selection dropdown) - If we pass single value inReportParameter1it is showing related dropdown list inReportParameter2. If multiple values are given inReportParameter1it should load all the values inReportParameter2related to the search words but it is not returning any dropdownlist.
Any help will be highly appreciated and I hope the explanation make sense?
Thanks,
For passing one parameter:
passing multiple values:
sql reporting-services parameters
edited Nov 20 '18 at 0:41
aduguid
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51
add a comment |
I am having a situation where I can't proceed further with my report.
I have 2 parameters and the first parameter is a search text and user allowed to enter multiple search values and then the second parameter will get loaded and in the dataset to get loaded.
ReportParameter1- user should give text need to be search. It should allow multiple values.ReportParameter2- (Multi Selection dropdown) - If we pass single value inReportParameter1it is showing related dropdown list inReportParameter2. If multiple values are given inReportParameter1it should load all the values inReportParameter2related to the search words but it is not returning any dropdownlist.
Any help will be highly appreciated and I hope the explanation make sense?
Thanks,
For passing one parameter:
passing multiple values:
sql reporting-services parameters
edited Nov 20 '18 at 0:41
aduguid
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
I am having a situation where I can't proceed further with my report.
I have 2 parameters and the first parameter is a search text and user allowed to enter multiple search values and then the second parameter will get loaded and in the dataset to get loaded.
ReportParameter1- user should give text need to be search. It should allow multiple values.ReportParameter2- (Multi Selection dropdown) - If we pass single value inReportParameter1it is showing related dropdown list inReportParameter2. If multiple values are given inReportParameter1it should load all the values inReportParameter2related to the search words but it is not returning any dropdownlist.
Any help will be highly appreciated and I hope the explanation make sense?
Thanks,
For passing one parameter:
passing multiple values:
sql reporting-services parameters
sql reporting-services parameters
edited Nov 20 '18 at 0:41
aduguid
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
edited Nov 20 '18 at 0:41
aduguid
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
edited Nov 20 '18 at 0:41
aduguid
2,16661131
edited Nov 20 '18 at 0:41
aduguid
2,16661131
edited Nov 20 '18 at 0:41
aduguid
2,16661131
2,16661131
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
asked Nov 19 '18 at 6:57
satya ponnapallisatya ponnapalli
1
1
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51
add a comment |
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51
add a comment |
1 Answer
1
active
oldest
votes
You'll need to use the IN operator for multiple parameter values.
SELECT party.party_name
FROM apps.hz_parties party
WHERE UPPER(party.party_name) IN(:ReportParameter1)
The other option would be to filter the tablix.
Note: Report processing time will be longer for a tablix filter.
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
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%2f53369695%2fssrs-search-text-box-parameter-dependent-dropdown-lists-cascading-filter-sql%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'll need to use the IN operator for multiple parameter values.
SELECT party.party_name
FROM apps.hz_parties party
WHERE UPPER(party.party_name) IN(:ReportParameter1)
The other option would be to filter the tablix.
Note: Report processing time will be longer for a tablix filter.
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
add a comment |
You'll need to use the IN operator for multiple parameter values.
SELECT party.party_name
FROM apps.hz_parties party
WHERE UPPER(party.party_name) IN(:ReportParameter1)
The other option would be to filter the tablix.
Note: Report processing time will be longer for a tablix filter.
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
add a comment |
You'll need to use the IN operator for multiple parameter values.
SELECT party.party_name
FROM apps.hz_parties party
WHERE UPPER(party.party_name) IN(:ReportParameter1)
The other option would be to filter the tablix.
Note: Report processing time will be longer for a tablix filter.
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
You'll need to use the IN operator for multiple parameter values.
SELECT party.party_name
FROM apps.hz_parties party
WHERE UPPER(party.party_name) IN(:ReportParameter1)
The other option would be to filter the tablix.
Note: Report processing time will be longer for a tablix filter.
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
edited Nov 19 '18 at 21:56
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
answered Nov 19 '18 at 12:31
aduguidaduguid
2,16661131
2,16661131
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%2f53369695%2fssrs-search-text-box-parameter-dependent-dropdown-lists-cascading-filter-sql%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
Can you post the SQL for dataset for parameter 2?
– aduguid
Nov 19 '18 at 11:21
SELECT party.party_name FROM apps.hz_parties party WHERE UPPER(party.party_name) LIKE '%'||upper(:ReportParameter1)||'%'
– satya ponnapalli
Nov 19 '18 at 12:26
What type of database are you using?
– aduguid
Nov 19 '18 at 12:34
you need a sql server side split function and your end users have to agree to use comma as seperator. Your call to this split function will look something like this... party.party_name IN (SELECT Split FROM [dbo].[ufn_Split](@param_1, ',')) ...
– junketsu
Nov 20 '18 at 20:51