O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a radio button parameter

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 (TRUE or FALSE).

This parameter is checked against a column in the underlying table named OnlineOrderFlag, which holds a value of either 0 or 1 (BIT); 1 returns 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required