I have 1 single query that I'm repeating on multiple pages. I want to have a conditional filter so that each page would show different result sets. How do I have a "page number" data item or something similar to use in my conditional where clause filter?
Thank you in advanced.
PS: I'm expecting to have up to 20 pages, so no, I'm afraid having 20 different queries (with custom filter) would not be the ideal answer for me.
Hmmm maybe adding text items to each page which shows the page number?
or creating 20 different data items and then putting each one on each relevant page?
Hello Captain,
Is there some logic that you need to follow for page splits. Example: Data for Department X on Page 1, Department Y on Page 2 etc.
If you have such a condition available, then you can create a data item with the case logic for the same.
CASE Department
WHEN X THEN 'PAGE1'
WHEN Y THEN 'PAGE2'
END
Finally, use this data item to setup Page Breaks in the page explorer.
-Cognos810