Skip to Content

Switching prompts based on different values

Environment:Crystal Reports 2013 SP2

: CrystalReportsServer 2011 on Windows 2008 R2.

IS there a way to do the following in Crystal Reports.

I am trying to combine essentially two reports into one report because the reports are identical except the filters are based on two different columns (Name) ,(Position)of the same table and the columns are not related.

So when an user picks which report they want , provided by the first parameter.

Lets say they pick the report that needs to filter on "Name" the Prompt's LOV that has the names from the Name column should be displayed. If they choose Position then another prompt with the values of positions as LOV values should be displayed. Its about displaying two different prompt panels based on the first parameter value they pick.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 14, 2017 at 10:45 PM

    If you are using Crystal Reports Server, then you can create Dynamic Data Connection in Business View Manager based on the first parameter. Then create a Business view and report will connect to the Business View.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2017 at 03:43 PM

    Thanks very much Vitaly Izmaylov for the suggestion I will give it a try, I implemented it as two reports for the time being, but will try your suggestion.

    Cheers,

    Dev

    Add comment
    10|10000 characters needed characters exceeded