Skip to Content
avatar image
Former Member

Exporting to Report Definition doesn't show parameters with default values

I have a parameter defined with a static list of values and want to change this to a dynamic list of values. I'd like to compare the static list with the table that the dynamic list will be coming from. However, when I export to report definition, it only refers to the parameters if the parameter is referenced in a formula.

Is there a way to see the static list of values, short of taking screen shots?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 10, 2017 at 01:15 PM

    Hi Phyllis,

    Yes you can, edit the report and select the Parameter and edit it. You'll see the Actions button, it has the ability to export the values.

    Or if you want to use the the .NET SDK you can get them also.

    On a separate PC go here:

    https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

    and download the 32 bit MSI package:

    SAP Crystal Reports Runtime (32Bit)

    SAP Crystal Reports runtime engine for .NET framework (32Bit). No IDE integration

    Then on the above link there is a test app I wrote you can use to get them:

    https://blogs.sap.com/2016/02/17/how-to-parameters-in-crystal-reports-for-visual-studio-net/

    Run the exe whereever you extracted the files to in this folder \RAS2010_CsharpParameters\bin\Debug\

    Unmanaged_RAS10_CSharp_Parameters.exe

    Open the report, used a saved data report then it should not require connecting to the DB, not sure if the application needs the log on button fixed or not, usually this is for developers to run in debug mode.

    Once the report is opened the on the right side there is a drop down box and you can select Parameters, the output should look something like this:

    Discrete Param Name: "LOV" (Crystal Static LOV Parameter)
    Allow Custom Values: True
    Allow Multiple Values: False
    Allow Discrete Values: True
    Allow Null Values: False
    Based on Field: {Customer.Customer Name}
    Default Value #1: "7 Bikes For 7 Brothers" - Description: (blank)
    Default Value #2: "Against The Wind Bikes" - Description: (blank)
    Default Value #3: "AIC Childrens" - Description: (blank)
    Default Value #4: "Alley Cat Cycles" - Description: (blank)
    Default Value #5: "Ankara Bicycle Company" - Description: (blank)
    ----------------------------------------------------------------------------------------------------------

    Discrete Param Name: "DefaultValue" (Crystal Static LOV Parameter)
    Allow Custom Values: True
    Allow Multiple Values: False
    Allow Discrete Values: True
    Allow Null Values: False
    Based on Field: {Customer.Customer Name}
    Default Value #1: "Ankara Bicycle Company" - Description: (blank)
    ----------------------------------------------------------------------------------------------------------

    Discrete and Range Param Name: MyLOV" (Crystal Dynamic Cascading Parameter)
    Allow Custom Values: True
    Allow Multiple Values: True
    Allow Discrete Values: False
    Allow Null Values: False
    Based on Field: Customer.Customer ID
    No Default or Current Value saved in the Report"
    ----------------------------------------------------------------------------------------------------------

    See if that works for you also, but using CRD is the easiest way, depends on the version of CRD you have also.

    Don

    Add comment
    10|10000 characters needed characters exceeded