function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HerosHeros 

Image formula to a report

I am trying to do an image formula that opens a report.  This will be on the Accounts tab,  when you click on the image it will open up a report page to a report that will be generated just for that Account.  The problem is that the merge field for Account Name is Name,  it is placing into the report crieteria the word Name not the merge value of the Account Name.

Formula Code:
HYPERLINK("https://na1.salesforce.com/00O30000001FJ9W—pv0=Name&pv1=0",IMAGE("https://na3.salesforce.com/servlet/servlet.ImageServer–oid=00D300000006F9s&id=01550000000K1DO", "Click Here to go"))

 results:



HerosHeros
After heavy troubleshooting I found a resolution to my problem.  :smileyvery-happy:

Below is what I used:

Code:
HYPERLINK("https://na1.salesforce.com/00O30000001FJ9W—pv0="&Name&"&pv1=1",IMAGE("https://na3.salesforce.com/servlet/servlet.ImageServer–oid=00D300000006F9s&id=01550000000K1DO", "Click Here to go"))

 

As you can see I changed ....pv0=Name.... to ....pv0="&Name&"...  this resolved the problem for anyone who wants
 to know.