ssrs and RDLC in c#

Question

plz tell me about RDLC and SSRS..in detail and how we use it to create reports from multiple tables??

Manoj Bhoir · Answer

Hi RDLC stands for Client Report Definition File . You can read more about RDLC here : What is RDLC File? Now For your second question Microsoft SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of a suite of Microsoft SQL Server services. The SSRS service provides a unique interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. You can read my artilce on SSRS here : Getting Started With SQL Server Reporting Services (SSRS) - Part 1 You can create Report from multiple Tables. You can use N number of tables with Inner join or (SQL Joins) to create dataset and based on that you can show data in your report. Only one thing i want to suggest you here don't forget to optimized your query if you are using multiple tables in a query. Otherwise your report will take lots of time for the rendering.