Saturday, January 29, 2011

Interview Questions and Answers for SQL Server Reporting Services (SSRS) : Series 7

Question: Which language rdl files made of?
Answer:    RDL files are written in XML.
Question: What is the chart in report?
Answer:    Chart reports are for graphical representation. You can get pie charts columns harts and various other options.
3d charts are also available in reporting services.
Question: What is Data Set in report?
Answer:    Data set are the set of data which we want to show in report. Data creates on data source. Data source is the source of data from where we are getting this data i.e. database server and database name connection string.
Question: What are the different types of data sources in SSRS?
Answer:    SSRS use different data source. Some of them are listed below.
1.      Microsoft SQL Server
2.      OLEDB
3.      Oracle
4.      ODBC
5.      SQL Server Analysis Service
6.      Report Server Model
7.      SAP Net weaver BI
8.      Hyperion
9.      Teradata
10.  XML
Question: What is the web service used for reporting services?
Answer:    Reporting Service Web Service used in SSRS. By accessing this web service you can access all report server component and also get the report deployed on report server.