Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

BandPerRecord and columns

edited October 2001 in General
Hi,

I'm using 5.56 and I have a report that is printing W2's. When I try to
print 4 on a page it does not work. I am using Colums=2 and DetailBand
height=4 inch. I have the PrintHeight set to phStatic and the tranversal
mode set to LeftToRight and the BandPerRecord set to 4.

It prints 2 records on the first page and then 4 on the next, etc.

It seems to be the combination of the Columns and the BandPerRecord. When I
set BandPerRecord to 1, the first page has 4 (but I need 4 copies).

Any Suggestions?

Joseph Gordon

Comments

  • edited October 2001
    BandsPerRecord isn't supported when ColumnTraversal is set to LeftToRight.
    The report engine was originally designed to only support a TopToBottom
    traversal, and there were certain assumptions built into the current report
    engine that won't allow the BandsPerRecord to work with the LeftToRight
    traversal. You will have to configure the dataset to so that the is one
    record for every W2 that you would like to print.

    You may be able to use a JITPipeline where you can create the BandsPerRecord
    'look and feel' because you can control when to move to the next record.
    Let the JITPipeline read data from the query. Set the JITPipeline's
    Recordcount property to be 4 * your query's record count. Then use a
    counter variable in your OnGetFieldValue event of the JITPipeline which
    would let you return the same record 4 times in a row, before returning the
    next record from the query.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.