I have designed a crystal report which has BEX query as a datasource. The values from this query are placed in page header. Also two subreports are available which get data from an RFC. Main report and sub report are linked by primary key ID.
(In the bex query one condition is implemented on a key figure) When I run the BEX query , it retrieves single record. But when I execute the crystal report, execution says 2 records and my details section is getting repeated.
I am unable to use filter as it is a keyfigure.
Any suggestions or help here is highly appreciated.
BEX query retrieves only one record (In the bex query one condition is implemented on a key figure) When I run the BEX query , it retrieves single record). I am puzzled on how the crystal is retrieving two records.
Actually infocube has 2 records one with status "active" and the other with status "postponed". Some other fields also will vary.
So, I cannot use this formula to supress.