PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQR Multiple Reports Format Issue

edited Apr 16, 2015 4:45PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered ✓

HRMS 9.1, Tools 8.51

I have one SQR program where we need to run multiple audit type queries and produce reports.  No problem, I've written SQRs before that create multiple reports.  I have the DECLARE-LAOUT, DELARE-REPORT, USE-REPORT all in place.  The reports contain quite a bit of data and need to be landscape; ok, my previous ones were portrait, but should be no big deal (or so I thought)....

The first report comes out just fine.  The second report seems to be ignoring char-width.  The headers and data are all writing over each other.  Compared to the first report, the font is noticeably larger as well.  I tried just letting both use the DEFAULT layout from including setup32.sqc.  When that didn't work, I created my own layout, and used the same one for both reports.  When that didn't work, I gave each their own layout, and still the same result.  I even changed from

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center