Is there a way to bring parameter back in a drop down selection?

Question

Is there a way to bring parameter back in a drop down selection?

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99133 More actions · Answer 1

This isn't cascading anymore, this is one parameter selects all the others.

I think, because you haven't really defined your question in a post, things are getting missed as the topic goes on. So, i'm going to attempt to guess what it is you're after (italics are questions for you to answer):
1. The user can pick their parameters.
--a. Some of these parameters cascade, Others do not
--b. Should cascaded parameters here default to all values or force selection?
2. The user can pick from a different drop down. This populates all the values from a preset range.
3. The user can pick from option 2's drop down box a parameter which is a version of the report that previously ran
--a. When this is selected, all parameters from the previous run will be populated and the report automatically run.
--b. Is the details of every run stored somewhere?
--c. What is your dataset/source set up as. Does it use a service account login or the user's credentials?
--d. Should a user be able to run another user's saved parameters from the drop down?
--e. Should the user have the ability to change any of the parameters after they ran it?
--f. Profit..? (add other steps for options 3 here)
4. Profit...? (add other options here)

What is the need for saving the previously ran parameters? Is this so th user can see what has changed since the last time they ran it, or so that they can easily get to the data again? If the latter,why not educate the users to export the report, instead of running it again?

I want to really understand your needs here, as this doesn't seem as "simple" as I first thought it was. It almost seems like you're mixing snapshots and cascading paramters, but you might not be, if the user is looking for an update, rather than what rerunning for the previous data.

Depending on what your answer is, I might have completely misunderstood what your previous requests were.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

chjquest Ten Centuries Points: 1234 More actions · Answer 2

Thom A - Tuesday, April 11, 2017 11:08 AM
This isn't cascading anymore, this is one parameter selects all the others.
I think, because you haven't really defined your question in a post, things are getting missed as the topic goes on. So, i'm going to attempt to guess what it is you're after (italics are questions for you to answer):
1. The user can pick their parameters.
--a. Some of these parameters cascade, Others do not
--b. Should cascaded parameters here default to all values or force selection?
force selection
2. The user can pick from a different drop down. This populates all the values from a preset range.
3. The user can pick from option 2's drop down box a parameter which is a version of the report that previously ran
--a. When this is selected, all parameters from the previous run will be populated and the report automatically run.
--b. Is the details of every run stored somewhere? I am relying on the system database now, the system table returns me the complete URL including all the parameters users entered. Also, I can try to save the parameters users entered from each run with another parameter (Let's just call "Action", which they can decide to Save or not).
--c. What is your dataset/source set up as. Does it use a service account login or the user's credentials?
User's credential
--d. Should a user be able to run another user's saved parameters from the drop down?
No, I try to use Users!UserID to identify users (Environment has AD)
--e. Should the user have the ability to change any of the parameters after they ran it?
Yes.
--f. Profit..? (add other steps for options 3 here)
4. Profit...? (add other options here)
What is the need for saving the previously ran parameters? Is this so th user can see what has changed since the last time they ran it, or so that they can easily get to the data again? If the latter,why not educate the users to export the report, instead of running it again?
I want to really understand your needs here, as this doesn't seem as "simple" as I first thought it was. It almost seems like you're mixing snapshots and cascading paramters, but you might not be, if the user is looking for an update, rather than what rerunning for the previous data.
Depending on what your answer is, I might have completely misunderstood what your previous requests were.

The main reason is because the user is complaining about picking up specific drop down takes a long time (like Client/Client Categories)
Say I have 5000+ clients. The user wants to save 20 major clients pre-set parameters. So after a table or something, the user can pick from the drop down, and the clients/client categories will be populated automatically.
By completing this goal, the user will of course create the preset at the first time (so the preset will be saved somewhere for further use).

However, data are changing across time, reports with time based (say weekly or monthly), users wants to check back for the major 20 client categories with different time frame - and this is no way I can do against subscription. Since date or other information could be vary, export won't be an option.

Thom A SSC Guru Points: 99133 More actions · Answer 3

Ok, this does seem like it's going to be quite complex. I think I have an idea (or two), but it's going to take a bit to really set up and get going. This is going to be much easier to explain by example that directions, that does mean I need to create a report and sample data. It's The Easter holidays shortly over here in the UK, so I'll try to get something posted before the break, but might not have something ready till Tuesday otherwise. Hope no major rush.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

chjquest Ten Centuries Points: 1234 More actions · Answer 4

Thom A - Wednesday, April 12, 2017 2:04 AM
Ok, this does seem like it's going to be quite complex. I think I have an idea (or two), but it's going to take a bit to really set up and get going. This is going to be much easier to explain by example that directions, that does mean I need to create a report and sample data. It's The Easter holidays shortly over here in the UK, so I'll try to get something posted before the break, but might not have something ready till Tuesday otherwise. Hope no major rush.

Hi Thom,
Thanks for your time and it's no rush.
Enjoy the holiday !