report filter question from newbie in programming

ecclectic

hi,

i have made a report using wizard based on the sales line table. report works fine. i've added the sales header table and made one field a req filter. however, the report does not take the filter in consideration when running. i.e. whether i fill in a value or not, it gives me the same result.

thanks for your help

ara3n

how does your report look like?

Salesheader
-> Sales line


Where are you putting the filter? on sales line? or header?


if it's sales line, you need to set the property on sales hader. Showonlyifdetail to true.

ecclectic

ara3n wrote:

how does your report look like?

Salesheader
-> Sales line


Where are you putting the filter? on sales line? or header?


if it's sales line, you need to set the property on sales hader. Showonlyifdetail to true.

report looks like the following
Sales line
-> Sales header

i'm setting filter on sales header

Marije_Brummel

The Reminder has a similair thing. This has a ledger entry dataitem just for filtering.

You need to manualy copy the desired filterfields to the salesline.

Or build your report like Ahmed suggests.

Shenpen

However, changing the order, so SH first then SL might be easier.