use of inlist and matches pattern in same query

[system]

Hi Mike,

Take a look at this post for starters

120×120 10.4 KB

I’ve created a report that contains many report prompts, one of which being the following: PLANT_MATERIALS.MRP_CONTROLLER IN @variable(‘2. Select ‘‘MRP Controller/s’’ for analysis’) However rather than just being able to pick from the LOV or enter the values required, how can I modify the prompt so that the user can pick from the list of values or enter a wildcard; eg, % so that the report returns all values. Whilst I here I’ll ask another question: What determines the maximum number of val…

---

irish_stan (BOB member since 2003-05-13)