Is there a way to bring parameter back in a drop down selection?
-
Just curious, how many people here would need this function ?
Like a drop down you can select which parameter (profile) to use, and it will auto-populate all columns you want (datetime, text, multi-value column, and etc).
I uploaded a sample screenshot, and would like to know if there is a way to achieve it.
Thanks.
-
What is your question exactly? It seems like you're asking if people need help, rather than asking for it; unless I'm mistaken?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Monday, April 10, 2017 12:58 PM
The whole thing is I am curious if it's worth to research a solution to fits major problem. I'd like to know more about the true world feedback.
Most SSRS/DBA know that there is no known solution for SSRS to remember parameters, and there seems no mature solution for now.
I have a couple clients asking for this function and I am working on it. But I'd like to see if there are people outside may need the same/similar function, and I may miss something - maybe there is already a solution and I just not see it. -
What major problem? The only question you have asked is "Just curious, how many people here would need this function ?"; What function?
It almost seems like you're talking about cascading parameters, however, that already exists in SSRS. Can you outline your problems and needs, and what your question is?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 1:53 AM
Is there a way to achieve the same goal like the screenshot I attached ?
A drop down selection and bring back everything ?
Maybe I should rephrase the post title. - chjquest - Tuesday, April 11, 2017 7:23 AM
The screenshot doesn't really tell the story. I can see you have selected All states. So do you therefore want it to Populate the State provinces with all the state names? That's cascading parameters, and yes, it already exists in SSRS.
Have a look at this post I made before about how to create cascading parameters: https://www.sqlservercentral.com/Forums/Topic1836905-150-1.aspx
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 7:45 AM
No, I want to have the first drop down selected and bring all the rest parameters (date, country and state) back, the final is save/save new/delete.
- chjquest - Tuesday, April 11, 2017 7:57 AM
If these parameters aren't related, how does SSRS know what other parameters to use? State isn't related to date, for example, so if you select "All states" what date does this represent?. If you don't want the parameters to cascade, then I don't understand what it is you're after.
Can you explain your requirements in FULL. Give examples of your needs and what your expectations are.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 8:07 AM
I want all the parameters saved somewhere, and save like a profile - I give each parameter set a name, and hopefully save all the selected parameter in a table.
Next time, when user select the saved parameter, it will bring everything back.
Ex,A parameter called All US, it will bring the start date/end date (not important here, but it would be good they get saved somewhere), country (single or multiple selected), and state (say CA, FL, NJ, PA).
If the user change to another saved parameter (again, the first drop down), say All France, it brings all French (French in country), all province/state in French the user selected.
- which is, the user doesn't want to select the country and state everytime, just saved somewhere and use it with one click.The screenshot is a make up and is what I expected to have.
-
This still sounds like cascading parameters. Did the topic i linked to above not help you on this matter? This shows how you can limit the parameters based on a prior parameters. You could easily adjust this so that the selection of a parameters not only limits, but defaults to certain values as well.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 8:27 AM
It's similar. However, I have different parameters - product, name, address, contact, area, country, and there are more.
I read your link, correct me if I am wrong - I will keep creating more datasets if I have more countries to go (select) ? - chjquest - Tuesday, April 11, 2017 9:01 AM
You only need one dataset for each parameter. So, if you've got parameters are Country, State, City, Date, you would have 4 datasets (Country, State, City and Date),, plus your normal dataset(s).
Each parameter would cascade, so when you select Country, Sate would become available to choose from. Once you choose the state, city would become available. You could, however, as i stated above, use the same logic to set the available and default values at the same time. If you cascade the default values down properly, then they will all automatically populate.Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 9:10 AM
To clarify, just back to the link.
If the question becomes
London, Paris, New York, Taipei, Hongkong, Beiging, L.A. (Total 7 in here).
How many datasets do I need to create ? From my understanding, it will be 7 datasetsSELECT CityID,
CityName
FROM DevtestDB.dbo.City
WHERE CountryID = @Country1, @Country2, @Country3 ... @Country7
Each one will have a dataset corresponding to it's countryID, am I right ? -
This is not valid SQL:
SELECT CityID,
CityName
FROM DevtestDB.dbo.City
WHERE CountryID = @Country1, @Country2, @Country3 ... @Country7
The reason for that set up in that example was due to the OP's "unique" needs of needing to only select 2 countries and 2 cities. You would need to use a splitter instead Like the DelimitedSplit8K. You can then do something like:SELECT CityID, CityName
FROM dbo.City
WHERE CountryID IN (SELECT DS.item FROM dbo.DelimitedSplit8K(@County, ',') DS);Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A - Tuesday, April 11, 2017 9:31 AM
Ok. I see your point. Below is one of my true report.
If I want to select one option from the first drop down (Profile), and bring values back from somewhere I saved (can be a table).
(Start Date, Weeks...till Include Conflict), all 8 parameters, all from the first profile 1 click selection.
Can you advise ? (The only cascading are [client category -> client] and [Office -> Department])Below is what I am expecting,
Profile
TEST - 2014/1/1, 52, New York, Audit/Finance/NA, Active, A few categories., A few clients, No
2015H1 - 2015/1/1, 26, New York, Audit/Finance/NA, Active, A few categories., A few clients, No
2015H2 - 2015/7/1, 26, New York, Audit/Finance/NA, Active, A few categories., A few clients, No
2015TAX - 2015/7/1, 52, New York, Tax, Active, A few categories., A few clients, No
(and will be more).
Every parameter could have different values, and all up to the users.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply