Document line count without storing them

[Former Member]

Hi Gurus,

The standard way to calculate the number of document lines is:

- Define Line as a key field in DSO

- Define ZCOUNT = 1

- Sum ZCOUNT in Query

This wastes disk space if there are no line details needed. I would like to put only doc.number as key field. Is there a nice way to implement ZCOUNT = 'Total number of lines' ?

Thanks,

Tuomas

[former_member181964 · Accepted solution]

Hi,

If you have "document number in DSO, then in report directly you can calculate using

COUNT(document number)

in Formula.

Thanks

Reddy

[Former Member · Accepted solution]

Hi!

This is one possibility, thanks.

I need doc.header data and the number of lines - not line details. I would like to leave doc.line out. Including it in DSO multiplies its size by many times. Maybe I should create two DSOs: One for doc.header details and another for only calculating doc.lines. Then combining them in a MultiProvider and counting lines in a query.

Tuomas