Default Values for Multi-Value Parameters

Question

Default Values for Multi-Value Parameters

Amedeo Feroce

SSChasing Mays

Points: 607
More actions
August 7, 2006 at 5:17 pm

#173542

I am using two parameters for a report, both of which are multi-value. The default value for both parameters are set to From Query and points to the appropriate query that returns all of the available values for that field. My problem is that no values are being selected for the second parameter when the report is run. All of the values are selected for the first parameter as they should be based on the default value I set for the first parameter. However, no values are selected by default for the second parameter. The user has to select which values they choose to use for the second parameter. I don't understand why the default value is working for the first parameter but not the second.

Thanks in advance for any thoughts you can share.

Amedeo
August 10, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

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

Jones'e Right there with Babe Points: 774 More actions · Answer 1

I have had the same problem before. I over came it by creating a dataset that would only return the default value that I needed and used that query to set the default value.

Select 'O' as default

Amedeo Feroce SSChasing Mays Points: 607 More actions · Answer 2

Thanks for the advice but that won't work for me. The reason being that my two parameters are billing status and doctor name. I set up two queries that return all of the values for billing status and doctor last name. The parameter that accepts the billing status works fine. When a user runs the report, all of the values are selected for billing status. However, the user still has to select a doctor. I would prefer that all of the doctors be selected by default as opposed to just one.

Jones'e Right there with Babe Points: 774 More actions · Answer 3

Then it sounds like you need to create a dynamic query. That is how I get all as the default. Here is a link to a walk througt to create a dynamic query.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_overview_v1_631v.asp

Amedeo Feroce SSChasing Mays Points: 607 More actions · Answer 4

I will look at the article you suggested but what I find odd is that the default value for parameter 1 (billing status) works just fine. Parameter 2 (doctor) doesn't. They are essentially the same. I have a query that returns all of the values for each field as the default value. When a user runs the report, all of the values are selected for billing status. However, the user still has to select a doctor.

I'll check out the article you pointed me to. Thanks!!!

Jones'e Right there with Babe Points: 774 More actions · Answer 5

Jones'e

Right there with Babe

Points: 774

August 10, 2006 at 9:42 am

#654360

Post the queries that you are using.

Amedeo Feroce SSChasing Mays Points: 607 More actions · Answer 6

Donavon -

Thanks for your help!!!! I followed the suggestion of the link you posted and modified my query to include "ALL". I then set the default parameter for Doctors to "ALL".

Another benefit to setting it up this way is that the "Select All" feature was disabled in SSRS 2005 SP1. I guess you could say I knocked out two birds with one stone.