Get matrix row data and put it into header field with formatted search ???

74 Views

Hi All,

I ask your help concerning the following:

On an invoice matrix I want to check all Itemgroup Codes of all items in the rows, if there are some rows' items with ItemGroupcode 101 and some others with anything else, then header field should be Y, otherwise N.

My main problem is: how do I put a matrix row data to a header data with checking all rows in the matrix?

A minor problem is that I can't get the formatted search to work on all rows when the formatted search is assigned to the user field in header.

If I put the formatted search to a row field then the row field is filled with the proper value, but the same query assigned to the user field in header works only on the first row.

What am I doing wrong?

SELECT USEDPROD= CASE T0.ItmsGrpCod WHEN 101 THEN Y ELSE N END FROM .[OITM] T0 WHERE T0.ItemCode = $[$38.1.0]

(SBO 7.6)

Any suggestions are welcome.

Thanks.

Bálint