You need to sign in to do that
Don't have an account?
Keith Snider2
custom report links
Hi,
I know for custom report links you can insert a parameter for a Contact Id from the Contact page, but can you do something similar if the report does not relate to the Contact? For instance, I have a report of Opportunities, which has a lookup to Contact. I want to use this report, but insert a parameter for the Contact Id. I have a custom field on Opportunity to get the Contact Id, but the paramter ain't working, which makes sense because there's only the custom field I have on opportunity and NOT the actual Contact.Id. Anybody know of any solutions?
/00Oi0000005wvrc?pv0={!Contact.Id}
I know for custom report links you can insert a parameter for a Contact Id from the Contact page, but can you do something similar if the report does not relate to the Contact? For instance, I have a report of Opportunities, which has a lookup to Contact. I want to use this report, but insert a parameter for the Contact Id. I have a custom field on Opportunity to get the Contact Id, but the paramter ain't working, which makes sense because there's only the custom field I have on opportunity and NOT the actual Contact.Id. Anybody know of any solutions?
/00Oi0000005wvrc?pv0={!Contact.Id}
Is contactId custom field on opportunity a look up field? If yes then follow approach a -
-Edit your custom report type by going to setup -->report types
-go to Fields Available for Reports section and edit layout
-you can choose which object you want the fields from
-You can choose contact and select Id.
Hope this helps! Good luck.
Cheers,
Aparna
All Answers
Is contactId custom field on opportunity a look up field? If yes then follow approach a -
-Edit your custom report type by going to setup -->report types
-go to Fields Available for Reports section and edit layout
-you can choose which object you want the fields from
-You can choose contact and select Id.
Hope this helps! Good luck.
Cheers,
Aparna
I'm all set, thank you!