Numbering Lines - End User

rbuser

I am trying to come up with a solution that end users can use
to number lines in their reports.

One solution:
Use a calculation in the SQL with runsum(1)
It works quite well for most cases.

However, because of the requirements of GROUP BY this doesn't
always work (if the report includes memo fields for instance.

Is there another way to number lines in the end user design without
creating a dataset with record numbers?

Jon
--
Jon Lloyd Duerdoth
Welsh Dragon Computing
http://www.welshdragoncomputing.ca
Visit All Saints' Kingsway Anglican Church
http://www.allsaintskingsway.ca

nicocizik

Hi Jon,

Try placing a dbCalc component in your detail band and set it to Count(*)
without setting a data field (this is the default when there is not
datafield defined). This should count the lines out for you.

--

rbuser

Nico Cizik (Digital Metaphors) wrote:

That did it! Thanks

Jon



--
Jon Lloyd Duerdoth
Welsh Dragon Computing
http://www.welshdragoncomputing.ca
Visit All Saints' Kingsway Anglican Church
http://www.allsaintskingsway.ca