RE: [sqr-users] on-break

["saritha ventrapragada" <sperumudi@hotmail.com>]

Hi,
Thank you very much.
I did not know that there are such contraints. For readability I intented 
table fields.
I did try without intending them. This time i was gettting another error. I 
says syntax of sql statement is wrong. Without using these on-break query 
worked well. I m not sure where i did wrong.

I would appreciate if you could let me know where I can find the rules that 
should be followed while writing sqr.

Thank you very much
Saritha

>From: "Bencke, Gina" <GinaBencke@forestcity.net>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] on-break
>Date: Wed, 9 Jun 2004 12:44:44 -0400
>
>Unless something is different in SQR for PeopleSoft, the syntax and
>spacing of your select paragraph is important
>
>Begin-select and column names must be flush against the left margin of
>your.sqr file.  SQR commands must be indented.  No SQR Commands can be
>listed between the FROM and the END-SELECT.
>
>BEGIN-SELECT
>Column1  () ...
>Column2  () ...
>   add 1 to #var1
>   add 1 to #var2
>FROM ...
>WHERE ...
>END-SELECT
>
>
>-----Original Message-----
>From: sqr-users-bounces+ginabencke=forestcity.net@sqrug.org
>[mailto:sqr-users-bounces+ginabencke=forestcity.net@sqrug.org] On Behalf
>Of saritha ventrapragada
>Sent: Wednesday, June 09, 2004 12:29 PM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] on-break
>
>
>Hi,
>I was trying on-break command. I am using peoplesoft8.8
>
>This is my sample .sqr file
>    A.EMPLID (+2,1,6)
>    B.NAME (,10,20)   ON-BREAK PRINT=CHANGE/TOP-PAGE LEVEL=1 SKIPLINES=1
>SAVE=$OLDDEPT
>    A.DEPTID (,60,10)   ON-BREAK PRINT=CHANGE/TOP-PAGE LEVEL=2
>SAVE=$OLDSTART
>AFTER=TOTALDEPTS
>    C.DESCR    (,75,8)
>    A.JOBCODE  (,95,6)
>    D.DESCR    (,105,6)
>
>ADD 1 TO #DEPTCNT
>ADD 1 TO #GRANDTOT
>
>       FROM PS_JOB A, PS_EMPLMT_SRCH_QRY A1, PS_PERSONAL_DATA B,
>PS_DEPT_TBL C,
>PS_SET_CNTRL_REC C2, PS_JOBCODE_TBL D, PS_SET_CNTRL_REC D2
>       WHERE C.DEPTID = A.DEPTID
>..........
>...........
>...........
>
>
>I was getting these errors.
>
>Error on line 40:
>    (SQR 3721) Bad param found on 'BEGIN-SELECT' line; Format is:
>BEGIN-SELECT [DISTINCT] [-Cnn] [LOOPS=nn]
>               [ON-ERROR=procedure[(arg1[,argi]...)]]
>               [-DB=database]
>A.EMPLID (+2,1,6)
>
>Error on line 42:
>    (SQR 3704) Missing procedure name.
>B.NAME &NAME
>
>Error on line 45:
>    (SQR 5303) Invalid qualifier 'a.deptid'.  Valid qualifiers are: bold
>box center code code-printer edit fill match nop on-break shade
>underline wrap number money date delay foreground background url font
>point-size url-target A.DEPTID &DEPTID
>
>Error on line 48:
>    (SQR 5303) Invalid qualifier 'c.descr'.  Valid qualifiers are: bold
>box center code code-printer edit fill match nop on-break shade
>underline wrap number money date delay foreground background url font
>point-size url-target
>C.DESCR    (,75,8)
>
>Error on line 49:
>    (SQR 3701) Invalid command.
>A.JOBCODE  (,95,6)
>
>Error on line 50:
>    (SQR 3701) Invalid command.
>D.DESCR    (,105,6)
>
>Error on line 55:
>    (SQR 3728) SQL expression not ended, perhaps missing &name. FROM
>PS_JOB A, PS_EMPLMT_SRCH_QRY A1, PS_PERSONAL_DATA B, PS_DEPT_TBL C,
>PS_SET_CNTRL_REC C2, PS_JOBCODE_TBL D, PS_SET_CNTRL_REC D2
>(SQR 4407) Referenced variables not defined:
>
>   &name
>   &deptid
>
>Errors were found in the program file.
>
>SQR for PeopleSoft: Program Aborting.
>
>
>I would apprecitae if anyone could help me out in solving these problem
>Thank u saritha
>
>_________________________________________________________________
>Looking to buy a house? Get informed with the Home Buying Guide from MSN
>
>House & Home. http://coldwellbanker.msn.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

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/


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