InterviewSolution
| 1. |
When Should We Use A Query Filter And When A Report Filter? |
|
Answer» The choice of query or REPORT filter has to take in consideration the performance of the report. Suppose we have report where are multiple tabs having different objects REQUIRING same or different filter conditions, it is advisable to USE a Query Filter. In case where there are multiple tabs having same objects, but with slightly differing filter conditions, it is advisable to fetch the WHOLE data in the query and then apply report filters to the various tabs to get the desired data instead of using separate queries for each tab. The choice of query or report filter has to take in consideration the performance of the report. Suppose we have report where are multiple tabs having different objects requiring same or different filter conditions, it is advisable to use a Query Filter. In case where there are multiple tabs having same objects, but with slightly differing filter conditions, it is advisable to fetch the whole data in the query and then apply report filters to the various tabs to get the desired data instead of using separate queries for each tab. |
|