Here is some information
about defining prompts in report linking:
Restrictions on defining prompts
You can create a report
based on a multidimensional data source as the source report in the
report-linking operation. You can pass the parameters from the multidimensional
report to a relational report.
When you create a link
to pass values to parameters in a destination report or a stored process,
the following constraints must be satisfied:
-
Prompts in destination reports have types. The common
prompt types are character, numeric, date, time, and timestamp. There
are other types, but they are not used in report linking.
-
Data items in the source report have types. Each data
item has two types associated with it. If a data item has a format
applied to it, then its formatted values are the character type. Unformatted
values for data items can be character, numeric, date, time, or timestamp
types.
-
Data types for the prompt and the source data item
must be compatible. When you choose a parameter in a destination report
to pass values to, the values must be a type that is compatible with
a prompt. When you assign a data item to a prompt in the destination,
the type associated with the data item's value must also be compatible
with the prompt. Data items with incompatible types will not be presented
in the drop-down menu for a given prompt.
Prompts are compatible
in the following ways:
-
Character prompts can accept the
formatted values of all data items.
-
Character prompts can accept the
unformatted values of all character data items.
-
Numeric prompts can accept the
unformatted values of numeric data items (category or measure).
-
Date prompts can accept the unformatted
values of date data items.
-
Time prompts can accept the unformatted
values of time data items.
-
Timestamp prompts can accept the
unformatted values of timestamp data items.
Verifying prompt associations
SAS Web Report Studio
does not check that your associations make sense, so make sure that
you assign an appropriate data item value to each prompt. For example,
you might link a
Product Name group
break in the primary report to a prompt for
Product
Name in the target report, but you would not link
a
Gender group break to a prompt for
Order
Year.
Conditions that cause the prompts window to appear
If you assign a value
to each prompt in the target report, then the prompts window is bypassed
when the user clicks the link in the primary report. If you do not
assign a value to each prompt in the target report, then the prompts
window appears. The user can then confirm the current prompt values
or enter new ones.
If you remove or hide
a category or hierarchy that is used in a report-linking prompt, then
the prompt association is removed. The user must answer the prompts
to display the target report.
Interaction with manually refreshed reports
If you link to a report
that is manually refreshed, the prompt values sent from the primary
report are not used for the target report. Instead, SAS Web Report
Studio displays the results of the last query run for the target report.