Filter in Cognos Report Studio 10

[mycognosangel]

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?

[hespora]

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.

[mycognosangel]

 @hespora. Thanks so much for you help. It worked well... What a relief!

[hespora]

Wonderful, glad I could help!