Russell Christopher's Semi-Useful BI Musings

is there any way to pass 'All' as a parameter to an MDX query in SSRS?

HI - I am pass ing the qualified member name:

[Regions].[RegionsDesc].[All]

to a report. This works fine, delivering all regions. However, when I click on a cjart in this report to pass this parameter along with otheres, the next report sees only the first member of the region group. Any ideas?

Thanks

Thanks for this solution. One point to add - if you find that RS is still not showing your default value as 'Select All', check your dataset for null values. If it contains a null value, but your report parameter is set to not allow nulls, RS will revert to not selecting any values by default.

Thanks u so much. the given example is very suitable to my prob. i have another query with the continuation of above solution.

Query: in the report field using join() i am retriving all the selected parameter values but for each and every row all values are getting. instead of this the related values only retrieve.

Example: Player played balls in cricted match

for player1 - 1,3,5 balls

for player2 - 2,8 balls

Like this all the selected balls should split based on player.

can any one resolve this issue.

Thanks in advance

Madhavi:

In your current situation you will have a query that populates all the players and a query that populates the balls (with all the balls).

What you need is a 3rd query that takes the players as a param and only gives you the balls that are the defaults for the players, so if they enter player2, it only returns 2 and 8, and player1 returns 1,3,5.

Then what you do is set the available values with the original balls query, and set the default values with the new query that only selects the default ones.

This should then show all balls in the list but only select the ones that are defaults.

Cheers,

Mikey

I have tried this solution and IT SIMPLY NOT WORKING. No matter how many times I try setting the default value to the SAME!!!  dataset as the available values, it's NOT selecting everything. God I'm pissed off.

This is still not working. Anybody will solve this problem????

This is still not working. Anybody will solve this problem????

Although this works initially, the results are cached and this creates a problem.  For example, if you have all of 10 items selected, then list a subset of those 10, say for example 5 of 10, all 5 will be correctly selected. But when you go back to list all 10 items, only the 5 that were selected in the last request will be selected.

This should be an easy bug to fix Microsoft !! It is really an annoyance.

Worked like a charm - thank so much!

Almost 10 months have passed and I still haven't seen a viable solution.  I see a lot of workarounds for various examples, but the problem still exists.  I did see a hint though. When I added a second record with the same values (UserID, 1) and (UserID, 1), the first UserID value was selected correctly, but the second one wasn't.  Hmmm.