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

Adding report objects

We might have formatted our data, but it doesn't look any better at this point. We still need more elements in the report to get the right look and feel that we want.

Let's delete the Category, Subcategory, and Product columns, and switch the page orientation from landscape to portrait. Make room for three textboxes at the top of the table, and then, drag-and-drop three textboxes as shown in the following screenshot:

Adding report objects
  1. Add the following expressions in the three textboxes:
    ="Category: " & Parameters!Category.Value(0)
    ="Subcategory: " & Parameters!Subcategory.Value(0)
    ="Product: " + Join(Parameters!Product.Label,",")
    
  2. Let's run our ...

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