• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/108

Click to flip

108 Cards in this Set

  • Front
  • Back
What is the perferred tool for delopers to create SSRS reports?
BIDS
What are the three templates for SSRS included in BIDS?
Report Server Project
Report Server Project Wizard
Report Model Project
What is the difference between Report Server Project and Report Server Project Wizard?
They are very similar except Report Server Project Wizard automatically starts the Report Wizard
What is a tabular report?
A report that has a predefined number of columns
What is a matrix report?
A report that uses data as the source to define the columns that the report will contain
Does the Report Wizard create tabular reports or matrix reports?
It will create either
What is a report model?
A report model is a metadata description, from a business point of view, of a data source and its relationships
What tool must you use to create a chart or a free-form report and why?
You must use the Report Designer if you want a chart or a free-form report because the wizard doesn't support these reports
what does the StartItem property in the Project Name Property Dialog Box do?
Lets you configure the report that will be automatically displayed when running the project for debugging purposes
What are the two possible defaul port number in BIDS TargetServerURL ProjectName Property Pages dialog box?
The default is port 80 unless you are running 32-bit Windows XP SP2 operating system, in which case its 8080
At what level is page layout configured?
The report level
How are the folowing paginated: CSV,Excel,HTML,Image,PDF,Word,XML?
CSV:None
Excel:Logical
HTML:Logical
Image:Physical
PDF:Physical
Word:Physical
XML:None
How are colors expressed in SSRS?
HTML color string
What type of reports do charts, tables, matrixes, and lists belong to?
Data regions
What are data regions?
Data regions are report items that display repeated rows of summarized information from datasets
What are the three types of data regions?
Tablix (lists,tables,or matrixes)
chart
gauge
What is a gauge always postioned inside?
A gauge panel
What are the two types of gauges?
Linear and radial
What can a tablix display?
Fields from a dataset, grouped or detailed, and in a grid or free-form layout
How many datasets can a Tablix be bound to?
Only one
What is the format string for Currency?
C or c
What is the format string for Decimal?
D or d
What is the format string for Scientific?
E or e
What is the format string for Fixed point?
F or f
What is the format string for General?
G or g
What is the format string for Number?
N or n
What is the format string for Percentage?
P or p
What is the format string for Round-trip?
R or r
What is the format string for Hexadecimal?
X or x
What is the format string for short date?
d
What is the format string for long date?
D
What is the format string for short time?
t
What is the format string for long time?
T
What is the perferred tool for delopers to create SSRS reports?
BIDS
What are the three templates for SSRS included in BIDS?
Report Server Project
Report Server Project Wizard
Report Model Project
What is the difference between Report Server Project and Report Server Project Wizard?
They are very similar except Report Server Project Wizard automatically starts the Report Wizard
What is a tabular report?
A report that has a predefined number of columns
What is a matrix report?
A report that uses data as the source to define the columns that the report will contain
Does the Report Wizard create tabular reports or matrix reports?
It will create either
What is a report model?
A report model is a metadata description, from a business point of view, of a data source and its relationships
What tool must you use to create a chart or a free-form report and why?
You must use the Report Designer if you want a chart or a free-form report because the wizard doesn't support these reports
what does the StartItem property in the Project Name Property Dialog Box do?
Lets you configure the report that will be automatically displayed when running the project for debugging purposes
What are the two possible defaul port number in BIDS TargetServerURL ProjectName Property Pages dialog box?
The default is port 80 unless you are running 32-bit Windows XP SP2 operating system, in which case its 8080
At what level is page layout configured?
The report level
How are the folowing paginated: CSV,Excel,HTML,Image,PDF,Word,XML?
CSV:None
Excel:Logical
HTML:Logical
Image:Physical
PDF:Physical
Word:Physical
XML:None
How are colors expressed in SSRS?
HTML color string
What type of reports do charts, tables, matrixes, and lists belong to?
Data regions
What are data regions?
Data regions are report items that display repeated rows of summarized information from datasets
What are the three types of data regions?
Tablix (lists,tables,or matrixes)
chart
gauge
What is a gauge always postioned inside?
A gauge panel
What are the two types of gauges?
Linear and radial
What can a tablix display?
Fields from a dataset, grouped or detailed, and in a grid or free-form layout
How many datasets can a Tablix be bound to?
Only one
What is the format string for Currency?
C or c
What is the format string for Decimal?
D or d
What is the format string for Scientific?
E or e
What is the format string for Fixed point?
F or f
What is the format string for General?
G or g
What is the format string for Number?
N or n
What is the format string for Percentage?
P or p
What is the format string for Round-trip?
R or r
What is the format string for Hexadecimal?
X or x
What is the format string for short date?
d
What is the format string for long date?
D
What is the format string for short time?
t
What is the format string for long time?
T
What is the format string for full date/time (short time)
f
What is the format string for full date/time (long time)
F
What is the format string for general date/time (short time)
g
What is the format string for general date/time (long time)
G
What is the format string for Month day?
M or m
What is the format string for round trip?
O or o
What is the format string for RFC1123 pattern?
R or r
What is the format string for sortable date/time?
S
What is the format string for universal sortable date/time?
U
What is the format string for universal full date/time?
U
What is the format string for year month?
Y or y
You want to use BIDS to deploy a report to a different server than the one you chose in the Report Wizard. How can you change the server URL?
You can right-click the project in Solution Explorer and then change the Target-ServerURL property
Which rendering formats are affected by the PageSize properties?
Only PDF, Word and Image because they are the only ones that have physical page breaks
What is a dataset?
A collection of data consisting of rows and columns that SSRS uses as the source of report items
What are the three main elements of a dataset?
Data source
Command type
Query string
What could Command type be composed of?
Text, a table direct (which is equivalent to a SELECT * FROM table query), or a stored procedure. For many data sources you can use graphical query designers
What language is the query string in?
The query language of the data proider. TSQL for relatinal engine,MDX multidimensional expressions or DMX Data mining extensions for SSAS. Stored procedures can be called by name
Where is a shared data source and a private data source stored?
Shared is stored independently from the report, private data source is embedded in the report
What are the two query designers that work with SSAS data sources?
Multidemsional Expressions (MDX) Query designer
Data Mining Extensions (DMX) Query Designer
How do you switch between the two query designers that work with SSAS data sources?
Click the command type button
What do you need to do after designing nested tables in the DMX query designer?
Add the DMX keyword FLATTENED right after the SELECT
Can you use a stored procedure to provide data to an SSRS report?
Yes, you can by configure the dataset to use a stored procedure command type. But it should only return a single result set--if it returns multiple only the first one is used for the report dataset
How do you slect a perspective in an MDX query?
Use the cube Selector button in the MDX Query Designer to select a perspective
Can you use data mining models in SSRS?
Yes, using the DMX designer to create a query. But don't forget to flatten the result.
The design of interactive reports is most closely related to which rendering format?
HTML
How do you hide a report?
Select group properties, visibility pane, change "When the Report is initially run" to "Show or hide based on an expression"
Select "display can be toggled by this report" check box
Select the report item that will toggle the visibility (typically the label)
What are the three types of actions that SSRS supports?
Go to Report
Go to Bookmark
Go to URL
What do bookmarks provide in a report?
Bookmarks provide a customized table of contents or customized internal navigaiton links in the report
You want a report to display Sales by Category, SubCategory, and Product. Users should see summarized information but be able to see details when necessary. What do you do?
Hide the SubCategory group and set the visibility based on the Category item. Hid the Product category group and se the visibility to toggle based on the subCategory item
Can you create the same interactive experience in Excel that you would have on the Web within SSRS?
No, but you can use Excel to create such an experience
What are the five report items?
list
table
matrix
chart
gauge
What is the differnece between a table and a matrix?
A matrix is similar to a table except that a table data regions has a predefined set of columns and the matrix can dynamically expand based on the number of columns it contains in order to pivot information
Can you nest data regions?
Yes
What's the difference between data filters and paramaters?
Paramaters reduce the data that is pulled from the datasource while filters always occur after the data has been retrieved from the data source
What is the main advantage of filters?
Information can be share between multiple users if you configure the report to use execution snapshots
What are execution snapshots?
In report execution snapshots, the first execution of the report pulls data from the server and successive executions use the snapshot information stored in the report server
If you are not planning on using execution snapshots should you use filters or paramaters to filter information?
Paramaters, for performance reasons.
If you want to sort the same data in different ways, what should you use?
Different data regions
What might you use haders and footers for?
providing the user with data aggregates such as SUM, AVG, COUNT and others
What is a running aggregate?
A special type of aggregate that is calculated in each of the rows instead of only at the group levels and is useful for studying accumluated performance of a field
What are the two running aggregate functions that SSRS supports?
RowNumber and RunningValue
What do you use to include more than one stream of data in your report?
Datasets