Skip to main content

SSRS Reports - Interview Question - SQL Server Reporting Services

  1. What is a linked report,what is the use of it?
  2. What is Placeholder; use of placeholder?
  3. What is Drilldown report?
  4. What is Drill through report?
  5. What is the most complex report you have developed?
  6. How to get the values from two data sets into a single table in SSRS?
  7. How to deploy the reports on SQL server? / Ways to deploy the reports on Server?
  8. How to set alternate row color banding in SSRS?
  9. What is data driven subscription in SSRS?
  10. From where we can get the reports execution details?
  11. What are the difference btwn SSRS 2005 and 2008 R2 version?
  12. Can we create the reports using report builder without using the report model?
  13. What is a snapshot report and what is the use of it?
  14. What are the Cascaded parameters in SSRS and how to create them?
  15. Can you list down some Built in fields/Global variables in SSRS Reports?
  16. What is the difference btwn Table and Matrix Report?
  17. How to create dynamic grouping based on the value selected in a filter the Report?
  18. How to dynamic sort the data based on the value selected in a filter the Report?
  19. What is intractive sort in SSRS?
  20. How to set the export option to the Excel only for one report only not all the report(disable all the other rendring option other then Excel for one report)?
  21. What are the points which needs to be considered while designing a report for the Report Performance?

Labels:

Comments

Post a Comment

Popular posts from this blog

SSRS Reports - Space/Gap issue between the objects in SSRS Reports

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the o...
5 comments
Read more

SSRS Reports - When few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the obj...
Post a Comment
Read more

SSRS Reports - How to Create Static Rows in a Matrix in SSRS?

Today one of my team members asked me about how to create a matrix in which the rows will remain static/constant and the column group will grow as per the data available. SQL Server Reporting Services 1. Create a data set to get the required data for the matrix. 2. Drag a matrix object on the report body. 3. Add the number of required rows to outside the row group  (This is the main trick for creating the static rows in the matrix) 4. Delete the row group detail row from the matrix 5. Add the labels to the row lines headers, add the column group values and data values in the matrix 6. Run the Report and your Matrix is ready with Static Rows! Happy learning!!!
1 comment
Read more