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;
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
|