Value prompt properties poreperty

[afzaki7]

Hi all
there is a property at the value prompt called (properties)
what is that property used for

Thanks

[MFGF]

Hi all
there is a property at the value prompt called (properties)
what is that property used for

Thanks

The "Properties" property (in various places eg list, crosstab rows, value prompt etc) is used to force Cognos 10 to evaluate and use items of data it would otherwise ignore. It tries to be rather clever, you see, and to do as little work as possible to make your reports run as optimally as possible. If you have a query containing 100 data items, for example, and your prompt uses only one of them, Cognos 10 will retrieve only the one item it needs rather than retrieving all 100. That sounds like a good thing, and it is unless there's another item you're not displaying that you also need Cognos 10 to retrieve and use for some reason. As an example, maybe you want to conditionally highlight based on a different item you're not displaying. If you try to do this and Cognos ignores the item, your report won't work. You can force the item to be used by putting a check next to it in the Properties property.

Cheers!

MF.

[afzaki7]

Thank you MFGF  :)