SQL Server Reporting Services (SSRS)

2.Can you explain Report definition language (RDL) file in reporting services?

-RDL is an XML description of a report in reporting services. So basically the RDL file has the XML grammar which describes a reporting services report

3. what are the basic process of making a report in reporting services?

Here are the basic steps which will help you in creating reports in reporting services:-
. Open Visual studio 2005
à File à New project
à Select 'Business Intelligence Reports'
à Select Report Server project..
When the project is created in the solution explorer you will see two folder 'Shared data resources' ( we will come to data sources in the coming questions) and 'Reports'. Right click the 'Reports' folder and click add new reports.. You need to give credentials in the wizard. Once done it pops up a query builder. Specify the report query in the query builder and go next.. Wizard then helps you to select the report type and some other features. Next , next and you should see a RDL file in your 'Reports' folder. . Click on the view menu and select tool box and you should be able to design the report.. Till now we are only in the design mode of report. As said previously all reports meta-data are stored in SQL Server database 'ReportServer'. In order that the report's meta-data gets saved in database we need to publish the report.. To publish the report we need to specify the IIS report path. So right click on the report project, select properties and specify the 'TargetServerURL' property.


4. How can we consume the reports in ASP.NET?

There are three famous ways of calling reporting services report in ASP.NET:-
. Using URL way to access reports..
Using reporting web service to programmatically access reports..
Using report viewer control.

5.Can you explain the difference between private and shared data sources?

Private data source is used by single report only while shared data sources are shared between reports. As a practice it is good to have shared data source so if you want to change anything you need to change only on one data source.
6.How does reports caching in reporting services work ?

reporting services has two main databases 'ReportServer' and 'ReportServerTempDB'

SQL Server Reporting Services (SSRS)

1,In IIS we have two applications 'Reports' and 'Reportserver', what do they do?

While installing reporting services there are two virtual directories created Reports and Reportserver.-The 'Reports' virtual directory is like an admin. If you browse to http://yourpcname/reports/home.aspx page you can view, edit properties and display reports-The second virtual directory is the 'ReportServer' this helps us to use browse reports and use the same in ASP.NET code using URL methodology , try browsing to http://yourpcname/reportserver/ you can easily figure out what this virtual directory is all about