Tiered report filters

stoocake

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

kriki

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?

stoocake

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

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

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.