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.