You need to sign in to do that
Don't have an account?
Anna 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!
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!
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