Re: Mysterious line advance in report

[Nathan Stratton Treadway <nathant@ONTKO.COM>]

On Thu, Jun 17, 1999 at 01:12:59PM -0700, Mike Harrison wrote:
> ID#   Name   Code Count
> XXXX  XXXXX  XX
>                   2
>
> The select is just like this:
>
> begin-SELECT
> A.ID     (+1,1)
> A.NAME   (0,7)
> A.CODE   (0,14)
>    do Count-Things
>    print #Thing-Count (0,18) edit 9999
> FROM A_TABLE A
> end-SELECT
>
> The Count-Things procedure has no printing in it.
> So, what could cause the Count field to go down a line like that?

Make sure your report page size is wide enough to handle the
length of the fields you are printing without running off the right side
of the page.  If any of your columns are CHAR (instead of VARCHAR)
columns, you might have to worry about trailing spaces on the values
being printed.

Also, make sure that the values coming out of A.CODE do not have any
control characters in them.  (Sometimes the database columns can contain
<CR> characters, for example.)

(You might put a "print 'TEST' (0,18)" before the call to Count-Things
just to make sure that the line advance isn't happening within
Count-Things.  If TEST shows up where the count is supposed to go, then
the problem happens somewhere in Count-Things; if TEST is down a line,
the problem is in the printing of the first three columns....)

                                                Nathan

----------------------------------------------------------------------------
Nathan Stratton Treadway  | Ray Ontko & Co. | Software consulting services
nathant@ontko.com         | Richmond, IN    | http://www.ontko.com/