There might be different reasons why we can find some limitations with the reports created in SQL Server Reporting Services (SSRS); for example, using some dynamic controls, which are already available for ASP.NET and are not needed on an RDL report, might be a good reason to think about creating our own custom report in ASP.NET.
Open Visual Studio 2012 and create a new website application as shown in the following screenshot:
When working with ASP.NET, we will need to manage the Dynamics CRM connections and opt for one of the methods used to connect our controls with the CRM entities' data records. We can use early or late binding, which will be described in detail next.
When connecting custom applications to Dynamics CRM, it is always recommended to not go directly to the database; instead, it is better to use the native CRM WCF services that are exposed for any application integration we might need to build.