I am working on a task using Report Builder to create reports where I need to filter data based on dates related to Orders of Service (OS).
I am using parameters @StartDate and @EndDate to allow the user to select a date range to filter the data.
How can I adjust the datasets to include the necessary WHERE clauses to correctly filter the data based on the dates of the Orders of Service (OS) associated with each contractor, contract, and lot?
SELECT * FROM Company WHERE RegistrationDate BETWEEN @StartDate AND @DateFim and @EndDate.