I've created a report which holds 5 individual tables. First I tried to use the drill filter function to filter all 5 tables at once, but that is impossible. With the hel p of some VBA samples I created a userform which retrieves all values of the object which I used for the drill filter and then by changing the global filter to the appropiate value all 5 tables are changed at once.
The problem is now that I cannot display the filtered value in my report. I already used the formula Globalfilter(""), but that won't work.
Does anyone know a solution for this.
regards,
Ronald Jansen
The problem is now that I cannot display the filtered value in my report. I already used the formula Globalfilter(""), but that won't work.
Does anyone know a solution for this.
regards,
Ronald Jansen