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
Alex MerwinAlex Merwin 

Problem passing Custom Field Merge Values to a Report Custom Link on List Button on Opportunity Product Object

Hello - 

I am trying to create an efficient means for users to Export all Products that are associated with a given Opportunity. 

I've attempted this by: 
  • Creating a Template Report for the export, and putting it in a Public Folder
  • Creating a Custom Field on the Product Object called 'Product ID', because for some reason the system generated SF ID for Products isn't included in the Reporting module as a selectable field / filter. 
  • Created a cross-object formula field on the Opportunity Product object, referencing the Custom 'Product ID' field from the associated Product
  • Added a List Button to the Opportunity Product object, with the following settings. The ID in the URL references the Template Report. User-added image
When I select products and click 'Export', I get this error: 
Unable to Access Page
The value of the "rt" parameter contains a character that is not allowed or the value exceeds the maximum allowed length. Remove the character from the parameter value or reduce the value length and resubmit. If the error still persists, report it to our Customer Support team. Provide the URL of the page you were requesting as well as any other related information. 


Looking at the URL it doesn't seem as if the query string is populating correctly:

https://DOMAIN.my.salesforce.com/00O38000004J9f3?pv0=&lid=00b38000001Co33&eid=0063800000ZamzO&ic=1&retURL=%2F0063800000ZamzO&wrapMassAction=1&scontrolCaching=1&linkToken=VmpFPSxNakF4TlMweE1pMHdNVlF3T1RveE56b3pNaTQwT0RsYSwzMm83WnM3Z09XT204ZGs5UWFGTk1YLFlXWmtNR0po&autoMapValues=1​

I was hoping that by checking multiple boxes, SalesForce would populate multiple instances of the Custom Field 'Product ID' as a filter for the custom report. 

Can anyone help? 


User-added image


User-added image



 
Sagar PareekSagar Pareek
This can only be achieved from detail page. 
http://resources.docs.salesforce.com/198/0/en-us/sfdc/pdf/salesforce_web_integration_links.pdf
https://www.interactiveties.com/blog/2011/dynamic-report-part1.php#.Vlm5_N8rKu4