'Hi In SQR is it possible to do something like this- print 'Department: ' $department_name I was getting an error. So I had to have two print statements.

Isn't a simple concatenate allowed in print statement or am i doing something wrong? Item 1: 'So I had to have two print statements' While expressions are not allowed in print statements, your later example in Item 2 shows that you do not need 2 print statements.

You can use a 'let' statement that concates whatever you want to print, and then use a single print statement. Item 2: (SQR 1944) error The error is caused by you applying a date format on a string variable. SQR tries to auto-convert the string to a date before applying the edit mask, but it is not in an expected format. Instead, either use a date variable, or hand convert the string to a date first, similar to.

Print command in SQR. You can do a print command without specifying a column or row. PeopleSoft Fluid Page.

Let $Check_For_The_Month = DateToStr(StrToDate($Pay_DT_From_Conv,'MM/DD/YYYY'), 'MONTH-YYYY'). Thanks guys for your invaluable help. Gma 945 Modded Driver on this page. Laird, I will go with the resolution that you offered for both the issues.

Something more about Issue 2- I would like to print something like this - print 'Salary Slip for the month of - ' (+1,1) center point-size=10 font=4 and then I want to print 'JAN 2011' in the same line but in BOLD. The static part of what is going to be printed is not in BOLD. The CENTER command takes care of the column part but for the JAN 2011 part, how do I know which column to print. Thanks again. After you have printed something, SQR knows what the current column and row is. Thus, after you do your printing using the CENTER command, you can do a print command without specifying a column or row, but specifying an increment.

For example: print 'Beer' (+1, 1) CENTER BOLD print 'is bubbly' (, +2) The above would print 'is bubbly' two print positions after the 'current' column - where ever that may be - and on the same line because we have not specified a row number OR increment. Read the SQR reference and look at some delivered SQRs for examples. But 'Beer' will be centered, and 'is bubbly' will hang off to the right (the entire sentence will not be centered).