[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR output on same line
- Subject: [sqr-users] SQR output on same line
- From: "John Wills" <jwills@ccsf.edu>
- Date: Fri, 21 Jul 2006 08:44:36 -0700
- Delivery-date: Fri, 21 Jul 2006 11:59:40 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I have this code, and it works, except that the grades start a line below the
other information, whereas I want them in a column starting in the same line as
the other info. if I delete the +1 I get only one grade printed, on the same
line as the other information; if I then uncomment the on-break repeated grade
values do not appear. What am I doing wrong?
begin-select
spriden_last_name
spriden_first_name
spriden_mi
spriden_last_name || ', ' || spriden_first_name || ' ' || spriden_mi (,1,30)
on-break level = 1 print = change after = get-new-page
shrtckn_subj_code (,31,5) on-break level = 2 print = change skiplines = 1
shrtckn_crse_numb (,36,5) on-break level = 3 print = change skiplines = 1
shrtckg_grde_code_final (+1,45) !on-break level = 4 print = always skiplines = 1
FROM...
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users