excell file in the reports

[sprokkie]

Hi.

Does some one know where the excell report is stored before downloading it ?
When i make a report i have to press the arrow to open it, where is it stored before opening.

that excell file is what i need for my other aplication

[phildunlap]

It should be in Mango/web/modules/excelReports/web/report-data/

[sprokkie]

I dont have that directory, i am using mango 2.5.2
I upgrades once to a newer version and the whole mango installation became really slow.
this version is working for me.

I scheduled with a cronjob each minute a report.
Then i did a file search wit wincommander on recently changed files
The report was not in the recenrly changed files.

In the help file i found this:

An instance can be considered a snapshot of the data at the time it was run. Instance attributes cannot be changed. Also, the data that the instance reports exists as long as the instance exists. (I.e. it survives the purging of the source data.) For this reason, it is important to purge report instances—especially large instances—when they are no longer needed since they can consume large amounts of storage.

Now i want to know where it is stored, maybe i can acces that location to get the files i want.

[phildunlap]

Ah! You are using the Reports module (generates emails and HTML), not the Excel Reports (generates Microsoft Excel documents). The data for those Reports is stored in three database tables,

ReportInstanes - Each run report will correspond to a row here.
ReportInstancePoints - Each run report will insert rows for all the points in its context.
ReportInstancePointData - Each point in a run report will store its data for that report here.

So the finished product isn't stored as a composed item unless you email it.

One thing the Reports module enables that is cool is copying & customizing the reportChart.ftl file to something simpler, then you can get data formatted however you like over HTTP from a URL endpoint for each finished report, such as mangoUrl/reportChart.shtm?instanceId=1

The modules' files should be in Mango/web/modules/reports