Ask Question
Help Others
Home › Forums › PeopleSoft › PeopleSoft Technical

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Can On-Break Logic be used in writing csv files in SQR ?

5 replies [Last post]
Mon, 02/09/2009 - 12:55am
sweety's picture
sweety
User offline. Last seen 10 years 15 weeks ago. Offline
Joined: 01/16/2009
Posts: 15

I am using onbreak at two levels.The output in pdf files is proper.but when i try to put in csv files using Write command, the data gets repeated .
And if i use write command in onbreak procedures , then in the output of csv files ,the rows gets shifted .this shifting of the rows depend on data at which onbreak happens.

i am attatching the output of the csv file.

Suggest on this..

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
AttachmentSize
Sample.xls14.5 KB
Top
  • Login to post comments
  • 8311 reads
Mon, 02/09/2009 - 11:38am
#1
Lepa's picture
Lepa
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Can On-Break Logic be used in writing csv files in SQR ?

Of course you can but i'm not sure why your file is acting up. I have done it before using the following on the field i'm breaking on.

(0,0) On-Break Print=Never Before=procedure-to-call-before-break After=procedure-call-after-break

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
Tue, 02/10/2009 - 3:36am
#2
sweety's picture
sweety
User offline. Last seen 10 years 15 weeks ago. Offline
Joined: 01/16/2009
Posts: 15
Re: Can On-Break Logic be used in writing csv files in SQR ?

Yes i have tried and used at level 2 onbreak.its working.
The rows were getting shifted because i was using separate write statements at different onbreak procedures,
and same time closing the file.
but when i used only one write statement,and closed the file after the execution of all the procedures,i got the required output.

Top
Thu, 11/25/2010 - 6:21am
#3
Guest's picture
Guest (not verified)
Re: Can On-Break Logic be used in writing csv files in SQR ?

can any one tell how to use on-break with before and after procedure
in print line for saparated file

syntax is

print $field (0,100) on-break level=1 before=open-file after =end-file

when i run program with this syntax it shows "on-break with before and after can be used with in select"

but my situation is not possible in above condition means i am printing the field value in out side of select but i want be saparated file so

please let me know

Top
Tue, 06/21/2011 - 10:38am
#4
Guest's picture
Guest (not verified)
Re: Can On-Break Logic be used in writing csv files in SQR ?

I have done this successfully.... Use this syntax

BEGIN-SELECT
Column1
Column2 () ON-BREAK level=1 PRINT=NEVER BEFORE/AFTER=
Column2 () ON-BREAK level=2 PRINT=NEVER BEFORE/AFTER=
...
....

and so on
let me know if it works

Top
Sun, 10/30/2011 - 3:19am
#5
Guest's picture
Guest (not verified)
Re: Can On-Break Logic be used in writing csv files in SQR ?

Hi, if we use print command in sqr, will it cause any problems in csv file generated.For me,commas are missing for certain rows when i open csv, but pdf is working fine.I use on-break along with print command

Top