RE: [sqr-users] Reg. SQR PDF Reports

["Larry Roux" <lroux@syr.edu>]

Try this:  At the very start of the SQR (after the run control info is
retrieved) put in the following commands:

Let $report_name = 'directory' || 'sqrname' || '_' ||
$prcs_process_instance  || '_1.lis'
new-report $report_name

substitute the directory and sqr name, of course, with your local info.

You will still get an sqr.lis, etc...but it will now be blank.  I am not
sure if the other reports will end up _3, _4, etc though.  So you might
end up with 1, 3, 4, 5, etc.  You will have to try it.



-----Original Message-----
From: sqr-users-bounces+lroux=syr.edu@sqrug.org
[mailto:sqr-users-bounces+lroux=syr.edu@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, September 24, 2007 10:43 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Reg. SQR PDF Reports

Hi 
   Thanks for your response. But I don't see NEW-REPORT in the code. I
would like to get the pdf format as 1,2,3.pdf files. Any change to be
made to the code?

Thanks
Ram
  

-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org] On
Behalf Of Larry Roux
Sent: Monday, September 24, 2007 10:28 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Reg. SQR PDF Reports

I believe the first report is created according to the output flag (ie
-oc:\ps\sqr.lis).  The rest can go to another directory and are named
according to the report fashion you indicated.  You can get around that
by creating a new-report immediately, so the first report is _2, the
second is _3, etc.

-----Original Message-----
From: sqr-users-bounces+lroux=syr.edu@sqrug.org
[mailto:sqr-users-bounces+lroux=syr.edu@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, September 24, 2007 10:25 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Reg. SQR PDF Reports

Hi All,

        I have a query on Override Options that's set if I have multiple
reports. Iam running a SQR that produces 3 reports. So I have set as -MR
3. But after running the sqr, it gives only 2 pdf reports.
<sqrname>_<prcsinstance>_2.pdf, <sqrname>_<prcsinstance>_3.pdf.

When I change to -MR 4. it produces <sqrname>_<prcsinstance>_2.pdf,
<sqrname>_<prcsinstance>_3.pdf, and <sqrname>_<prcsinstance>_4.pdf. I
don't understand why the reports don't start with
<sqrname>_<prcsinstance>_1.pdf, <sqrname>_<prcsinstance>_2.pdf, and
<sqrname>_<prcsinstance>_3.pdf.

Is there any code issue?

Pls help

Thanks in Advance
Ram

_______________________________________________
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

_______________________________________________
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