Hi
I have been battling with a strange task in Cognos. I created a prompt page (check image attached) with two filters, I made both filters optional. Both filters has multi select and multi-line features. Strangely if I run the report, the Contract Number detail displays well, but the Material Number Details doesn't display completely. It doesn't show the multi-select/line feature like Contract detail (See Image below)
But if I disable the prompt detail for Material Number, it display correctly.
Pls can someone help me out.
Find the images attached
Filter Definition- Detail Filers
[Presentation Layer].[Sales Order].[Prod Cd] = ?Prod No?
[Presentation Layer].[Sales Order].[SO Doc Hdr Nbr] = ?Contract Number?
well, to be fair, your contract number should show up like that as well, and I'm a bit confused why it doesn't ;). Cognos not only checks the prompt setup for rendering, but also how the parameters are used in the report. As you posted your filter conditions, you are using "=" as the operator, however "=" does not support multi-selected values.
Replace your "=" with "in", and you should be fine.
@hespora. Thanks so much for you help. It worked well... What a relief!
Wonderful, glad I could help!