Post Author: sharonmtowler
CA Forum: General
i have a report which displays items and qc tests and the qc results. each item has a lot and the lot is tied to numerous tests.(data from sql sp)
i am having trouble laying out the report they way i would like and so it is exportable to xls. the data looks like this(red are the tests) when grouped by test
WHSE
ITEM
PACK
LOT
WBER
NP-101
2204CT
NP01B81317
BD2
1.25
Contam
1.00
EL
FEPBubble
Gel Index
0.73
MFR
25.10
MIT
MP
258.60
PCI
0.00
PS
99.50
SG
StrandPS
TS
Vol
0.10
what i did next was create a formula (if test = 'bd2' then value, which captures my value but displays it as follows) i have tried to format in multiple columns, but it stills shows 0 value , i remove the grouping and just leave in details it only shows first value of 0 and not result.
WHSE
ITEM
PACK
LOT
GROSS QOH EA
WBER
NP-101
2204CT
NP01B81317
1.00
1.25
0.00
0.00
0.00
1.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00