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

[Matt Rogish <rogishmn@muohio.edu>]

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