-
Book Overview & Buying
-
Table Of Contents
Microsoft Dynamics CRM 2011 Reporting
By :
As with data sources, we can have more than one data set defined in our report; however, each data set is associated with one data source at a time. To create a new Data set follow the given steps:
Right-click on the Datasets folder and select the Add Dataset… menu option:

When the Dataset Properties dialog box opens, we will be presented with the following options:

Here we can select to use a shared data set or create a data set that will be embedded in our report; the concept is the same as explained for data sources.
If we want to create a shared data set, we will need to cancel this dialog box and go to the Solution Explorer window, right-click on the Shared Datasets folder, and select the Add New Dataset option:

When adding a new shared data set we will need to specify the Data Source, Query type, and Query.

Enter AccountsDataSet in the Name field and select MyCRMDataSource from the Data source drop-down menu list.
We can either write the query manually or use the query designer...
Change the font size
Change margin width
Change background colour