# Snapshots in treeview reports **URL:** \ **Category:** KReporter\ **Created:** [February 28, 2018, 10:29pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261 "2018-02-28T22:29:08Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)\ **Post date:** [February 28, 2018, 10:29pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/1 "2018-02-28T22:29:08Z")
Hi, Does the snapshot feature work with treeview reports. We have a treeview report with a couple of snapshots. There looks to be data in the kreportsnapshots table for this report. When we try to load the snapshot nothing happens. Is there anything additional we need to do to see this data? Thanks, Jonny ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [March 5, 2018, 2:49pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/2 "2018-03-05T14:49:58Z")
Jonny, yes, it shall. Was your treeview report created with KReporter 4.2 or is it an older Report? Please remind me your php version and CRM name + Version Val ---
**Author:** ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)\ **Post date:** [March 9, 2018, 4:28pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/3 "2018-03-09T16:28:43Z")
Hi Val, Report was created with KReporter 4.2. CRM is SugarCRM CE 6.5 and PHP version is 5.6. Thanks, Jonny ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [March 15, 2018, 3:33pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/4 "2018-03-15T15:33:01Z")
Jonny, I had a look a the logic and I have to review my statement. TreeView is not compatible with snapshot. Each node is loaded dynamically, that’s why. Val ---
**Author:** ![jonnygribben](https://avatars.discourse-cdn.com/v4/letter/j/f9ae1b/32.png) [@jonnygribben](https://community.spicecrm.io/u/jonnygribben)\ **Post date:** [March 15, 2018, 3:48pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/5 "2018-03-15T15:48:12Z")
Hi Val, Thanks for getting back to me. What is the data that is stored in the kreportsnapshots for this report? There looks to be quite a lot, is there any way to extract the data? Even if we could see the data for the top node it would be better than nothing. Thanks. Jonny ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [March 15, 2018, 4:48pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/6 "2018-03-15T16:48:07Z")
Thx for asking this, Jonny. I realized that the tree is built on the results and not on a query for each node. Results array is looped each time you open a node, that’s all. The snapshotdata consists in these rows. I took a closer look to the code: the snapshotid is not passed to the function retrieving the results so that the full query is sent again. I will send you 2 files to replace. Val ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [March 15, 2018, 5:01pm UTC](https://community.spicecrm.io/t/snapshots-in-treeview-reports/261/7 "2018-03-15T17:01:18Z")
Jonny, would you send me an e-mail address? The one I have seems to be obsolete. [valerie.maret@twentyreasons.com](mailto:valerie.maret@twentyreasons.com) Val