prompts with multiple options

[antara1234]

I have a requirement to have a report with 3 prompts but only one of them should be answered.
Do you know how I can make sure that at least one is mandatory ?
If I mark both of them as "required" then I need to answer both of them.
If I mark both of them as "optional" , it works , but user can skip both of them as well

 

[JDAEMS]

That is actually a very good question! It is a clear and simple question, but not something easy to do in Cognos.

This is how I would handle it: Create a finish button of your own in HTML using a HTML object of course. Write the onclick procedure yourself in a JavaScript function.

This function checks the value of the first prompt. If this is empty, then you check the value of the second prompt. If one of them isn't empty, then you force the onclick of the Cognos finish button. If they are both empty, then you can give a warning message for example.

Now, i haven't done this myself yet. But I have gone pretty far with using javaScript in Cognos reports, and I know you can go very far with these things. So this would be the way that I would try it.

I hope this has helped you on the way.

Kind regards
Jelle Daems

 

[jimicron2]

Can this sort of thing be done in Planning-Analyst?

 

[JDAEMS]

I was talking about the tool Cognos Report Studio. And there you have the possiblity to do these kind of things. I don't think this can be done in Planning.