J
Jorge
Hi there.
I need to make a report based on a query that changes
dynamicaly. Trying to explain better:
I have a table of stocks, a table of customers and a table
of request of stock for each customer. I want to make a
report showing the customer & request number (rows) and
the quantity of stock demand for each request (columns).
In each cell (row,column) I want to have the number of
that article requested in that request, like this:
Article 1 Article 2 Article 3
Request 1 1 5
Name 1
Request 2 8 3
Name 2
As you can imagine I don't want to show all stock items,
only the ones that have pending requests.
How can I do this?
Thanks in advance.
I need to make a report based on a query that changes
dynamicaly. Trying to explain better:
I have a table of stocks, a table of customers and a table
of request of stock for each customer. I want to make a
report showing the customer & request number (rows) and
the quantity of stock demand for each request (columns).
In each cell (row,column) I want to have the number of
that article requested in that request, like this:
Article 1 Article 2 Article 3
Request 1 1 5
Name 1
Request 2 8 3
Name 2
As you can imagine I don't want to show all stock items,
only the ones that have pending requests.
How can I do this?
Thanks in advance.