Skip to Content
0
Jan 13, 2012 at 05:19 PM

Less records in Crystal Reports with source SAP BEx query

28 Views

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.