Adding embedded codes to reports

With this recipe, let's see how to add a parameter in order to accept a value that can be converted to a date and use it for the dataset.

Getting ready

The solution related to this chapter is named as Chapter12.sln. We will be using this solution for working with recipes and the report we use for this recipe is DailySales. Now publish the solution. If you do not have the solution, you need to create a report with the given query that connects with the WideWorldImportersDW database. Following are the steps:

1. Open the Chapter12.sln solution and configure the data source DataSourceWideWorldImportersDW with settings related to your database server and configure the Reporting Services server settings.
2. If you are making your own report, make sure that the following query is used and the table data region is added as per the output shown in the Figure 12.01:

         SELECT s.[Invoice Date Key], c.Customer, ct.City + ' - ' + ct.
         State Province...