|
Hi
I have the following problem. I am creating a job card for a client and they need to print blank lines ton the whole page even if there is only n few lines of available data
eq.
Product No, Description, qty
1234 product ABC 4
-----------------------------
5846 Product cde 6
-----------------------------
Then I need Blank lines printing to the end of the page
|
|
this is always a hard thing to do, as you need to have the empty dummy lines in your dataset.
The easiest solution is to handle the empty creation in a stored procedure...but not everyone can do that. How else might we get the empty data...
There is the concept of a numbers table where you join your data to a table of numbers so that the data repeats
Though the simplest is probably to play with the different values of lines, like to extend to the bottom of the section, and printing sections at the bottom of the page or here is another idea...make a image of the page with lines, add the picture to the report and then underlay the sections. Duplicate the data using a numbers table and then suppress duplicates. Make 1 field that can grow and have a formula that adds blank lines to the field so that it extends (suppress it from printing if not needed)
Hopefully, one of these ideas will prove feasible to you. As always, there are several ways to skin the cat.
|
IP Logged
