Path: utzoo!attcan!uunet!mcvax!enea!kth!draken!tut!santra!tukki.jyu.fi!jukka
From: jukka@tukki.jyu.fi (Jukka Hartikainen)
Newsgroups: comp.databases
Subject: INGRES REPORT-WRITER in Sun 3/260, SunOS3.4
Message-ID: <18343@santra.UUCP>
Date: 21 Dec 88 12:48:41 GMT
Sender: news@santra.UUCP
Reply-To: jukka@tukki.jyu.fi (Jukka Hartikainen)
Organization: University of Jyvaskyla, Finland
Lines: 34

Hello everybody!
I have a problem with Ingres Report Writer. We have a SUN 3/260, SUN3.4OS,
Ingres is 5.0/01 (sun.u42/02). This is a simple example of that,
what will be happened (or not).
If I put a report header, a simple print-clause, all what happens is
that report header will be printed, SALDO. Nothing else.
If there ain't any report header, (here it's a comment), all the details and
footers are quite right!  This problem is just in SUN and Unix; in VMS
the same reports work well.

Where is the bug? In SUN, in UNIX, in Ingres??  In Me???

.NAME	saldo
.leftmargin 5
.rightmargin 78
.QUERY
	SELECT *
	FROM	tilit 
.SORT	
        pvm :a

/*.header report*/
        /*.pr "SALDO"*/
        /*.nl 2*/
.detail
        .pr pvm(c8),numero(c5),selite(c15),summa(f9.2)
        .nl 1
.footer report
        .pr "-------------------------------------"
        .nl
        .pr "                   SALDO :  ",sum(summa)(f9.2)

Thanks and Merry Xmas,
Jukka Hartikainen, jukka@tukki.jyu.fi