printer file "name" - problem

[Dennis Malen]

Nancy,

I agree with your observation of how it is suppose to work. The problem is, 
it is not working that way and I can't figure out why.

Dennis
----- Original Message ----- 
From: "Nancy Palmquist" <nlp at vss3.com>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Monday, March 14, 2005 5:14 PM
Subject: Re: printer file "name" - problem


> Dennis Malen wrote:
>
>> It does work fine, but I have to take out the definition of the printer 
>> and I have to change the size of the page from 64 lines to one line.
>>
>> If the report comes out properly when the size of the page is 64 lines 
>> then why not when its dropped to a file.
>>
>
> Dennis,
>
> FilePro generates reports by sending a line followed by a New Line. 
> (varies by OS but that gets us to the next line)
>
> If you create a 66 line report, filePro will send enough lines to add up 
> to 66 before it generates a new header.
>
> If you remove all header lines from the report, and just have data lines, 
> it will make a report that will send each data line followed by a newline 
> for the entire report.  At the end, it will add enough newlines to make a 
> 66 line page.
>
> If you make the page length 1 line, it will not be necessary to add any 
> extra linefeeds to fill up a page at the end.  You will get the same 
> report.
>
> If you are sending the heading to provide the CVS heading or the columns, 
> you can do that by sending the first record twice.  Once with the headings 
> and once with the data.
>
> then: dim fields(20):1
> then: dim dummy(20):da
> IF: @rs eq "1"
> then: gosub heads
> then: xx="1"
> loop      if:  xx le "20"
> then: dummy(xx)=fields(xx);xx=xx+"1";goto loop
> ' the above would not be necessary if you could alias 1:da directly 
> somehow.
>
>
> THEN: print;end
> heads
> then: da="FirstName";db="LastName"; etc.
> then: print;return
>
> --------------------
>
> Now just put da for 1, db for 2, dc for 3, etc.
>
> Using the report format for generating a csv file does require some 
> adjustments or you will certainly get more new lines than you need.  But 
> this is exactly the correct behavior for filepro, how else would it print 
> the pages correctly?
>
> Nancy
>
> -- 
> Nancy Palmquist MOS & filePro Training Available
> Virtual Software Systems Web Based Training and Consulting PHONE: (412) 
> 835-9417    Web site:  http://www.vss3.com
>
>
>
>