Report Printing Each Record on Separate Page

Kenneth Brody kenbrody at spamcop.net
Mon Apr 9 14:43:19 PDT 2012


On 4/9/2012 4:46 PM, Stanley - stanlyn-com wrote:
> Hi,
>
>
>
> Using FilePro Sco Unix 5.0.14d4, I need the report (which was the option 1,
> Report) to print more than one record per page.

Unless you tell filePro otherwise, it will print as many records on a page 
as will fit.

> There is no sorted needed
> as they need to flow in natural/record # order.

So don't give filePro any sort information.

> I have tried using the @u4,
> @t4, @ub, and @cb fields separately

Except for @T4, all of those will *not* print in record number order. 
(Unless every record was updated on the same date, or last update [or 
created by] the same person.)

>  to create a sort on that with both an
> "x" and an "f" in an attempt to get more than one record per page.

The "f" will force a page break.

> I was
> thinking it had something to do with the sort and should be pretty straight
> forward, but I guess not.

You say you don't need to have it sorted, so don't.  Leave the sort 
information blank.

> I'm needing to print a report for a specific
> user on a specific day in the order they were created or updated.

In that case, you *do* need a specific sort order.  However, unless you have 
a field containing an incrementing value, there is no guarantee that all the 
records will come in the order you want.

And, what you you mean by the order they were "created or updated"?  If I 
create records A, B, and C, and then update B, what order do you want?

> This is
> somewhat like an audit of a users work.  I have everything working except it
> wants to print only a single record per page thereby wasting paper.

If you are only getting one record per page, then you have done something to 
tell filePro to do so.

What is the exact sort information you currently have?

Do you have any PAGE commands in processing?

-- 
Kenneth Brody


More information about the Filepro-list mailing list