Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 08, 2014 at 06:35 AM

    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:

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 01:26 PM

    one of the 3rd-party Crystal Reports viewers listed at http://kenhamady.com/bookmarks.html allows you to create an additional type of cascading dynamic parameters whereby other rpt files can act as parameters that can cascade further to their own static/dynamic parameters.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 02:44 PM

    you can also create a custom parameter control set using webelements. parameters can be static or dynamic and you can also hide show different controls. you would need to be using businessobjects enterprise or crystal reports server as these are used in the dhtml viewer.

    Add comment
    10|10000 characters needed characters exceeded