on 08-12-2011 12:19 AM
Dears
I have a usage decision code like
1.Material passed in first test
2.Material passed in second test
3.Material passed in third test
Now i need to get one report like
How many UD i given by using 1.Material passed in first test,2.Material passed in second test, etc....
and what are the material passed through that
how i can have a report like...Any std report available
Faisal
Dear Faisal,
Have a look on the excellent functionality that Microsoft Excel has provided!
Download QA33 with UD codes in excel and simply use u201CPivot Tablesu201D. I am sure it works 100% with ease avoiding any sort of report development.
Regards,
Anand Rao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi !
What process are you following to define those 1st test/2nd test and 3rd test?
Anyways, use UD code according to your need, like A1 - Passed 1st test, A2 - Passed 2nd test and A3 - Passed 3rd test. Athen in QA33 filter the lots according to UD code. otherwise, a simple query linking QALS and QAVE will give you a report for lot/material vs UD code. Put a simple formula to count the no. of times a particular UD code appears and you are done with your requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can
1. use qa33 ,put filter on "UD code".
2.you can use QAVE table.
3.MCXE : if you have made distinction of UD code as per class like class A ,class B etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
10 | |
9 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.