Apex Code Development You need to sign in to do that
Don't have an account?
scriptagent Run Report and export into a Table
Good morning @ all,
yesterday I have created a new Report Type. The primary object has 2 related objects.
The report runs successful, but:
Is it possible to export/store these records in a custom object and not only to export as .xls/.csv file ?
Or is it necessary that I write my own SQL query with Apex/S-control...? After I have stored these data, I want to make some calculations in a s-control....
Thank you very much in advance!
Cheers, Peter
yesterday I have created a new Report Type. The primary object has 2 related objects.
The report runs successful, but:
Is it possible to export/store these records in a custom object and not only to export as .xls/.csv file ?
Or is it necessary that I write my own SQL query with Apex/S-control...? After I have stored these data, I want to make some calculations in a s-control....
Thank you very much in advance!
Cheers, Peter
Analytic snapshots were designed to do exactly what you lay out - at least to put the data into a custom object. Read about them in the online documentation or Chapter 6 of the Developer Guide.
Hope this helps.
Hi Rick,
yeah that's what I want! Thx a lot!
Have a nice weekend! Peter
Glad it helps. You should also be aware that right now you can only use standard reports to feed analytic snapshots, and there is a limit of 2K rows per snapshot run.