While running some of the summary view reports we are getting a time out exception in PROD region..The reason is that we are using OR query in where clause for a particular column..Inside the OR statement we are putting more than 50 values..As, a solution we have used IN query and it takes much less time to run and also we are not getting time out error. But the problem is that grand total link is not displayed there..I have checked many forums but unable to find solution to overcome this..

The thing is that we need to use IN query(by modifying the get content activity) and at the same time we also need to display the grand total link.. Can you please help me out how to obtain this??