Outcome : Report should be of '5 Tabs' in Excel each representing the outcome of the 5 reports pages from a report.
Input : I created 5 Report pages, which automatically created 5 separate queries.
Each Report was made from separate Query Subject (5 Query Subjects are there) of the same package.
Each report has decodes coming from tables, but those tables are present in each and everyone of those 5 Query Subject, which can be useful for individual report pages.
Package is like this :
+ Query Subject 1 ---> Report Page 1
+ table 01
+ table 02
+ table 03
+ Query Subject 2 ---> Report Page 2
+ table 01
+ table 02
+ table 03
+ Query Subject 3 ---> Report Page 3
+ table 01
+ table 02
+ table 03
+ Query Subject 4 ---> Report Page 4
+ table 01
+ table 02
+ table 03
+ Query Subject 5 ---> Report Page 5
+ table 01
+ table 02
+ table 03
Each Query Subject is strictly used only for each report pages respectively.
About Prompt page : I have 1 value prompt, which should Query all the 5 queries and give the outcome from 5 reports, i am having a doubt ??? I have a Query Item which is present in Table 1 in every Query Subject.
If i want to use that Query Item to filter the entire 5 report pages, from which query subject should i assign the Query item in value prompt ?
If i Assign to Query item in table 01 of Query Subject 1, then add same filter to all the Queries, it's not filtering the remaining 4 Queries, it says cross joins are not allowed.
Any clue, what to do ???
Why don't you create a seperate query to pull Prompt values and link it to the value prompt created.
why would you want to use a data item from a report query into a filter?
start creating the prompt, use the package query item (and not any particular report query) to create a new query and on the last step checkmark the 5 query subjects as the one's you need the filter on