You need to sign in to do that
Don't have an account?
zach
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:
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
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
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
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
http://blogs.salesforce.com/analytics/2007/01/passing_extra_c.html