1) You want to include an Image in a SSRS Report how do you display the Image properties dialog box?
When you drag the image item from the Tool box window to the Report Designer, the Image
properties dialog box automatically opens.
2) You want to configure an amount to display the values in a Currency format, which property do you use?
To configure an amount to display a value in a currency format, select the report item, and then set
the format property to C to c.
3) You want to generate a report that is formatted as a chat, can you use the report wizard to create such a report?
No report wizard lets you create only Tabular and Matrix reports. You must create chat report directly by using the report designer.
4) You want to use BIDS to deploy the report to different server then the one you choose in the report wizard. How can you change the server URL?
Right click on the project Properties in the Solution Explorer and then change the Target serverURL property.
5) Which Rendering formats effected by the Page size properties?
Because of only PDF file,Word and Image rendering extensions use the Physical page breaks, they are the only properties that are effected by the page size.
6) What are all the main elements of Dataset?
Data Source,Command Type and Query String.
7) Can you use Store Procedure to provide data to an SSRS Report ?
Yes we can use a Stored Procedure to provide data to an SSRS report by configuring the dataset to
use a stored procedure command type.
8) You want to use perspective of MDX query. How do you select perspective ?
Use the CUBE Selector in the MDX Query Designer to select the perspective.
9) can you use data mining models to SSRS Reports?
Yes you can use DMX designer to create the data mining queries for SSRS reports.
10) What is Action in SSRS ? what are the Types of Actions that SSRS support?
Actions are response to the user clicks in the report item. Three types of Actions that SSRS
support.
- Go To Report
- Go To Bookmark
- Go To URL
11) You want your report to display a hyperlink that will take users to your internet.
How do you configure such Hyper Link ?
Create a Text box item set the action to Go To URL, and then Configure to the URL.
12) What are all the Two running Aggregate functions that SSRS support?
- Row Number
- Running Value
Row Number : Row Number returns the running count of rows in data set.
Running Value : This function lets you specify the aggregate function that the
report should use to calculate the value.
Example : Sum, Avg
13) When you do not use report caching, is it better to use report parameter to filter the
information in the query or to use filter in the data set?
For performance prospective, it is better to use parameters because they let SSRS
pull filtered data from the data source. In contrast, when you use filters, the queries retrieves
all data and filters the information in an additional step.
14) How do you configure a Running Aggregate in SSRS?
Use the Running Value function
15) What are all the Control functions in SSRS?
IIF, Switch and Choose
16) What are all the Built in Functions in SSRS?
Built in function expressions use Built in Report functions to configure the report property. In
addition to the control flow functions, SSRS includes Text, Date & Time, Math, Inspection,
Program Flow, Aggregate, financial, conversion, and miscellaneous functions to create
expressions.
17) What is the main benefit of using embedded code in a report?
The main benefit of using embedded code in a report is that the code you write at
the report level can be reused in any expression in the report.
The main benefit of using embedded code in a report is that the code you write at
the report level can be reused in any expression in the report.
18) What programming language would you use to create embedded functions in the
SSRS ?
An SSRS Report supports only VB.Net code.
19) How do you reference an embedded function in a report embedded?
Use the code prefix and the name of the function to reference an embedded
function in a report expression.
20) Why should not overwrite share data source in production?
You should not overwrite the share data source in a production because the administrative
has a probability already changed some connection string properties.
21) Can you edit a report that an end user created by using report builder in BIDS?
Yes if an end user created a report by using report Builder in BIDS and saved the
report definition file, you can ope the file in BIDS and edit it.
22) What is meant by Tabular report?
A tabular report is the basic report type. Each column corresponds to a column selected
from the database.
23) What is mean by Matrix report:
Matrix report is similar to Tabular Report. It displays grouped data and summarized information.
You can group data by multiple fields or expressions in a row and column groups.
24) What are all the steps will take by the Report Processor when report is Requested
When
a report request is received, the Report Processor takes the following steps
- It determines which report is being asked for and retrieves the report definition from the Report Server Database.
- The Report Processor asks for the data. This is call made into the data processing extensions.
- The Report Processor combines the two into an
intermediate format. The Intermediate format is then sent to the
rendering extensions for delivery.
25) What is RDL?
RDL means Report Definition Language. It is a XML document that defines the elements of
a report. It is this file that is eventually published
to the Report Server. Once the file is
published, the report definition is
stored in the database.
Any subsequent publishing of the
report replaces most of the definition stored in the Report Server.
