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, then the values must be a type that is compatible
with a prompt. When you assign a data item to a prompt in the destination,
then 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.