report filter question from newbie in programming

ecclectic
ecclectic Member Posts: 176
edited 2006-01-09 in NAV/Navision Classic Client
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

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ecclectic
    ecclectic Member Posts: 176
    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
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • Shenpen
    Shenpen Member Posts: 386
    However, changing the order, so SH first then SL might be easier.
    Do It Yourself is they key. Standard code might work - your code surely works.

Categories