Like I said, all the parameters shown in the previous screenshot are prebuilt by way of our stored procedure. That's including the radio button parameter at the top of our report.
How to do this? Let's take a look at our stored procedure.
You might have noticed that the first parameter is called
@IsOnline and is of T-SQL type BIT or Boolean (
This parameter is checked against a column in the underlying table named
OnlineOrderFlag, which holds a value of either
TRUE. We're passing this parameter in the
WHERE clause as shown in the following expression:
Select … From … Where OnlineOrderFlag = @IsOnline
So, let's run our report with some values. Supply the following data into their ...