You need to sign in to do that
Don't have an account?
Liz Martinez
Dynamic query with filters in report
I have a report with filters (filters fixed) that works fine.
But I need to add another filters which are dynamics, I mean, there are 5 filters that the user can o can't choose and with these criteria selected the report needs to get the information.
I read in the forum that exists the way to pass dynamically the values using URL with querystring variables:
https://na12.salesforce.com/00OU00000013vG6?pv0=1/1/2011&pv1=2/1/2011
But in order to this works the filters "pv0" and "pv1" needs to be defined in the report, in my case I can't define these because are not fixed.
Is there a way to made this?
Thank you very much
But I need to add another filters which are dynamics, I mean, there are 5 filters that the user can o can't choose and with these criteria selected the report needs to get the information.
I read in the forum that exists the way to pass dynamically the values using URL with querystring variables:
https://na12.salesforce.com/00OU00000013vG6?pv0=1/1/2011&pv1=2/1/2011
But in order to this works the filters "pv0" and "pv1" needs to be defined in the report, in my case I can't define these because are not fixed.
Is there a way to made this?
Thank you very much
All Answers
Greetings