Crystal report parameter from BEx query comes mandatory instead optional

[Private_Member_24235]

Dear all,

I have running CR 2008 and have created a crystal report which refers to an BEx query. After I have refreshed the DB connection via menu Database--> check database all filter varibales from the BEx query gets leveraged into crystal as parameter. MY problem: I have defined one Bex filter variable as optional,

but in Crystal I receive this parameter as mandatory. I  am not able to define the property "optional" as true, because the relevant line is grey and can not be maintained. Even after several DB refreshments via menu Database-->check database, the parameter gets not the optional value.

How can I define the parameter as optional. Any help would be great.

Best regards from Munich/Germany

Stefanos Leontiadis

[abhilash_kumar · Accepted solution]

Hi Stefanos,

Please see if the suggestion in this thread helps.

https://scn.sap.com/thread/2094562

-Abhilash

[Former Member · Accepted solution]

Hi Stefanos,

Please follow abhilash suggestion and i add one more useful threads:

Only if this parameter has no formula bind, you can really make it optional.

Thanks

Dhana

[abhilash_kumar · Accepted solution]

Also, you'll not be able to change the prompt properties inside CR Designer for BEx variables.

You might also want to have a look at this SAP Note.

-Abhilash

[abhilash_kumar · Accepted solution]

Hi Dhana,

I think you misunderstood the issue. The issue is not really with the Optional Prompts in CR or for that matter SAP B1. The issue is related to a 'variable' defined as 'optional' inside SAP BEx queries that appears as 'mandatory'.

The link you posted are for completely different issues.

-Abhilash

[Private_Member_24235 · Accepted solution]

Dear Abhilash,

thank you, the hint. After putting the variable into filter restriction and refreshing again the database, the respective parameter is now optional.

Best regards,

Stefanos