Page Number Query

[Captain]

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.

[kc9400]

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?

[cognos810]

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