RE: [sqr-users] Problem with Printing w/On-Break and Before/After

[Steve Cavill <steve.cavill@infoclarity.com.au>]

Matt,
i think you just have too many break fields, if two or more fields are
related, (e.g. your Function, Function_Start_Date, Function_End_Date, ),
just break on one of them.  so your code would read
begin-select
event        () On-Break Level=1 Before=event_heading
function     () On-Break Level=2 PRINT=NEVER Before=function_heading
f_start_date
f_end_date
...
task         (1,10) On-Break Level=3 Before=task_heading
t_start_date   (,+2)
...

Note that function, f_start_date  and f_end_date are NOT printed in the
select.  Instead you print then in the function_heading
e..g
begin-procedure function_heading
next-listing
print 'Function' (1,1)
print &Function  (2,10)
print &f_start_date (2,20)
print &f_end_date   (2,30)
next-listing
...

I recommend you use next-listing instead of position (), position can get
very confusing with line positioning.

HTH.
Regards, Steve

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Matt Rogish
Sent: Friday, 3 October 2003 7:32 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Problem with Printing w/On-Break and Before/After


All,

I have a result set like this:
(column names)
Event, Function, Function_Start_Date, Function_End_Date, Task,
Task_Start_Date, Task_End_date, Task_Complete_Date

I'm ordering by event, function, function_start_date, task, task_start_date

Example Rows:
Setup, AAI,       25-MAR-2002, 19-AUG-2002, Conduct Research on
Branding,  25-MAR-2002, 05-APR-2002, 25-MAR-2002
Setup, AAI,       25-MAR-2002, 19-AUG-2002, Prepare Presentation to Board,
25-MAR-2002, 12-APR-2002, 25-MAR-2002
Setup, AAI,       25-MAR-2002, 19-AUG-2002, Presentation to
Board,         12-APR-2002, 12-APR-2002, 12-APR-2002
Setup, Athl,      19-JUN-2002, 01-AUG-2002,,,,
.....
Setup, Launch,    22-NOV-2002, 22-NOV-2002, Launch web site, 01-JAN-2003,
01-JAN-2003, 01-JAN-2003


What I'd like to see in the output is:
--Event--
Setup

Function
   AAI      25-MAR-2002 19-AUG-2002

Tasks
    Conduct Research on Branding 25-MAR-2002 05-APR-2002
    Prepare Presentation to Board 25-MAR-2002 12-APR-2002
    Presentation to Board 12-APR-2002 12-APR-2002

Function
   Athl  ....
...
Function
   Launch ...

Tasks
   Launch web site

My printing logic looks something like this:
begin-select
event        (,) On-Break Level=1 Before=event_heading
function     (,) On-Break Level=2 Before=function_heading
f_start_date (,) On-Break Level=2
...
task         (,) On-Break Level=3 Before=task_heading
t_start_date (,) On-Break Level=4
...

And the event_heading function looks something like:
begin-function event-heading
         Print 'Event' (+1)
         Position (+1)
end-function

This one works fine.  The problem is with the function_heading and
task_heading functions (which look just like the event-heading function).

Obviously they end up firing every time and don't even work correctly.  Can
anyone provide some insight?


Thanks,

--
Matt Rogish - rogishmn@muohio.edu
Programmer
Advancement Services
Miami University
513.529.1420

Do not meddle in the affairs of SQR,
for it is subtle and quick to anger!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users