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 ?

  • Post reply
2 replies [Last post]
Mon, 02/09/2009 - 12:55am
sweety's picture
sweety
User offline. Last seen 7 weeks 2 days ago. Offline
Joined: 01/16/2009
Posts: 11

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:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
AttachmentSize
Sample.xls14.5 KB

Top
Mon, 02/09/2009 - 11:38am
#1
Lepa's picture
Lepa
User offline. Last seen 1 day 12 hours ago. Offline
Joined: 06/23/2008
Posts: 464
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
  • reply
Tue, 02/10/2009 - 3:36am
#2
sweety's picture
sweety
User offline. Last seen 7 weeks 2 days ago. Offline
Joined: 01/16/2009
Posts: 11
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
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
5 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.