Tiered report filters

stoocake
stoocake Member Posts: 32
edited 2006-03-29 in NAV/Navision Classic Client
I have built a report with these tables in it:

DataItem Name
Sales Invoice Header <Sales Invoice Header>
Sales Invoice Line <Sales Invoice Line>
Stockkeeping Unit <Stockkeeping Unit>

I want to filter on the Vendor No. in the Stockkeeping Unit table, but if I put the filter in there it won't acknowledge it, and still shows every vendor in my report.

Sorry, I'm a bit of a n00b at this.

Thanks

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Can you give a little more info.
    -Where did you put the filter? In the properties of the dataitem? Somewhere in the code and in this case where?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • stoocake
    stoocake Member Posts: 32
    When I run the report I put the filter in then. It is not coded in anywhere.

    ..The formatting of my last post didn't come out right; the indentation of the report looks like this:

    Sales Invoice Header <Sales Invoice Header>
    ..Sales Invoice Line <Sales Invoice Line>
    ....Stockkeeping Unit <Stockkeeping Unit>

    What options do I have to get the filter to work?
  • stoocake
    stoocake Member Posts: 32
    When I run the report I put the filter in then. It is not coded in anywhere.

    ..The formatting of my last post didn't come out right; the indentation of the report looks like this:

    Sales Invoice Header <Sales Invoice Header>
    ..Sales Invoice Line <Sales Invoice Line>
    ....Stockkeeping Unit <Stockkeeping Unit>

    What options do I have to get the filter to work?
  • Shenpen
    Shenpen Member Posts: 386
    Does it show 1) filtered SKU's and all invoices or 2) all invoices and all SKU's?

    Becuase it should do 1) . Filters on low level of the report model don't affect higher levels.
    Do It Yourself is they key. Standard code might work - your code surely works.

Categories