Hello everyone!
So I have 4 datasets and 4 parameters. All of the parameters can be used in the 1st Dataset called wo and are able to be toggled on and off.. So you can use 1,3,4 parameter, 1 parameter or all 4 parameter. So I got the 1st dataset to work.
Now the second dataset has labor data. What I want and need to happen is when those parameters are set they pull a field that is called workorder-numbers. So any workorder-numbers in the 1st dataset should pull all the workorder-numbers from the second dataset based off the parameters filtered from wo dataset.
Dataset1
Select
workorder-number, statuscall, divcode, tech, salesman
from wo
where (@Statuscall IS NULL OR
[Status-Call] = @Statuscall) AND (@Divcode IS NULL OR
[div-code] = @Divcode) AND (@Salesman IS NULL OR
[Slspn-code1] = @Salesman) AND (@Tech IS NULL OR
[Slspn-code] = @Tech)
Dataset2
Select workorder-number, laborhr, labor-rate, tech
from wolabor
WHERE ??????????