I have created a summary query and I have a condition applied on it. The condition is 'KF' < 4. I get the results of the query. I have changed the Calculate Result As to 'Total' to show the total of only the records that are displayed.
However I have a jump query on it and when I goto the Jump query, it shows all the records though they dont satisfy the conditions. I want the drill down report to show the results of only those values displayed in the Summary report.
Is there a setting where I can change to get the required result.
Any helpful reply would be awarded.