RE: [sqr-users] RE: SPF

[Gina Bencke <g.bencke@csuohio.edu>]

I have 'tricked' the Report Manager into picking up the .PDF file even when
a report fails by adding the following code prior to the STOP command.   
This code is added to the stdapi.sqc file (of course we cloned this sqc and
renamed it).

    show ' '
    show 'ERRORS FOUND.'        
    new-report 'junk.lis' ! this will allow the current report file to be 
                          ! written to disk so that the Process scheduler
                          ! and Report Manager can pick it up. 
    stop        


Gina Bencke
Business Analyst
Information Services & Technology
Cleveland State University
Phone: (216) 875-9630
Fax:    (216) 687-9200
  
 

-----Original Message-----
From: sqr-users-bounces+gina.work=bencke.com@sqrug.org
[mailto:sqr-users-bounces+gina.work=bencke.com@sqrug.org] On Behalf Of
radhika reddy
Sent: Friday, July 22, 2005 2:51 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] RE: SPF


Thanks a lot for your inputs. It helped me a lot to understand about SPF. 
But is it better to ask the users to look in SPF viewer whenever there is an

error or is it possible to convert it to PDF by forcing it to close. But the

second scenario is cumbersome as there is lot of error checking in my 
program.

Thanks again.


>From: "White . Denise" <DWhite@drc.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: <sqr-users@sqrug.org>
>Subject: [sqr-users] RE: SPF
>Date: Fri, 22 Jul 2005 08:41:41 -0400
>
>Hi Radhika,
>
>While SQR is running, it writes the output to an .spf file.  After SQR
>closes the file (usually at the end of the program, but you can force it
>to close if you use the new-report command), it converts it to .lis or
>.pdf.  Because your program is abending before it does this conversion,
>you are left with the .spf file.  I believe you should be able to view
>it with the SQR Viewer, which does come with SQR; the executable is
>sqrwv.exe, and should be in the same directory where you have sqrw.exe.
>In my case, this is on the PSoft file server, under the bin\sqr\ora\binw
>directory.  You may have to save the .spf file out of the Process
>Monitor in order to have a file name to open.
>
>HTH,
>
>Denise M. White
>EBS Programmer/Analyst III
>Enterprise Business Systems
>Dynamics Research Corporation
>------------------------------
>
>Message: 2
>Date: Thu, 21 Jul 2005 16:11:33 -0500
>From: "radhika reddy" <radhika_05@hotmail.com>
>Subject: [sqr-users] SPF
>To: sqr-users@sqrug.org
>Message-ID: <BAY103-F33C33AE03E1016A171B6F6E9D60@phx.gbl>
>Content-Type: text/plain; format=flowed
>
>Hi,
>
>    My program generates a PDF format error report. But when the program
>abends it generated an SPF format. What is the reason for this to
>happen?
>and can i view this file. Documentation says that i can view using SPF
>viewer. Does this come with the SQR?
>
>I am running through Process Scheduler.
>
>Thanks. Any input would be great.
>
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
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