Snapshots in treeview reports

KReporter
1

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

2

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

3

Hi Val,

Report was created with KReporter 4.2. CRM is SugarCRM CE 6.5 and PHP version is 5.6.

Thanks,
Jonny

4

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

5

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

6

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

7

Jonny,
would you send me an e-mail address? The one I have seems to be obsolete.
valerie.maret@twentyreasons.com

Val