Hi, I need to set up the prompt page for report. One of optional prompt base on Age (day_between current date and open date)
[Age] = ?p_Age?
In the Prompt page, I can enter value Age = 30 and run, but I would like to enter range value, example: Age >30 or Age < 150 ..., but i don't know how to do it.
I saw this one time when I was practicing Cognos 10, in the page, have drop down option (contains value, greater than , less than....), but I don't remember how to do it.
Any helps?!
Thank you a lots!
Try TextBox Prompt p_Age( Multi-select, Range) and filter [Age] in_range ?p_Age?
Then you can specify multiple ranges : From To
Quote from: Andrei I on 09 Dec 2019 10:44:27 AM
Try TextBox Prompt p_Age( Multi-select, Range) and filter [Age] in_range ?p_Age?
Then you can specify multiple ranges : From To
That works! thank you!