You can use SQL Reporting Services to develop report templates. Moreover, if you have your own SQL Server, you can create reports using SQL Server Reporting Services (SSRS). For rdlc, the app wheere the report document is attached will push the data into the report document via dataset or datatable. See Attach Report Document to an App for details.
•Push data via dataset or datatable into the rdlc file
•Subreports and drilldown reports are also supported by the system
•Built-in reporting services viewer for viewing the reports
•For advance reporting services, you may use SSRS.
Google SSRS for more details on how to create report document using SQL Server.