Hi,
I built a simple crosstab report. I put a simple measure in the row area of the crosstab. In the column area I put a data item with the following expression:
IF (intersect(set(#promptmany('Parameter1';'token')#);set([Accessoires];[Campingausrüstung])) is not null) THEN
( [Bergsteigerausrüstung] )
ELSE
( [Produkte] )
In the case that the input parameter doesn't contain the elements Accessoires and Campingausrüstung the expression works as expected.The ELSE part is used and the correct measure value is displayed in the crosstab.
If the input parameter contains Accessoires or Campingausrüstung but not both elements the THEN part is used and the correct measure value is displayed in the crosstab.
But in the case that the parameter contains the both elements Accessoires and Campingausrüstung, no measure value is displayed in the crosstab cell. Instead -- is displayed in the cell.
Any idea please
Thanks!
Tobias