Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
52 Cards in this Set
- Front
- Back
|
What are the two types of parameters SSRS uses?
|
Query paramaters (aka dataset parameters) and report parameters
|
|
|
What prperties are in query paramaters and what are in report paramaters?
|
Query: Name and value (can be an expression)
Report: Name, type, value, prompt, available values, default values, and so on |
|
|
Where are query paramaters and report paramaters managed?
|
Query paramaters are managed through the dataset while report paramaters are managed through the report paramaters dialog box
|
|
|
Which should you add first--query paramaters or report paramaters?
|
Start with query parameters and let the Report Desinger add report paramaters automatically
|
|
|
What are report paramaters for?
|
Giving users ways to interact with charts
|
|
|
What task must you do to assign a list of values that users can selct from?
|
You must bind datasets to parameters
|
|
|
What three conditions must be met if you want to use multivalued paramaters for the query?
|
1. The data source must be SQL Server, ORacle, SSAS, SAP BI NetWeaver, or Hyperion Essbase
2. The source query cannot be a stored procedure--you cannot pass an array to a stored procedure in SSRS 2008 3. The query must use an IN (@paramater) clause to specify the paramter, for example: SELECT * FROM dbo.vTargetMail WHERE EnglishOccupation IN (@Occupation) |
|
|
What should you do to avoid SQL injection if your multivalued paramater is a string data type?
|
Create an explicit list of available values, either created manually or from a dataset. Don't let users enter the values manually in a text box.
|
|
|
What are your three options for choosing a default value for a paramater?
|
1. No default value
2. Specify values 3. Get values from a query |
|
|
If you provide paramaters through a URL, what are the four parts of the URL?
|
1. Report server URL: http://localhost/ReportServer?
2. Report path: ?2fLogistics%2fTracking+Numbers+by+Month& 3. Command section: &rs:Command=Render 4. Paramaters section: &Department=1 |
|
|
What are query paramaters for?
|
Filtering data in the data source
|
|
|
If you want users to select a paramater from a list of values in a list box how should you configure the paramater?
|
Create a data source that contains the possible values and then bind the data source to the paramater
|
|
|
What is a field expression?
|
It can be a simple reference to a field in a dataset or a simple operation based on fields. Some examples of field expressions include: Value, Color, or several values concatenated
|
|
|
What is a control flow expression?
|
A control flow or a decisions expression is one that, based on one or more conditions, returns a value to change the formatting or displayed value of the report.
|
|
|
What are the three control flow functions?
|
IIF
Switch Choose |
|
|
Which would you use if you wanted a red, yellow, or green color based on value?
|
Switch
|
|
|
What language do you write embedded code?
|
Visual Basic
|
|
|
What are the main advantages of using embedded code?
|
Extensibilty and reusability, becuase the code embedded at the report level can extend SSRS fucntions and be reused in any expression of the report
|
|
|
If you want to add custom code to multiple reports what should you use?
|
A custom assembly
|
|
|
What language do you use for custom assemblies?
|
Any .NET language such as Visual C#
|
|
|
What are two ways to deploy custom assemblies?
|
Copy the assembly file to the applicaitons folders of your SSRS server and the report designer
Install your custom assembly in the global assemby cache (GAC) |
|
|
What is the default permission for custom assemblies and when is that permission not enough?
|
The default permission is Execution, if you need to access resources outside the report itself you must grant additional privileges
|
|
|
How do you grant additional permissions to the custom assembly?
|
edit the rssrvpolicy.config configuration file for the report server and the rspreviewpolicy.config configuration file for the Report Designer
|
|
|
How are custom assemblies controlled?
|
.NET Code access security
|
|
|
What do you need to do if you change code lements already referenced in published reports?
|
You need to update the version of the assembly referenced in the CodeModules element of the report definition and the republish the reports
|
|
|
After you have deployed your custom assembly, how do you access the clsses in it?
|
Using report expressions
|
|
|
Which performs better--static or instance-based members of your classes?
|
static
|
|
|
Why should you not use static fields or properties, only static methods?
|
Because all reports are executed in the same application domains, so static data is available to all uers concurrently running the same report, which can create a mess in static fields and properties
|
|
|
What must you have installed to create a custom assembly?
|
A full version of Microsoft Visual Studio 2008 with Visual basic .NET, Visual c# or other .NET language template installed
|
|
|
How do you reference an embedded function in a report expression?
|
Use the Code prefix and the name of the function to reference an embedded function in a report expression
|
|
|
What are four options for presenting reports to end users?
|
1. Deploy reports to the local report server so users can use Report Manager to view reports
2. Embed URLS in reports and publish on a web portal 3. Use SharePoint Web parts to explore the report server and view reportes 4. Use the .NET Framework report viewer controls to display reports in a custom Windows or Web application |
|
|
What is it called when you temporarliy deploy reports to seperate locations for testing?
|
Staging the reports
|
|
|
What is the principle of least privilege?
|
Give the users the minimal possible permission that still enables them to do their job
|
|
|
Why should you use query timeouts?
|
To preven long-running queries on production servers
|
|
|
What do data-drive subscriptions do?
|
Enable you to control report paramaters, delivery channels, rending methods for each end user separately
|
|
|
What are the three default configurations the Report Designer in BIDS provides for deployment?
|
DebugLocal, Debug, Release
|
|
|
What are five properties you can control through deployment configurations?
|
OverwriteDataSources
StartItem TargetDataSourceFolders TargetReportFolder TargetServerURL |
|
|
What does the StartItem Deployment Configuration property do?
|
It is a debug property specifiying the report to display in the Preview window or in the Browser window when you run the project
|
|
|
What is the administrative tool used to deploy SSRS reports?
|
Report Manager
|
|
|
What deployment option ended for SSRS 2008?
|
You can no longer deploy reports using SQL Server Management Studio SSMS
|
|
|
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
|
|
|
What are the two kinds of endpoints SSUS Web Service provides?
|
One for report execution and one for report management
|
|
|
What are the two management endpoints?
|
ReportService 2005 and ReportService 2006
|
|
|
When can you use ReportService 2005?
|
If SSRS is configured in native mode
|
|
|
What management endpoint should you use if your report server is configured in SharePoint configuration mode?
|
ReportService 2006
|
|
|
How do you add a service or Web reference in your project?
|
Using a Web Services Description Language WSDL
|
|
|
What is the only execution endpoint?
|
ReportExecution2005
|
|
|
Is ReportExecution2005 compatible with SharePoint integrated mode?
|
yes
|
|
|
The MicrosoftReportViewer controls that come with Visual Studio 2008 cannot do what?
|
Render SSRS 2008 reports in local mode
|
|
|
In which processing mode of a report viewer control can you use the full functionality of the report server?
|
Remote processing mode
|
|
|
What do you use report models for?
|
Help users create their own reports without having to lean database schema or the SQL language
|
|
|
What do you use to create and personalize relational report models?
|
BIDS
|
