Hi.
I have created a Crystal Reports which has as a source a Bex Query. The Bex query 2 filters (date_start and date_end) In the Crystal I have created 6 Parameter Fields and I have put the parameters with the select expert in the record group.
When I execute the report in Crystal, the report doesnu2019t show all the values, the crystal report donu2019t show all of the records and the totals are incorrectly. I have verified that I have data in the Bex query.
The parameters are created as following:
Name: Parameter1 to 5
Type: string
List of Values: Dynamic
Value: Infoobject1-value (the code of the infoobject).
Show on the Panel : Editable
Optional = true
Allow multiple values = true
Allow discrete values = true
Name: Parameter6
Type: string
List of Values: Static
Value Field: Infoobject6-value (the code of the infoobject).
Show on the Panel : Editable
Optional = true
Allow multiple values = true
Allow discrete values = true
The syntax in the Record selection is the following:
(not HasValue({?Parameter1}) OR {Query_Bex.Infoobject1-value} = {? Parameter1}) and
u2026.
(not HasValue({?Parameter6}) OR { Query_Bex.Infoobject6-value} = {? Parameter6})
Can Anybody help me?.
Many thanks and best regards.