Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is it possible to use both static and dynamic parameters in single report?

Hi,

Is it possible to use both static and dynamic parameters in a single report?

I am using crystal report 2013.

For Example:

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.

Thanks,

Karan Sheth

Tags:
Former Member
replied

Hi Karan,

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:

Dynmaic Cascading Prompts - Populate parameter prompt with only values in date range

-Abhilash

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question