Skip to Content
0

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

Aug 07, 2017 at 12:15 PM

31

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Aug 10, 2017 at 01:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded