Skip to Content
0
Former Member
Apr 22, 2008 at 09:54 PM

REPORT LAYOUT

11 Views

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