SSRS Interview Quesions and Answers Part-2
-Development
Q11. What is difference between Tablular and Matrix report?
OR What are the different styles of reports?
Tablular report: A tabular report is the most basic type of report. Each column corresponds to a column selected from the database.
Matrix report: A matrix (cross-product) report is a cross-tabulation of four groups of data:
a. One group of data is displayed across the page.
b. One group of data is displayed down the page.
c. One group of data is the cross-product, which determines all possible locations where the across and down data relate and places a cell in those locations.
d. One group of data is displayed as the "filler" of the cells.
Martix reports can be considered more of a Pivot table.
Q12. How to create Drill-through reports?
Using Navigation property of a cell and setting child report and its parameters in it.
Q13. How to create Drill-Down reports?
To cut the story short:
- By grouping data on required fields
Q11. What is difference between Tablular and Matrix report?
OR What are the different styles of reports?
Tablular report: A tabular report is the most basic type of report. Each column corresponds to a column selected from the database.
Matrix report: A matrix (cross-product) report is a cross-tabulation of four groups of data:
a. One group of data is displayed across the page.
b. One group of data is displayed down the page.
c. One group of data is the cross-product, which determines all possible locations where the across and down data relate and places a cell in those locations.
d. One group of data is displayed as the "filler" of the cells.
Martix reports can be considered more of a Pivot table.
Q12. How to create Drill-through reports?
Using Navigation property of a cell and setting child report and its parameters in it.
Q13. How to create Drill-Down reports?
To cut the story short:
- By grouping data on required fields
-Then toggle visibility based on the
grouped filed
Q14. What
is a Published Report?
A report that is deployed on the report server for viewing is called published report.
A report that is deployed on the report server for viewing is called published report.
Q15. What
is a sub report?
Sub report is a report inside a main report. Typically, when you want to use a different data source than the main report, you go for sub report.
Sub report is a report inside a main report. Typically, when you want to use a different data source than the main report, you go for sub report.
Q16. What is a data region in SSRS 2008 ?
Ans: The region where the data is displayed from the dataset is the Data region and columns.
Q17. What are the different data regions ?
Ans: Chart, Gauge, List, Matrix and Table.
Q18. What is a Tablix ?
Ans: Tablix is a common term for supporting multiple rows and columns. The rows can be static or dynamic. Table, Matrix and list data regions are based on tablix.
Ans: The region where the data is displayed from the dataset is the Data region and columns.
Q17. What are the different data regions ?
Ans: Chart, Gauge, List, Matrix and Table.
Q18. What is a Tablix ?
Ans: Tablix is a common term for supporting multiple rows and columns. The rows can be static or dynamic. Table, Matrix and list data regions are based on tablix.
Q19. Can you always create a
cache of a report?
No, you can create a cache of a report only when certain requirements, such as having credentials stored in the Report Server, are met.
No, you can create a cache of a report only when certain requirements, such as having credentials stored in the Report Server, are met.
Q20. What mechanisms do you
identify to reduce the overhead of Reporting Services data sources?
Snapshots and cached reports can help reduce the processing pressure on data sources and improve report response time.
Snapshots and cached reports can help reduce the processing pressure on data sources and improve report response time.
Q21. SQL Server Reporting Services vs Crystal
Reports?
Crystal reports are processed by
IIS while SSSR have a report server. Caching in Crystal reports is available
through cache server. On the other hand, caching in SSSR is available for
Report history snapshots. Crystal reports have standards and user defined field
labels. SSSR allows only user defined field labels.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment