Hi

Nearly all of my datasets use a multi value parameter at present which from testing seems to be causing a long delay.

If I change the dataset to not call the parameter and manually enter the values in this works quicker, the only issue being if I need to add an additional value I need to then do it on multiple datasets rather than one parameter.

A way around this I thought was to do the below which doesn't seem as slow as my original method.

To try better explain I have done this

SELECT
  Practice.ibvSalesByJob.JobType
FROM
  Practice.ibvSalesByJob
WHERE
  Practice.ibvSalesByJob.JobType IN (N'1', N'4', N'5', N'8', N'12', N'17', N'40', N'45', N'60')

I then have a parameter which has default values > dataset > JobType

The actual dataset shown in the report then shows 

WHERE
  Practice.ibvSalesByJob.JobType IN (@ABSJobs)

Does this make sense or is there a better way of doing what I am trying to do?

Is there a known issue with Report Builder 3.0 and multiple parameters?

Any help/advice appreciated.

Cheers