1. Difference between Logical Page an Physical Page in SSRS.
Logical page breaks are page
breaks that you insert before or after report items or groups. Page breaks help
to determine how the content is fitted to a report page for optimal viewing
when rendering or exporting the report.
The following rules apply when
rendering logical page breaks:
- Logical page breaks are ignored for report items that are
constantly hidden and for report items where the visibility is controlled
by clicking another report item.
- Logical page breaks are applied on conditionally visible
items if they are currently visible at the time the report is rendered.
- Space is preserved between the report item with the logical
page break and its peer report items.
- Logical page breaks that are inserted before a report item
push the report item down to the next page. The report item is rendered at
the top of the next page.
- Logical page breaks defined on items in table or matrix cells
are not kept. This does not apply to items in lists.
2. How to configure SSRS for Disaster recovery.
Depends on daily backup technique.
3. Describe the role of Encrpytion key in Report Server
Configuration manager.
A> To encrypt credentials, connection strings. Can be taken
backup and restore when required from configuration manager.
4. User want only to display only pdf as export option in report
Manager .. Describe Steps to perform this .
A>
using System.Reflection;
using Microsoft.Reporting.WebForms;
using Microsoft.Reporting.WebForms;
public void DisableUnwantedExportFormats()
{
foreach(RenderingExtension extension in serverReport.ListRenderingExtensions())
{
if(extension.Name == "XML" || extension.Name == "IMAGE"
|| extension.Name == "MHTML")
ReflectivelySetVisibilityFalse(extension);
}
}
{
foreach(RenderingExtension extension in serverReport.ListRenderingExtensions())
{
if(extension.Name == "XML" || extension.Name == "IMAGE"
|| extension.Name == "MHTML")
ReflectivelySetVisibilityFalse(extension);
}
}
5. Name and Describe few console utilities for SSRS.
|
RSConfig.exe
|
Configuration of connection
properties between the Report Server to the repository database.
|
|
RSKeyMgmt.exe
|
Management of encryption keys
via command-line
|
|
RS.exe
|
Scripting of report
deployment
|
6. Name few Endpoints exposed by SSRs 2008.
o Management Endpoints
o Execution Endpoint
o SharePoint Proxy Endpoints
7. How can you access the Code in You report. Describe the Static
and intance based method with example.
A> Static methods within a custom
assembly are available globally within the report. You can access static
methods in expressions by namespace, class, and method name
The following example calls the
method ToGBP, which converts the
StandardCost field value from dollar to pounds sterling:
=CurrencyConversion.DollarCurrencyConversion.ToGBP(Fields!StandardCost.Value)
Instance-based methods are
available through a globally defined Code member. You access these by referring to theCode member, and then the instance and method name. The following
example calls the instance method ToEURwhich converts the StandardCost field value from dollar to euro:
=Code.m_myDollarCoversion.ToEUR(Fields!StandardCost.Value)
8. how to add custom Assemblies to Report.
1. On the Report menu, click Report Properties
2. On the References tab,
do the following:
a. In References,
click the add (...) button and then select or
browse to the assembly from the Add Reference dialog box.
b. In Classes, type name of the class and
provide an instance name to use within the report.
9. What is Linked Report.
A> A linked report is a
report server item that provides an access point to an existing report.
Conceptually, it is similar to a program shortcut that you use to run a program
or open a file.
10. What are different types of roles provided by SSRS?
A>
1. Browser
2. Content Manager
3. My Reports
4. Publisher
5. Report Builder
11. Describe different Processing Modes offered by SSRS.
Local Processing Mode:
Processes reports in the client application.
Remote Processing Mode:
Renders server reports that are processed on a SQL
Server Reporting Services report server.
12. When to Use Null Data driven Subscription?
Create a data-driven
subscription that uses the Null Delivery Provider. When you specify the Null
Delivery Provider as the method of delivery in the subscription, the report
server targets the report server database as the delivery destination and uses
a specialized rendering extension called the null rendering extension. In
contrast with other delivery extensions, the Null Delivery Provider does not
have delivery settings that you can configure through a subscription
definition.
13. What Factors need to take into consideration while designing a
international report (Localization).
14. What are different option to deploy report from Dev to Prod.
Ø From Solution Explorer by
giving Target Sever URL
Ø Uploading the .rdl from Report
manager.
15. What are the new Controls / Features added in SSRS 2008
/ SSRS 2008 R2
16. How can you monitor the report Usage.
You can query theReportServer
database for this information as follows:
SELECT
ex.UserName, ex.Format, ex.TimeStart, cat.Name,
ex.Parameters,
CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate
FROM ExecutionLog AS ex, Catalog AS cat
where ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart DESC
Regards
SELECT
ex.UserName, ex.Format, ex.TimeStart, cat.Name,
ex.Parameters,
CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate
FROM ExecutionLog AS ex, Catalog AS cat
where ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart DESC
Regards
17. How can you add a new report User to report manager.
18. How can you create the dynamaic Datasource. Can a Shared
Datasource be Dynamic?
19. A report is Performing poorly . What steps you would take to
troubleshoot the Issue.
20. Write an Expression to perform a Division of two Integers
fields and to avoid NAN error.
21. have you ever used Rank, Dense Rank Ntile, CTE and Pivot..
22. Is SSRs 2008 dependent on IIS? if not how it perform the
operations.
No comments:
Post a Comment