473,836 Members | 1,956 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

adding empty rows to the end of a report

I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes to
complete the column?
Nov 13 '05 #1
3 3727
You could make all the borders transparent on the the boxes on the form.

Now, to get dotted borders, you could use dotted horizontal and vertical
lines.

This will give you a nice grid of dotted lines, whether or not there is any
data.

David

"grlgeek" <no@noway.com > wrote in message
news:P7******** ************@co mcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup with columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it across an entire page.

Is there a way to get the report to fill in the "x" number rows it takes to complete the column?

Nov 13 '05 #2
Create a duplicate table of the one you get your data from. Add some blank
records. Create a union query of your data table and this table so that the
blank records appear at the end of the results. Base your report on the
union query. The blank records at the end of the recordset will cause the
dotted lines to be printed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"grlgeek" <no@noway.com > wrote in message
news:P7******** ************@co mcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around
them so the receptionist can easily cut them out. The report is setup
with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3
or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it
across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes
to
complete the column?

Nov 13 '05 #3
DUH - thanks...
"PC Datasheet" <no****@nospam. spam> wrote in message
news:QT******** *********@newsr ead2.news.atl.e arthlink.net...
Create a duplicate table of the one you get your data from. Add some blank
records. Create a union query of your data table and this table so that the blank records appear at the end of the results. Base your report on the
union query. The blank records at the end of the recordset will cause the
dotted lines to be printed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"grlgeek" <no@noway.com > wrote in message
news:P7******** ************@co mcast.com...
I have a report for creating the switchboard labels for our phone system
receptionist switchboard. The template has 12 records per column.

I setup a report that will create the labels and put a dotted line around them so the receptionist can easily cut them out. The report is setup
with
columns so that 6 columns fit across a page. 12 records per column, 6
columns across a page, each record has a dotted line around the box.

The problem comes at the end of the report when the last column only has 3 or 4 records in it, therefore it only prints part of a column.

Trying to use the report footer doesn't work, as that wants to put it
across
an entire page.

Is there a way to get the report to fill in the "x" number rows it takes
to
complete the column?


Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2166
by: terragrub | last post by:
I found some code that works great to creat empty rows of boxes on a report from the end of the data to the bottom of the report. Now, I can't seem to find the original message to post a question on that thread. The code is as follows. In the Report OnFormat section the I use the following. Private Sub Report_Page()
0
272
by: news.microsoft.com | last post by:
Hi, I am having trouble adding new rows to an empty MS Access table. I manually created the table in MS access named server and created two columns Date & Time. When I run the following code I get: "Syntax error in INSERT INTO statement". Any help would be great. Thank you.
3
4649
by: Baren | last post by:
Hi! I am developing a web project using ASP.NET and VB.NET as code behind. In one page the user attaches files to the list. The same data is shown in the and the max records visible is 4. Now the problem is I need to show 4 empty rows in the datagrid before binding the datagrid to the datasource. Can anyone help in this regard. Thanks in advance,
1
3429
by: lgalumbres | last post by:
Hi, I have a datagrid on Winform that is bound to a datatable. In essence, what I would like to do is that when a user inputs a number into a textbox control for example 5 then 5 empty rows will appear in the datagrid. any ideas? Im fairly new to vb.net and Ive been reading that manipulating a bound
2
4612
by: mdfayazi | last post by:
I am using dataadapter to Add,Update,Delete rows in a datagridview.Update and delete are working but while adding a rows the problem comes.When I add more than one row only first row values are copied all other rows. Can anybody help me what to do. Dim myBuilder As SqlCommandBuilder = New SqlCommandBuilder(adapterGetBudget) Dim dtdate As Date = Date.Now Dim cmd As New SqlCommand() With cmd .CommandType = CommandType.StoredProcedure
1
4359
by: adarshmuneshwar | last post by:
How To Add Empty Rows In Grid View Control In Asp.net 2.0
4
20393
by: sudhaMurugesan | last post by:
Hi all, I am importing data from excel sheet. i get the data in a datatable. when there are empty rows in excel i am getting empty rows in datatable also. how to remove empty rows? help me please. Thanks & Regards
5
4911
by: ramab | last post by:
hi guys, I can't figure out how to solve this problem. I have got 3 tab pages containing 3 datasheets based only 1 table. i have 3 primary keys in the table.Two primary keys are found in the 3 datasheets. My last primary key has an auto generated number. when i enter data in the 1st datasheet, for e.g when i filled in the first two rows, and then afterwards i filled my next datasheet, i will need to enter data on the third row. the first two...
2
17206
code green
by: code green | last post by:
I am trying to skip empty rows in a csv file The manual states But none of these tests seem to work. Anybody know why while(($data = fgetcsv($this->handle)) !== false) { if(!is_null($data)) #no if(!empty($data)) #no if(!empty($data)) #no { And variations thereof
0
9818
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10844
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10590
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9374
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7791
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6979
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5649
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4449
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4016
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.