Looking for a material list per order #. Some order # do not have material, some do. I set a static parameter that ask for the order #. I also did the select expert thing and my prompt is working just fine. On my report, i put the order # on the pager header section and my material(s) should all be listed as records in the detail section.

 

All this is working as designed until i put an order # that has no material to be listed. I want  the report to still show the order # on the page header section, and in the details section, i would like to have a text box that say something like no record found....

 

Right now, the order # does not show and the report is blank....

 

Any help will be appreciated....