Is it possible to use both static and dynamic parameters in single report?
Is it possible to use both static and dynamic parameters in a single report?
I am using crystal report 2013.
I have 5 levels of parameters in a report for filtering the records. level 1 is a static parameter to get start and end date(range parameter) as input and others are dynamic cascading parameters.
Based on selection of date range, rest 4 levels should be filtered viz. :
level 2 is Requisitioners
level 3 is Requisitions
level 4 is Budget Category
level 5 is Item Category
Further on selection of level 2, rest all parameter levels should get filter and so on. The issue here is LOV(list of values) in each parameter is filtered on selection of preceding parameter only.
If it is possible, please let me know how can it be done or else kindly suggest a workaround solution for same.
Abhilash Kumar replied
No! You cannot have a Static prompt that is a filtering source for the subsequent dynamic prompts.
Have a look at Patrick's workaround (and other workarounds) for filtering the prompts based on a Date Range here: