Eu criei uma consulta para buscar:
O que tenho em estoque + o último preço de compra.
A consulta é para obter a valoração do meu estoque.
Mas quando utilizo a função MAX(), ela procura algum valor que não consegui descobrir. E se eu não usar MA...
I created a query to fetch:
What I have in stock + the last purchase price.
But when I use the MAX() function, it looks for some value that I couldn't find out. And if I don't use MAX() on certain columns, the query simply duplicates the values.
...
Dear,
I have a problem that I can't see a way out.
So 3 types of orders are issued: Sales orders, Service orders and Assembly orders and for each type, we have a different header.
For the seller, ok, he can separate, but the other departments t...
At the level of knowledge for the next users (since this post is quite old), to export the .rpt file, go to layouts and reports manager > select the report you want to export and click on "process", which will open the Crystal Reports (this process a...
I didn't want to do it that way, but I solved it using Crystal and creating a user table to register the headers. That way I don't have to worry about cross-user view settings. the only thing that was manual was the user having to select which addres...