Printing a ticket what Height should I use in page size?

[chispavip]

I'm using report viewer and a local report to print some tickets, the problem is that I don't know what size the ticket is going to be.

If I put a large fixed size, all tickets are large, even with a small amount of data.

I' using an Epson TM 950 printer.


How can I set my report to be Height fit dinamically?

 

[chiph]

Your report height will be fixed header info height + variable number of data lines + fixed footer info height.

The trick is knowing how many data lines you'll be showing. So you'll need to run two queries -- one to count the number of rows (and then set the height), and another to actually bring back the rows.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first