Request form problem

upasanisandip

Hi all,
I am creating 1 report using tables Sales Header & Sales Line tables.
In Request Form I want to show users all Sales Order nos in drop down list.
I have taken ReqFilterFields to "No." field but Sales Order No. is not displying in this report.
Whether I have to define any more property for this.

Anyone have idea ?


Thanks.

kriki

If you put "No." in the property ReqFilterFields" of the dataitem, it should appear there in the list of fields on that dataitem. But NOT in the requestform. If you want something on the requestform, you need to put it there yourself like in a normal form.

upasanisandip

Hi kriki,
I mean to say in Request Form I can see the field "No."
But in front of that field in Filter data is not appearing.
Like if we run the Sales Invoice report we can select Invoice nos.

kriki

The (classic) problem is that in the Sales Header, you have Quote,Orders,Invoices,...
Try to put a filter in the SETTABLEVIEW to show only orders.
If that doesn't work, DON'T put a key on the table. In this case you get an arrow at the bottom of the report. If you click it, it shows the records in the filter the user put. The beautiful thing is that if you put filters on the form and then return to the report, Navision copies the filters on the report.