+ Start a Discussion
zachzach 

Help with URL Encoded reporting fields?

Hi, I'm trying to link to an individual records report in salesforce from a custom report I've built as an s-control.  I downloaded the Firefox developer toolbar to see what the post variables are when you build reports in salesforce so what I'm passing into the salesforce.com report is working, for the most part. I then set up a generic task report in salesforce to post to... While it works for the most part, I've run into a snag.  It seems like sd (start date) and ed (end date) are keying off of created date and not off of activity date.

Here's one URL string I've built in my custom report:

Code:
var col1Linka = "https://na1.salesforce.com/00O300000011vH4—&type=t&colDt_q=Custom&sd="+(fridayArray[a+1].getMonth()+1)+"/"+fridayArray[a+1].getDate()+"/"+fridayArray[a+1].getFullYear()+"&ed="+(fridayArray[a].getMonth()+1)+"/"+fridayArray[a].getDate()+"/"+fridayArray[a].getFullYear()+"&pc0=ASSIGNED&pn0=eq&pv0="+userArray[2]+" "+userArray[1]+"&pc1=TASK_TYPE&pn1=eq&pv1=Outbound Call&pc2=00N30000000fWIL&pn2=eq&pv2=Schedule First Appointment,Make Cold Call (Phone)";

 


Is there any way to specify in the URL from my custom report or in setting up the generic salesforce report that I'd like to use activity date for the sd and ed values instead of it (seemingly) keying off of created date?

Thanks,
-Zach
Ron HessRon Hess
you would have to setup the filter fields to specify those values

to see this , create the exact report you want with filters in the criteria wizard page, then save it, then edit it ,
now look at the paramaters for "pv0" , pn0, pc0, etc

you may be able to make that work  
Always ThinkinAlways Thinkin
Hi, I've been trying to reach a similar goal: add a formula field to Accounts using the HYPERLINK formula to generate the report's URL and sub in the specific Account Name so that a report is run for that account.

I've simplified my report down to just that one parameter in an attempt to get it to work but no matter what URL I build, I always get the error message "URL No Longer Exists"

Besides the base report URL (https://na3.salesforce.com/00O50000001L1PH)

and the pc/pn/pv values (&pc0=ACCOUNT.NAME&pn0=eq&pv0=ContinentalArmy)

what other elements are needed to generate the report?

I haven't tried this in an s-control because I figured it should work as a simple URL or formula field. Will it only operate as a post and not as a get?

Thanks,
Luke
Always ThinkinAlways Thinkin
Thomas Tobin placed a great article about building Custom Links to Custom Reports in the Reporting and Dashboards Blog along with links to two custom links in AppExchange.  And he styled it in homage to Justin Timberlake's SNL video, ==> in a [].

http://blogs.salesforce.com/analytics/2007/01/passing_extra_c.html