Reporting Svcs - "Expand All" without hitting the DB a second time?
-
One of my team members is creating a web application using SQL Server 2005 (Reporting Services). There's a feature that one of our internal customers requested to expand all fields within a report upon demand. When a report is initially requested, the default view (per customer requirement) has all detail collapsed.
We've read different articles and message board posts here that give ways of expanding all (for instance, according to my team member, we are using matrix/grouping, and toggled item is already being used by grouping), however, all of these solutions require a re-query of the database. I guess our thinking is that this seems to be redundant, considering that the system is pulling all of the information anyway (although collapsed initially).
Our question is - it possible to create an "expand all" button for each report that operates without sending the query back to the database, and if so, how?
Any assistance you can provide would be greatly appreciated!
Thanks.Regards,
- Jodi.
---Call me Jodi for short. I am.---
-
Hi
Hope i have understood your issue correctly....
In order to not re-query the db u will have to fetch all the details from the db first time itself. How good this approach is depends on the volume of data thatneeds to be fetched. If the data volums is small then it might be ok, otherwise you could face some performance issues.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply