Category Archives: SSRS Interview Questions

If a report is not generating any error but still the toggling is not working properly i.e. the expansion is not happening on + button click then there could be one main reason that this error might be coming because … Continue reading →

I am posting the questions and answers one by one irrespective of topics so i can give more detailed answers for questions.To view consolidated questions topic wise you can go and click the content in side bar and check all questions … Continue reading →

Adhoc Reports (In SQL Server Reporting Services) are the reports which user can create using report model project (User here refers to end user who is using the application). These reports have a predefined layout which is a standard layout … Continue reading →

The built in field [&pagenumber] and [&pagetotal] cannot be used in report body as these are applicable in report header or report footer. These built in field can be added in footer or header for better representation of the report.

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 →