function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Anna Lu 6Anna Lu 6 

embed report in visualforce page, and manipulate with my own calculation

So what I am looking for is to embed a report into a visualforce page : it should be able to updated as a report as well;
And below the report, I'd like to have an area, where I can pull some of the information out from the report, and calculate with my own function.
(I cannot do so in report because I have more than 5 functions to calculate)
Any smart and sharp way to do so?
(I've been trying to create a page without report embeded and it's somehow painful)

Thank you!
Alain CabonAlain Cabon
Hello,

What is missing for your need in the Apex and Visualforce page documentation (changing the standard filters) ?

The most complicated part is the readiing of the data of a report wth Apex ( Decode the Fact Map https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_fact_map.htm )

Salesforce Reports and Dashboards API via Apex
The Salesforce Reports and Dashboards API via Apex gives you programmatic access to your report data as defined in the report builder.

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_intro.htm

Filter Reports   To get specific results on the fly, you can filter reports through the API.
Changes to filters that are made through the API don’t affect the source report definition. Using the API, you can filter with up to 20 custom field filters and add filter logic (such as AND and OR). But standard filters (such as range), filtering by row limit, and cross filters are unavailable.

https://developer.salesforce.com/docs/atlas.en-us.pages.meta/pages/pages_charting_example.htm
Anna Lu 6Anna Lu 6
Thank you for your input. I'm pretty new to Salesforce. Could you enlight me how I can I present this class in front-end using visualforce page? Or do I directly modify the code in the back-end of reports?