I need some assistance. I am creating a database in Access 2003 to track personal biographical information for employees. I have completed the input portion of the database (forms, etc.), but now I need to be able to generate a personal biographical data report for each employee. This report will probably be 3 to 4 printed pages per person. The problem I am running into is that the detail section in the report design view is not large enough to be able to handle all of the fields. (There are approximately 75-85 fields that need to be included in this report, some of which are large "Comment" type fields.)
Is there something I am missing here? How do I generate a report like this?
Thanks in advance for any suggestions you can give.
2 2045
There are a few ways really, and as you work through the reporting features of Access, you'll find that they aren't the best, but using them is fairly easy.
The first thing you should do is to start thinking vertically instead of laterally.
Reports are based on Groupings. For records such as personnel records, you could create maybe 5 or 6 separate groupings of your data. Each grouping would have its own Group heading, and details that go under it.
In this way, you can stack your data vs trying to display all of the columns along just one line.
Try working with a simpler recordset and begin by using the report wizard that Access supplies. Once you've built that simple report, go into it in design view and check out how Access itself has broken the data into groups.
Questions like this one are very hard to answer by the way. Everyone learns their own methods and report design ideas. It often works out that your employer already has an idea about what they want the report to look like. If not, then you have the freedom to be creative.
Remember, reports are made to be "Pretty". You can employ charts and graphs and pictures into them. So if the old saying holds true for you...a picture may speak 1000 words. Just take that into account.
Another option you may consider, if the data is more of a facts list. Export it to Excel. It may save you time in the long run.
Good luck!
J
There are a few ways really, and as you work through the reporting features of Access, you'll find that they aren't the best, but using them is fairly easy.
The first thing you should do is to start thinking vertically instead of laterally.
Reports are based on Groupings. For records such as personnel records, you could create maybe 5 or 6 separate groupings of your data. Each grouping would have its own Group heading, and details that go under it.
In this way, you can stack your data vs trying to display all of the columns along just one line.
Try working with a simpler recordset and begin by using the report wizard that Access supplies. Once you've built that simple report, go into it in design view and check out how Access itself has broken the data into groups.
Questions like this one are very hard to answer by the way. Everyone learns their own methods and report design ideas. It often works out that your employer already has an idea about what they want the report to look like. If not, then you have the freedom to be creative.
Remember, reports are made to be "Pretty". You can employ charts and graphs and pictures into them. So if the old saying holds true for you...a picture may speak 1000 words. Just take that into account.
Another option you may consider, if the data is more of a facts list. Export it to Excel. It may save you time in the long run.
Good luck!
J
Thanks for responding! I've already mentally grouped the report. The problem I'm running into is that I can only increase the height of the Details section in the Design View to 22 inches. This is not long enough for me to put in all the fields I need to include on the report. Is there a way around this?
Also, there are some places where I am using a list box to display records from a related table. For instance, one of these list boxes lists all of the phone numbers/fax numbers for the employee. Right now, the list box is big enough to display up to 3 numbers. However, there is no "Can Grow" property for a list box, so if the employee has more than 3 numbers, the report, as it is right now, will not be able to display the additional numbers. Is there a better way to do this than a list box?
Thanks for your help!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: marwa mohamed |
last post by:
salamo alikom hi all
when i run report that includes image control linked to a field in the
table that contains the image path(on the server)and the record source
of the report contains over 30...
|
by: Grant |
last post by:
Hi
Is there a way to recover deleted records from a table. A mass deletion has
occurred and Access has been closed since it happened
Louis
|
by: longtim |
last post by:
I have been having endless difficulty creating reports/queries that
set any relevent parameters from controls in forms.
I am creating an application under access 2003 but will target access...
|
by: Melissa |
last post by:
Does anyone have a generic procedure for adding blank lines to reports like
Sales details, PO details and/or Orders details. The procedure would need to
count the number of line items, determine...
|
by: Mike Turco |
last post by:
What is the difference between creating relationships in the front-end vs.
the back-end database? I was trying to create a relationship in a database
front-end and noticed that I could not check...
| |
by: rreitsma |
last post by:
I want to create a form that will allow the user to select from a list of
available reports and based on a filter limit the records displayed in the
report. I have figured out how to access the...
|
by: Julian |
last post by:
Hi,
I am a very beginner in databases. I created a database table in Access 2003
and OOo 2.03 that includes name, address, postcode, phone numbers etc of our
customers. I would like to sort...
|
by: Swans, What Swans? |
last post by:
In one of my tables, in addition to a text field that is a Description
field, there are two fields for color formatting the data in reports.
They are Longs and hold the foreground and background...
|
by: google |
last post by:
I am trying to automate the way reports are printed in an Access 2003
database - I have ~200 records (people) who require between 5 and 10
customized reports (depending on values within certain...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |