RE: [sqr-users] help in sqr: sucess is posted...cant able to c theo/pfile -- pdf

[deepa konga <deepakonga@yahoo.com>]

Thanks Larry..
I got that...
 
I am able to see O/P file

--- On Fri, 6/27/08, Larry Roux <lroux@syr.edu> wrote:

From: Larry Roux <lroux@syr.edu>
Subject: RE: [sqr-users] help in sqr: sucess is posted...cant able to c the 
o/pfile -- pdf
To: "This list is for discussion about the SQR database reporting language from 
Hyperion Solutions." <sqr-users@sqrug.org>
Date: Friday, June 27, 2008, 6:50 PM

Is the SQR select selecting anything?  Try adding some show statements to ensure
that your parms are actually getting data.  Look for the ! ADDTHIS comments
below
 
If you see the show statements then you have to find out why it is not
printing. Check the location of your output

________________________________

From: sqr-users-bounces+lroux=syr.edu@sqrug.org on behalf of deepa konga
Sent: Fri 6/27/2008 4:59 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] help in sqr: sucess is posted...cant able to c the o/pfile
-- pdf



                                                                    
                                                                    
     not getting the o/p..pdf file.....help with this..                        
                                       
                                            
#Include 'Setenv.Sqc' !Set Environment
#Include 'Setup31.Sqc' !Printer And Page-Size Initialization
!---------------------------------------------------------------------------------------------------------------
Begin-Setup
!---------------------------------------------------------------------------------------------------------------
Declare-Variable
 DATE $VDATE $TDATE
End-Declare
!-------------------------------------------------------------
End-Setup
!-------------------------------------------------------------
!-------------------------------------------------------------
Begin-Report
!-------------------------------------------------------------
Do Init-Report
If $Prcs_Process_Instance <> ''
 Do Update-Prcs-Run-Status
End-If
!-------------------------
End-Report
!-------------------------
!--------------------------------------
Begin-Procedure Init-Report
!--------------------------------------
Do Init-Datetime
Do Init-Number
Do Get-Current-Datetime
Do Define-Prcs-Vars
Do Get-Run-Control-Parms
Do voucher_list
!---------------------------
End-Procedure
!---------------------------
!--------------------------------------
begin-heading 3
!--------------------------------------
print  'BUSINESS_UNIT' (2,1)
print  'VOUCHER_ID'    (,30)
print  'VNDR_LOC' (,70)
!-------------------------
end-heading
!-------------------------
!-------------------------
begin-procedure get_parameters
!-------------------------
!-------------------------
begin-select
!-------------------------
TEST.OPRID
TEST.RUN_CNTL_ID
TEST.BUSINESS_UNIT &TEST.BUSINESS_UNIT
TEST.VOUCHER_ID &TEST.VOUCHER_ID
TEST.VNDR_LOC &TEST.VNDR_LOC
 let $BU = &TEST.BUSINESS_UNIT
 let $VID = &TEST.VOUCHER_ID  
 let $VNDRLOC = &TEST.VNDR_LOC 

show 'Retrieved parms:  Business Unit: ' $BU ' VID: ' $VID
' VendorLoc: ' $VNDRLOC  ! ADDTHIS


from PS_CT_RAD_RECORD TEST, PS_PRCSRUNCNTL TEST2
where TEST.OPRID = TEST2.OPRID and TEST.RUN_CNTL_ID = TEST2.RUN_CNTL_ID
 
!-------------------------
end-select
!-------------------------
!-------------------------
end-procedure
!-------------------------
!-------------------------
begin-procedure voucher_list
!-------------------------
!-------------------------
do get_parameters
begin-select
!-------------------------
TEST1.BUSINESS_UNIT (,1) 
TEST1.VOUCHER_ID (,30) 
TEST1.VNDR_LOC (,70)

  show '  got row ' &TEST1.BUSINESS_UNIT ' '
&TEST1.VOUCHER_ID ' ' &TEST1.VNDR_LOC  ! ADDTHIS


from PS_VOUCHER TEST1
where TEST1.BUSINESS_UNIT = $BU and TEST1.VOUCHER_ID = $VID and TEST1.VNDR_LOC
= $VNDRLOC
order by TEST1.BUSINESS_UNIT, TEST1.VOUCHER_ID
!-------------------------
end-select
!-------------------------
!--------------------------------------
end-procedure
!--------------------------------------
 
#Include 'Curdttim.Sqc' !Current Date And Time
#Include 'Datetime.Sqc' !Routines For Date And Time Formatting
#Include 'Number.Sqc' !Routines To Format Numbers
#Include 'Prcsapi.Sqc' !Update Process Request Api
#Include 'Prcsdef.Sqc' !Update Process Request Variable Declaration
#Include 'Reset.Sqc' !End Of Program
#Include 'stdapi.sqc'



     

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-usersHere was a non admissible 
message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list._______________________________________________
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