Forum Discussion
Table is not filtering as expected
Hi,
I have one report, the data is from the CDS, the structure of the data is, I have Contract table, under that table there is Agreements table, the contract is the parent, now In the report, there is one page for contracts details, as a table, and I made another page where it will show the Agreements, I made the Drill-through, it's working in a way, but not fully, this is the table of contracts
and once I will do drill through, it should only show me the agreements of that contract, now for some reason, the result is, the agreements of that contract, an empty line, then all agreements, I want only the agreements of that contract to show and not the rest
Thanks amitchandak for pointing me to the correct place, the problem was, in one my measure, i had an If, and that was the cause
3 Replies
- amitchandak
Super User
aboodhamwi , do you have any measure with +0 .
Or you checked this option by mistake - Show item with No data
- aboodhamwiFrequent Visitor
- aboodhamwiFrequent Visitor
Thanks amitchandak for pointing me to the correct place, the problem was, in one my measure, i had an If, and that was the cause