Author |
Message |
Nissim
Newbie
Joined: 04 May 2010
Online Status: Offline
Posts: 18
|
Topic: selecting all values in dynamic parameter Posted: 04 May 2010 at 10:30pm |
Hi everybody,
I breaking my brain to find a solution for displaying the word "ALL" when the user selects all values in a dynamic parameter with multiple values option.
I don't want to add the 'ALL' value to the selection because the user can still click on the ">>" button and select all values and not the "All" value I added.
I thought to compare the count of the two boxes - "Available Values" and "Selected Values" and if they are equal then return "ALL" in the formula, but I don't know how to get the count from the "Available Values" box.
any ideas?
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 05 May 2010 at 3:17am |
How is the dynamic parameter options supplied? You should be able to count the entries in the table and compare that to the length of the array of items selected...unless there are more than a 1000. I've heard that CR has a limit, but since I don't use the parameter screen (custom parameter wizards instead), I don't really know/care.
Personally, listing that many options is too hard on the user.
HTH
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 May 2010 at 3:27am |
Another option is to use a crystal command as a Union with the text '...All' into the param source field then use the command field as your source instead.
Your seelct statment wil then be
{?param}='...All' or {?Param}=command.field
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 May 2010 at 3:28am |
Note: I have found Commands to drag the performance at my site. You can also do this via a stored proc which may be more efficient.
Edited by DBlank - 05 May 2010 at 3:28am
|
IP Logged |
|
Nissim
Newbie
Joined: 04 May 2010
Online Status: Offline
Posts: 18
|
Posted: 05 May 2010 at 3:42am |
Originally posted by DBlank
Note: I have found Commands to drag the performance at my site. You can also do this via a stored proc which may be more efficient.
This is a nice solution, but, what if the user ignores the additional option of "All" and selects all values by clicking the ">>" button?
Then the selection will look like this:
All
value1
value2
value3
......
.....
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 05 May 2010 at 3:43am |
I would have offered the suggesting, but he stated that he didn't want an ALL option. Personally, I would have created the command.
Since we use custom designed/coded wizards, all of my options have an ALL.
|
IP Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 05 May 2010 at 3:45am |
So, check if the 'ALL' option is in the array first, and if it is, you're done, no filtering needs to take place. If they select everything except ALL (and why would they do that??) you can check the other way...or not bother as they made the deliberate decision to click everything except the ALL.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 May 2010 at 3:53am |
agreed with lockwelle.
{?param}='...All' or {?Param}=command.field
if the user select the 'all' option it will override the rest of the select otpions and return all records regardless of what else they select.
|
IP Logged |
|
Nissim
Newbie
Joined: 04 May 2010
Online Status: Offline
Posts: 18
|
Posted: 05 May 2010 at 4:20am |
OK. seems good solution to me.
what if the value is numeric? All will be present by number, 999, for example?
I have another question if you don't mind. In case the multiple value is numeric, and it has also Description. Now I want to present the user his selection in the report header with words (description). Is there an easy way to do this?
I usually create a subreport that retrieves the descriptions from the database (again) and link it with the id (numeric values).
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 05 May 2010 at 4:55am |
You have to determine which to use for a number 0 or 999.
{?param}=0 or {?Param}=command.numberfield
although I am confused as to why you would want to make a user select a number field when you have the description available and can use it in a dynamic param and include the '..all' option. Usually end users can manage descriptions much better than a reference code #.
If you use a number you can use an array to convert it to text and display that.
if you use the text fieldyou can just join the param field and dispaly that.
join(?{textparam},',')
Edited by DBlank - 05 May 2010 at 4:56am
|
IP Logged |
|
|