Getting ready

Carry out the following steps to create an opportunity report that is filtered by the standard Amount field:

  1. Click on the Reports tab.
  2. Click on New Report, as shown in the following screenshot:
  1. In the resulting Create New Report page, select the Opportunities report type.
  2. Click on Create, as shown in the following screenshot:
  1. Click on Add in the Filters section.
  2. Select a filter for the Amount field, choose the option greater or equal, and enter the value 10000.
  3. Click on OK.
  4. Click on Save, as shown in the following screenshot:
  1. In the resulting Save Report dialog, enter High Amount Opportunities in the Report Name textbox.
  2. Enter Report for high amount opportunities in the Report Description textbox.
  3. Select one of your existing folders or leave as default in the Report Folder to save the report.
  4. Click on Save, as shown in the following screenshot:
  1. In the resulting saved Report page, click Run Report, as shown in the following screenshot:
  1. Note the URL that is displayed in the browser address bar as this is the location for the report, as shown in the following screenshot:
  1. In the resulting saved REPORT page, click the Filter icon to take a look at the way the filter for Amount is set as greater or equal "100,000" and get an idea of how we will update the Amount parameter as part of this recipe.
The URL that is generated is https://widgetsxyzlex-dev-ed.lightning.force.com/one/one.app#/sObject/00O0Y000006eJLvUAM/view.
You will now need to make a note of only the following part of the report URL

/one/one.app#/sObject/00O0Y000006eJLvUAM/view that is shown in your Salesforce organization.

We need to further modify the URL to pass the Amount as a variable that allows us to run the report from a link with any value of opportunity Amount. This modified URL becomes the following:
/one/one.app#/sObject/00O0Y000006eJLvUAM/view?fv0=250000.
This appended URL will be used in the following How to do it... section.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset