Monthly Archives: January 2011

SQL Server reporting service tool is the Microsoft reporting tool. SSRS requirement is growing across the organizations and they are looking for skilled SSRS resource.I am sharing SSRS interview Questions here. These cover all most all parts of the SSRS. … Continue reading →

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 … Continue reading →

Question: In which SQL Server version report builder introduced? Answer:   Report builder introduced in SQL Server 2005. While creating or deploying report model project on report server you can get error or it might not get created. For this you … Continue reading →

Question: What are the drilldown reports? Give one example. Answer:   Drill down reports is the reports which can collapse or expand as per requirement i.e. information can be drilled down in to minor level information if required. For example when … Continue reading →

Question: What is report subscription? Answer:  Report subscription is to schedule the resource on particular time and to send a mailer to particular users. You can find this functionality on report server for each report. Question: What is the RDL … Continue reading →

Question: What is the report rendering? Answer:    Report rendering is to call the report from server to application. Report rendering can be possible through different ways. Question: What are the different types of report rendering methods? Answer:    There two methods … Continue reading →

Question: Explain SSRS 2005 architecture? Answer:    SSRS 2005 architecture 1.      Report Designer 2.      Report Builder 3.      Report manager 4.      Report server 5.      Report Server database 6.      Report Sources Question: What is the report rendering? Answer:   Report rendering is to call … Continue reading →

Question: What is SQL Server Reporting Services? Answer: SSRS is reporting tool which comes with Microsoft SQL Server. It’s a part of BI suite which SQL Server incorporates with it. SSRS is free with Microsoft SQL Server and used to … Continue reading →