Hello.
Using
http://buttonclickadmin.com/monday-am-admin-take-dynamically-filtered-reports-up-a-notch/ as a guide, I created a visualforce page and entered the HTML that creates the link to the filtered report. However, the example in the video is for the Account, and I need to have my report filtered based on a custom object ID. When I click on the link the report opens, but there is no filter. I'm using the HTML below, and I've been able to isolate that the issue is the pc0=INSERTION_ORDER_ID. For some reason I cannot get the correct naming convention for my custom object's ID, so no filter is created. Is there a way for me to look up exactly what it should be? The object name is Insertion_Order.
<p>
<a href="/00OQ0000000YNyo?pc0= INSERTION_ORDER_ID &pn0=eq&pv0={!LEFT(Insertion_Order__c.ID,15)}" target="_blank">EUR QA Report"</a>"
</p>
<p>
I know I could filter the report itself to Insertion Order ID = blank and then just include pv0={!LEFT(Insertion_Order__c.ID,15)}" in my HTML, but I would prefer to figure out how to add the whole filter.
Thanks!
-
OK, here it goes...
1. Use Google Chorme to do this. I know Firefox has something similar. I don;t know if IE does.
2. Run the report.
3. Scroll down and notice the drill down picklist
4. Right click anywhere on the report page (don't click on any page element like a button or picklist) (See image below)
5. From the pup-up menu, select the Inspect Element option (last one)
6. A frame should appear on the lower part of the browser screen. (See image below)
7. On the top right of the new fram, there will be search box. Enter the name of the field that you would like to pass in.(See image below)
8. You will be able to find it under a section that says "Summarize Information by:" (See image below)
9. Copy the ide to the left of your field.
You're code will look something like this: "/00OQ0000000YNyj?pc0=IDthatYouFoundinHTMLGoesHere&pn0=eq&pv0={!LEFT(InsertionOrder.ID,15)}"
