If you are unable to create a new account, please email support@bspsoftware.com

 

Prompt page - option for contains, greater than, less than... value

Started by peewan, 06 Dec 2019 03:42:07 PM

Previous topic - Next topic

peewan

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!


Andrei I

Try TextBox Prompt  p_Age( Multi-select, Range) and filter  [Age] in_range ?p_Age?

Then you can specify multiple ranges : From  To

peewan

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!