Hi Folks,
I have a consolidated report....5 queries, 5 pages, 5 packages.
The schemas of the packages are identical.
I want to create a single value prompt for a field that exists in each package.
To illustrate:
[PACKAGE1].[TABLE_A].[BRANCH.NR]
[PACKAGE2].[TABLE_A].[BRANCH.NR]
[PACKAGE3].[TABLE_A].[BRANCH.NR]
[PACKAGE4].[TABLE_A].[BRANCH.NR]
[PACKAGE5].[TABLE_A].[BRANCH.NR]
A lot of information on passing parameters and drill through definitions on multiple queries, but none that I could find on multiple packages.
There is a date/time range prompt which works fine, just creating ?parameter1? on the common date/time field for each query.
This does not work with the above prompt.
When creating ?parameter2? again in each case, on building the prompt you need to specify which single package you are referencing.
Is it seeing different content on each package?
Is there a way to make this prompt global?
Cheers,
Locus