Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 285

3. Place a check mark for Has Default , type in France in the Default Value

textbox and place check mark for Hide . The check mark is removed from
Prompt User and the Display Text field will be disabled.

4. Click on Apply . It immediately takes effect.

5. Return to HOME | France and display the report and you should see

the France related customer information only.

6. Repeat the same for Germany .

7. Now, when you click on France or Germany you will see only data

related to those countries in the report.

Creating a report with XML data sources
XML is text based and well suited for data exchange and XML data can be easily
parsed. Most browsers can directly deal with XML data as it is an Internet-standard
format. XML data can come from many sources such as data from Web services,
data from Excel documents, and many others.

XML data is being used extensively between businesses and there are times you
may need to create reports using XML-formatted data. This hands-on exercise shows
a simple example of creating a report based on data in an XML file. This file can be
on your desktop/laptop or on the server.

To understand how we create a report using XML data, we should have XML data
to start with. If not, we need to create XML data. You could write an XML file with
Notepad with some data in which you are interested, such as contact details. In the
following, we create an XML source from a table in the Northwind database.