I am in a conundrum and I am not sure how to do what I want to do.
In short in a report I want either a) everything in one long line or b) only the detail section to be columnar
More detail on the problem...
In a report, I would like the following to occur:
In one line:
Name1, Address1, EventAM, EventPM
Name2, Address2, EventAM, EventPM
The EventAM and EventPM fields are new entries in a table:
A condensed version of the table looks like... Name | Event# | When
Jacki | Event1 | Morning
Jacki | Event2 | Afternoon
Susan| Event1 | Morning
Susan| Event2 | Afternoon
Now, all I've been able to print in a report is:
where name header is bold, detail is not. Jacki
Event1, Morning
Event2, Afternoon Susan
Event1, Morning
Event2, Afternoon
Even this columnar formatting would be acceptable: Jacki
Event1, Morning Event2, Afternoon Susan
Event1, Morning Event2, Afternoon
But if I have to do it this way I don't want is for the whole page to be columnar. Just the detail.
Is this even possible? Is my desired output possible?
3 2450
Sorry, but it's really not clear what you want to ask.
There really does not need to be any relationship between the heading distribution of data and the detail. You can have ... Name Address 1 Address 2 City State Zip
like that in the heading and
Event 1 AM/PM
Event 2 AM/PM
Event 3 AM/PM
......
in the detail.
I wonder if the problem is that you are letting the report wizard do too much for you? Let the wizard do its thing and then go in to the report in design mode and start moving things around as you like.
If you're still stuck, ask again with a little more detail.
Jim
I think you've basically answered my question...
There really does not need to be any relationship between the heading distribution of data and the detail. You can have ... Name Address 1 Address 2 City State Zip
Event 1 AM/PM
Event 2 AM/PM
Event 3 AM/PM
......
... But what I was getting at was can I columnize the detail part, but not the whole page? Name Address 1 City State Zip
Event 1 AM/PM Event 2 AM/PM
Event 3 AM/PM ......
..... Name2 Address 2 Address 2 City State Zip
Event 1 AM/PM Event 2 AM/PM
Event 3 AM/PM ......
.....
Sorry for the confusion.
Ah, I think I see what you might find very helpful to know. If you tell Access that you want to sort by various fields, you can also tell Access that you want, optionally, a header and, optionally, a footer, for each thing you sort by.
Each sort field can have it's own set of header/detail/footer, and detail is the only required part.
When I figured that out, I was able to do much more interesting reports.
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics
by: JW |
last post by:
The problem of hiding / showing a sub reports on No Data is often asked, my
problem here is a little different.
My Main report has, as a page header, company details (so each company to a
new...
|
by: James Fortune |
last post by:
Flexible Reports
I only did this because a client required this functionality. No
guarantees or rights are implied by the code shown here. It is
provided mostly for those with extra time on...
|
by: Peter Bailey |
last post by:
I have a report that gives the classroom and then a list of students in it
for a particular week.
Thats fine if I want just one column with its associated rows of students.
I have been asked...
|
by: Chuck |
last post by:
I have a report with three columns, accross then down, and two groups.
Currently the group headers are only one column wide and appear in the left
hand column. How can I make the group header be...
|
by: DS |
last post by:
Where do you add a Sub-Report? To the detail Section?
Thanks
DS
|
by: Lumpierbritches |
last post by:
Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the...
|
by: Robert Schuldenfrei |
last post by:
Dear NG,
I have done all I can do with Crystal Reports (CR) using the "pull" mode. I
now need to generate data in my application, load a DataSet with that data,
and "push" this on to a CR...
|
by: touf |
last post by:
Hi,
I've a problem in a crystal reports report, the detail information is
displayed 2 times. I'm sure that the dataset contains the true information
because I see it in a datagrid so the problem...
|
by: Brad |
last post by:
This is the next step of a bigger project that I am working on and I have
hit a wall.
All forms that I have created for this project are working fine. This is
the one that I have a problem...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
| |