Summary Report

[tyagishaila]

Hi All,

I have a straight table, I need a summary report of this table

Summary report represent No of Lines (Total Rows) on different different  conditions .

Please help me out how can achieve this.

Below is the ex of summary report:

VOLUME LINES EXCEPTION SUMMARY
EXCEPTION		WOMENSWEAR	MENSWEAR	LINGERIE	TOTAL
No of lines with "Store Week Cover" less than	4	13	13	4	30
No of lines with zero BTF, but wh available		1	3	5	9	(curr wh stks>10); btf=0
No of lines with wh avail % higher than	0.50%	18	32	25	75
Lines with No balance on order		78	139	76	293	BOO less than 10 sgls
No of lines not acc to cat plan		100	107	63	270	where plan cat is not equal to actual cat

[datanibbler]

Hi shaila,

if you already have a straight table, then you also have those dimensions, right?

=> Just create a second straight table with those two dimensions and just the COUNT of lines (if necessary, just use rowNo() in the script to have a line_ID) as expression.

=> Then put that into a report (to print out).

HTH

[tyagishaila]

Hi Nibbler,

Thanks for quick reply,

I did this but , With this I got values of expression but I need only count.

Well I solve it for now.. but not happy with long method which I follow.

Thanks for your reply.