Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can do this liek table with all column,values and then list box that column and select the 2 values and left click exclude and will show what i want in table .
How to make this in script :
Select * from table
Where Type not in(261,261)
Second thing i need is :
after i get the result is where i get 2 same entries or more for a value of column 3 lets say to show only one value and some up the values from column 4 for those entries that had same value in column 3 .
I used this and it shows all but excluded and sum like i want :
Sum({<TMş=-{261,262}>} Cantitate) that gives me this:
The problem is that i need to have a final table that should show: So i need to get the excluded one to show in the final report as it tied like the excluded one is iron and has the register code ,from iron i made doors ,car part that have registry code in system also ...
Comanda PP | Lot MP | Data transarii | Materie Prima | Lot PT | Piesa transata |
1050059 | 55441 | 6/5/2014 | 1000403 | 55441 | 2000050 |
2000131 | |||||
55441 | 2000199 | ||||
9200003 |