filter to get data

Discussion & Feedback for Jet Enterprise
juenliang
Posts: 3
Joined: Wed Aug 17, 2016 1:28 am

filter to get data

Postby juenliang » Thu Mar 09, 2017 12:15 am

Hi all,
I am facing the problem where i got the data with the following criteria in my table:
Date:
Document Number: ABC01-01010
Item No: T001, T002, T003
Quantity:

Data 1: Document number: ABC01-01010, T001 (Quantity: 10) , T002 (Quantity 20), T003 (0).
Data 2: Document number: ABC01-01010. T001 (Quantity 0), T002 (Quantity 10), T003 (Quantity 10)
Data 3: Document number: ABC01-01011, T001 (Quantity: 2), T002 (quantity 3), T003 (Quantity 4).

Is it possible to let jet report to get the data in group??
T001 T002 T003
ABC01-01010 10 30 10
ABC01-01011 2 3 4

User avatar
HPDeskJet
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: filter to get data

Postby HPDeskJet » Thu Mar 09, 2017 8:28 am

Perhaps something like this?
design.png
design.png (6.37 KiB) Viewed 163 times

Here is the result:
result.png
result.png (3.12 KiB) Viewed 163 times
-HP
_______________________
Jet 2015 Certified Trainer


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 1 guest