Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2008-11-17 : 10:10:33
|
| Hi,I am working on dynamic grouping. It works fine when i choose one parameter value from the list. I need to know if it's possible to choose more than one value from the list and then group based on them. Is it feasible?Kind of weird, but you know customers' requirements :).Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 11:36:44
|
| you mean group based on individual values from csv? |
 |
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-11-18 : 04:29:34
|
| Let's say we have a parameter drop down having the values (doctor and city). If the user chooses doctor, i'll do grouping based on it, if he chooses City, grouping is based on city. But my question is can i allow him to choose both and then do the grouping as doctors by city (means both groupings). Is that feasible? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-18 : 04:42:26
|
quote:
Originally posted by 1sabine8
Let's say we have a parameter drop down having the values (doctor and city). If the user chooses doctor, i'll do grouping based on it, if he chooses City, grouping is based on city. But my question is can i allow him to choose both and then do the grouping as doctors by city (means both groupings). Is that feasible?
For that you need to parse through comma seperated list and extract each values and then take field!thatvalue.value and group on that. It is achievable but you need to write a custom code for comma seperated list parsing. When you multiselect, the values are send as coma seperated list on background |
|
|
|
1sabine8
Posting Yak Master
130 Posts |
Posted - 2008-11-18 : 05:18:40
|
| Can you give me more info concerning that please? |
|
|
|
|
|
|
Dynamic Grouping