[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: new-report creates extra .lis file



Have you thought of executing a new command process where you now know the
prior
reports so exclude them and allow this process to be recursive to end of
selection of firms.

??

Eva Kovari wrote:

>      I am writing a program that creates  a report for each firm in a
>      table.  The report names are dynamically generated based on the firm
>      numbers being read from the table.  The problem is that while all the
>      firm files are created properly, (ex. Progname.firm#.rpt) a .lis file
>      is also generated containing just the report heading.  My program
>      looks something like this:
>
>      Begin-Select
>
>      firm_number () on-break print=never before=firm_heading
>      :
>      :
>      from tablename
>      End-Select
>
>      Begin-Procedure firm_heading
>
>      !if the firm number changes, create a new file
>
>      let $report_name= 'Blabla.' || &firm_number || '.rpt'
>      new-report $report_name
>
>      ...print firm heading stuff
>
>      End-Procedure
>
>      Begin-Heading 3
>
>      ...print report title
>
>      End-Heading
>
>      I can't put a new-report before the select statement because I don't
>      know what firm numbers are in the table.  Does anyone have any
>      suggestions?
>
>      Thanks!
>
>      Eva