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

[Don Mellen <donm@ontko.com>]

Try using print=never and printing the "whole" heading section and
dropping the level=3 and 4 breaks.  Something like....

begin-select
event        (,) On-Break print=never Level=1 Before=event_heading
function     (,) On-Break print=never Level=2 Before=function_heading
f_start_date (,) On-Break print=never Level=2
...
task || ' ' || t_start_date || ' ' || t_end_date   (+1)
...


begin-function event_heading
   Print 'Event' (+1)
   Print &event  (+1)
   Position (+1)
end-function

begin-function function_heading
   Print 'Function'     (+1)
   Print &function      (+1)
   Print &f_start_date  (  , #date1_pos)
   Print &f_end_date    (  , #date2_pos)
   Position (+1)
   Print 'Task'         (+1)
end-function


(of course, you'll need your databases date to char function in the
select).  

HTH,
Don


On Thu, 2 Oct 2003, Matt Rogish wrote:

> 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
> 

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


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