printer file "name" - problem

[Nancy Palmquist]

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