Here's the scenario:

Dataset1:

Select *

from MyTable

Where Period Between @StartPeriod AND @EndPeriod; --- Works like a charm

Dataset2:

Select *

from MyTable

Where Period = @Period;

@Period should get its values from @EndPeriod.

The idea is: Headcount report...

Ok. got that sorted by choosing non-queried for available values and setting the value to '=Parameters!EndPeriod.Value. However that makes my query extremly slow

Please help

Thanks everyone for your input. it was helpful

Hi! Thank you very much.

Yes I'm in South Africa. I work for Nedbank.

Thanks for the question you asked. I removed the tick from multivalue and the check boxes disapeared and...

Ok. Got that sorted. I had to create a seperate dataset for that. Now my other question is:

Why does this dropdown list have checkboxes and how do I remove them....

The two statements are run on the same table. the problem is:

The column headcount does not have a field called transfares, It only has two fields called 'transfarein' and 'transfareout'.

I...