Grid, group by and inner joins

Applications Grid / Reports
#1

Hi, I had a grid app, with the follow sql sentence

SELECT
orderitens.ordeintesid,
orderitens.orderid,
orderitens.quantity,
orderitens.unitprice,
orderitens.total,
orderitens.unitpricec,
orderitens.totalc,
orderitens.name_code,
orderitens.obs,
products.picture,
products.price,
products.peso
FROM
orderitens INNER JOIN products ON orderitens.name_code = products.name

Grouped by orderitens.name_code

But I want that products.picture, products.price, products.peso shows just one time, no matter the result catch more than one register grouped by orderitens.name_code

For example

orderitens.name_code = fd-001, returns 4 regiter, cause 4 diferents clients order that product, thats ok, but I need just show one time the picture, the price and the weight
and then 4 of the rest fields.

How can I do that? I can’t group by picture too, cause is a blob field and shows symbols not the image if I group for this field.

Any ideas??

Thanks in advance

#2

I’m not sure but I thought that there was a setting to suppress repeating values. But if you cannot use that you can always use the onload event to clear the data if needed. You need to use some global variables to store the data from the previous record. But if you do the problem can be solved pretty straight forward:

(in onload)


if ({myvalue}==[oldvalue])
   {myvalue}='';
 }

[oldvalue]={myvalue}
#3

Thanks, I will try with that