I have seen many customers in need to have Dynamic Filter. In Absence of Dynamic filter, many times we end up with creating multiple reports with same format and different condition.
Many time, we need something like get all cases related to Parent Account of Opportunity. We can simply create a report for Case and add Condition for Account Name. Using Some Custom Link, we can always Change Account Name and same report can be used many times.
While navigating to community i found very interesting and useful information regarding dynamic Filter in Reports.I thought that Dynamic Filters inside Salesforce is not possible but It is Possible.
Update – For Lightning Experience URL will look like
https://mydomain.lightning.force.com/lightning/r/Report/00O5C00Um3lUAC/view?fv0={!mergeField}
Salesforce does not have any official documentation on this, but here how it works.
Lets have look in below image:
Above report have three Filters. First Filter will be considered as “pv0”, second filter will be considered as “pv1” and so on.
In URL, we can provide parameter for Pv0, Pv1 like in above image.
Now, we can create a formula field to create a dynamic link which will open report. Something like
https://ap1.salesforce.com/{!ReportId}?pv0={!MergeField0}&pv1={!MergeField1}
Leave a Reply