There are two types of datasets: shared and embedded. To create a shared dataset, we will need to have access to SQL Reporting Services, as the shared dataset will be stored there to be accessible for future reports. If we don't have access to the SQL Server Reporting Services, we can skip this step and create an embedded dataset that will be embedded within our report (RDL file).
To create a new shared dataset, follow the ensuing steps:
Click on New Dataset.
Click on the Browse other data sources link and find the MSCRM_DataSource data source for our organization; it will usually be located in a folder with our organization name plus the
_MSCRM
suffix, for example,CRMORG_MSCRM
. These are shared data sources that were created by the CRM Setup application when the CRM was initially deployed.Note
If we are using the standalone version of Report Builder, we won't be able to create or browse shared data sources.
There are also two main types of data sources: embedded and shared. The shared...