reporting services - SSRS Dynamic Parameters Default value selection from Query not working -

reporting services - SSRS Dynamic Parameters Default value selection from Query not working -

i've problem simple ssrs study uses 2 parameters.

parameter 1 - policystatus data type - text allow multiple values - true available values - select distinct policystatus dbo.policytransstatus default values - select distinct policystatus dbo.policytransstatus parameter 2 - transactionstatus data type - text allow multiple values - true available values - select distinct transactionstatus dbo.policytransstatus policystatus in(@policystatus). default values - select distinct transactionstatus dbo.policytransstatus policystatus in(@policystatus) , transactiostatus not in ('adjustment', 'cancellation', 'cancellation adjustment', 'claims booking policy','renewal invitation', 'renewal lapse', 'renewal not invited' issue

the default values shown in transaction status not beingness shown multiple selected values in policy status parameter. appears shown values lastly selected single value of policy status. when start study default values not beingness populated correctly?

any ideas anyone?

cheers,

anthony

code set similar table:

create table policytransstatus ( policytransstatus varchar(50) not null, transactionstatus varchar(50) not null ) insert dbo.policytransstatus values('claims booking policy','claims booking policy')insert dbo.policytransstatus values('new business','adjustment') insert dbo.policytransstatus values('new business','amended new business') insert dbo.policytransstatus values('new business','cancellation') insert dbo.policytransstatus values('new business','cancellation adjustment') insert dbo.policytransstatus values('new business','cancellation of provisional new business') insert dbo.policytransstatus values('new business','endorsement') insert dbo.policytransstatus values('new business','new business') insert dbo.policytransstatus values('new business','new business amendment (reverse nb)') insert dbo.policytransstatus values('new business','new business close') insert dbo.policytransstatus values('new business','new business provisional ') insert dbo.policytransstatus values('new business','new policy') insert dbo.policytransstatus values('new business','renewal lapse') insert dbo.policytransstatus values('new business','revised new business') insert dbo.policytransstatus values('pipeline','adjustment') insert dbo.policytransstatus values('pipeline','amended new business') insert dbo.policytransstatus values('pipeline','cancellation') insert dbo.policytransstatus values('pipeline','new business') insert dbo.policytransstatus values('prospect quote','new business') insert dbo.policytransstatus values('quotation','adjustment') insert dbo.policytransstatus values('quotation','amended new business') insert dbo.policytransstatus values('quotation','amended renewal') insert dbo.policytransstatus values('quotation','cancellation') insert dbo.policytransstatus values('quotation','new business') insert dbo.policytransstatus values('quotation','ntu') insert dbo.policytransstatus values('quotation','renewal confirmation') insert dbo.policytransstatus values('quotation','renewal lapse') insert dbo.policytransstatus values('quotation','renewal not invited') insert dbo.policytransstatus values('renewal','adjustment') insert dbo.policytransstatus values('renewal','amended new business') insert dbo.policytransstatus values('renewal','amended rekeyed renewal') insert dbo.policytransstatus values('renewal','amended renewal') insert dbo.policytransstatus values('renewal','cancellation') insert dbo.policytransstatus values('renewal','cancellation adjustment') insert dbo.policytransstatus values('renewal','endorsement') insert dbo.policytransstatus values('renewal','new business') insert dbo.policytransstatus values('renewal','reinstate lapse') insert dbo.policytransstatus values('renewal','rekeyed renewal') insert dbo.policytransstatus values('renewal','renewal') insert dbo.policytransstatus values('renewal','renewal cancellation') insert dbo.policytransstatus values('renewal','renewal confirmation') insert dbo.policytransstatus values('renewal','renewal not invited') insert dbo.policytransstatus values('renewal','revised renewal') insert dbo.policytransstatus values('renewal invite','renewal invitation') insert dbo.policytransstatus values('renewal lapse','lapse') insert dbo.policytransstatus values('renewal lapse','renewal lapse')

reporting-services parameters ssrs-2008