Apr 27, 2015

SSRS Interview Questions & Answers (Part-4)

Q: Is SSRS support other database except MS SQL Server?
Yes. SSRS can be building based on relational or multidimensional data source like Oracle, OLEDB. ODBC etc

Q. What is Tabular Report in SSRS?
Tabular report is the simplest of the SSRS Report. It lets you just simply display the data using table.
Tabular Report Step by Step Example...

Q: What is a Matrix in SSRS?
A matrix is a data region linked to a report set. Matrix allows us to create crosstab reports with the report variables displaying on rows and columns. It allows us to drag and drop fields into it.
Matrix Report Step by Step Example...

Q: What is Query parameter in SSRS?
Query parameter is mentioned in the query of the data-source that is to be included in the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can not begin with numeral. For clarity, we use only letters.
Query Parameter Step by Step Example...

Q: What are Sub Reports and how to create them?
A sub report is like any other reports which can be called in main report and can be generate through main report. Parameters can be passed from main report to sub report and basis of that report can be generated.
Sub Report Step by Step Example...

Q: What is the chart in report?
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.

Q. What is RowNumber function?
RowNumber returns a sequential number to every row within the specified scope.
RowNumber Example...

Q: How to add the custom code in Report?
To add the custom codes in report go to report tab on top then properties and there you will find the options for custom code.

Q: In case you have filters in your report, when filters will be applied in Cached Report instance?
Filters are applied when a report is rendered, Filters will not create a new cached instance on the Report Server.
Filter Parameter Step by Step Example...

Q: What are data regions?
Data regions are report items that display repeated rows of summarized information from data-sets.

Q: You want to generate a report that is formatted as a chart. Can you use the Report Wizard to create such a report?
No, the Report Wizard lets you create only Tabular and Matrix reports. you must create the chart report directly by using the Report Designer.

Q: Can we use data-grids for our report in SSRS?
We have an ASP.NET project that populates a data-grid. Using data-grid as my data-source for my report using SQL Server Reporting Services. Is this possible? The simple answer is no. However, nothing's ever simple. A set of reporting controls was added in Visual Studio 2010 allowing you to report in a data-set, on data that was supplied by you. So, if you retrieved your data into a data-set, bound the data-grid to the data-set so it had data to display, you could then use that data-set as the data-source for the reporting controls. These are then client-side reports, not server reports though.

    Choose :
  • OR
  • To comment
3 comments:
Write Comments
  1. HI,
    I have 2 columns:

    Date Type
    1/1/2015 A
    3/2/2015 B

    And I want to show table with:
    Date A Type Date B Type
    1/1/2015 A 3/2/2015 B
    And question is HOW? :)
    Thanx

    ReplyDelete
    Replies
    1. Sorry, your query is unclear to me.
      In the output you have 6 values in column Header Section while 4 values in the data section?
      Need more clarity on your requirement.

      Delete
  2. Sorry, your query is unclear to me.

    In the output you have 6 values in column Header Section while 4 values in the data section?

    Need more clarity on your requirement.

    ReplyDelete