RE: [sqr-users] sending declared-reports to one spf file

[Steve Cavill <steve.cavill@infoclarity.com.au>]

Hi Eric,
Every declared report will define it's own SPF file note if nothing is
written, the file will not be created - but it defines the output file name
BEFORE it knows that!
so myrep.sqr will create myrep.spf myrep_01.spf myrep_02.spf etc

I can see two possibilities for your problem.
One way is to declare only the required report.  You can use ASK to do this,
so based on input you declare the required report.  Then the output of
myrep.sqr will be myrep.spf, whichever report you call e.g.


begin-setup
ask #whichrep
#if #whichrep='rep1'
declare-report rep1
end-declare
#else
declare-report rep2
end-declare
#end-if
end-setup

begin-program
#if #whichrep='rep1'
use-report rep1
print 'this is the rep1 ' ()
#else
use-report rep2
print 'this is the rep2 ' ()
#end-if

end-program

The other option is to use -F command line flag to rename the output to the
same name.

sqrw.exe myrep.sqr <dbconnect> -keep -nolis -Foneoutput.lis -Foneoutput.lis

Both reports will write to oneoutput.spf.

(-keep says keep the spf, -nolis says don't create the lis files - note you
still use the .lis extension in the rename -F flag, SQR correctly creates
the SPF called oneoutput.spf

Note that these methods will ONLY work if only one report is actually used.
You can't write two reports to the same spf file, or concatenate them or
basically manipulate the spf in any way

Cheers, Steve

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Ottaway, Eric (PS, GNF, Contractor)
Sent: Tuesday, 28 October 2003 6:54 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] sending declared-reports to one spf file


Hi all,

I have a report that declares three reports. Depending on the input given,
one of those reports will be called. I've noticed that
each report declared has its own spf file. It it's possible, how can I get
these reports to print on one spf file?

Thanks in advance,

Eric B. Ottaway
TAD / GE - GNF
*-(910) 675-5603
*-eric.ottaway@gnf.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users