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 centered accross all columns?
Chuck
.... 6 38262
"Chuck" <li*****@schoollink.net> wrote in message
news:6t********************************@4ax.com... 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 centered accross all
columns?
By default the width of your columns is made the same as the width of the
report sections in design view. You can however go into page setup,
uncheck this default, and then explicitly enter the width and spacing of
your columns. That will allow you to make the section width in design view
wide enough to enter two more sets of column header labels. It will take
some trial and error to get them lined up over your columns.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Chuck <li*****@schoollink.net> wrote in
news:0p********************************@4ax.com: On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt" <ri*********@hotmail.com> wrote:
"Chuck" <li*****@schoollink.net> wrote in message news:6t********************************@4ax.com. .. 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 centered accross all columns?
By default the width of your columns is made the same as the width of the report sections in design view. You can however go into page setup, uncheck this default, and then explicitly enter the width and spacing of your columns. That will allow you to make the section width in design view wide enough to enter two more sets of column header labels. It will take some trial and error to get them lined up over your columns.
If it makes any difference, the database is Access 97. I don't understand. In the report design everything is 7.5" wide. The text boxes in the Report Header, and Page Header span the full width of the page. The text boxes in the detail section are 2.5" wide, which leaves a lot of empty space to the right of the text boxes. The three columns are set in Page Setup. The column width is set to 2.5" and *Same as Detail* is not checked. Column layout is set to accross then down. Properties of the Group Header are New Row or Col: Before & After. A text box in the Group Header, which is between the Page Header and the Detail section, is set to 7" wide but the text is cut off at the right edge of the first column. I really don't want to start a new page for each group, but if that is what it'll take, I'll do it.
Chuck ...
Unfortunately, in my experience, group headers will be the width of
detail columns, no other option.
I have achieved the effect you seem to want (multiple column detail,
single column group) by putting the detail into a subreport instead.
On 10 Sep 2004 20:22:10 GMT, Ross Presser <rp******@NOSPAM.imtek.com.invalid>
wrote: Chuck <li*****@schoollink.net> wrote in news:0p********************************@4ax.com :
On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt" <ri*********@hotmail.com> wrote:
"Chuck" <li*****@schoollink.net> wrote in message news:6t********************************@4ax.com ... 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 centered accross all columns?
By default the width of your columns is made the same as the width of the report sections in design view. You can however go into page setup, uncheck this default, and then explicitly enter the width and spacing of your columns. That will allow you to make the section width in design view wide enough to enter two more sets of column header labels. It will take some trial and error to get them lined up over your columns.
If it makes any difference, the database is Access 97. I don't understand. In the report design everything is 7.5" wide. The text boxes in the Report Header, and Page Header span the full width of the page. The text boxes in the detail section are 2.5" wide, which leaves a lot of empty space to the right of the text boxes. The three columns are set in Page Setup. The column width is set to 2.5" and *Same as Detail* is not checked. Column layout is set to accross then down. Properties of the Group Header are New Row or Col: Before & After. A text box in the Group Header, which is between the Page Header and the Detail section, is set to 7" wide but the text is cut off at the right edge of the first column. I really don't want to start a new page for each group, but if that is what it'll take, I'll do it.
Chuck ...
Unfortunately, in my experience, group headers will be the width of detail columns, no other option.
I have achieved the effect you seem to want (multiple column detail, single column group) by putting the detail into a subreport instead.
I've come to the same conclusion, and the more I think about it, the more sence
it makes. Details in subreport, beautiful. Thank you very much.
Chuck
....
In message <t2********************************@4ax.com>, Chuck
<li*****@schoollink.net> writes Unfortunately, in my experience, group headers will be the width of detail columns, no other option.
I have achieved the effect you seem to want (multiple column detail, single column group) by putting the detail into a subreport instead.
I've come to the same conclusion, and the more I think about it, the more sence it makes. Details in subreport, beautiful. Thank you very much.
It's a neat workaround for a glaring mistake in the design of Access. It
shouldn't really be necessary.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
Chuck wrote: 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 centered accross all columns?
Chuck ...
I knew this looked familiar. It really is possible. I asked this
question a few years ago and was pointed to the following article: http://support.microsoft.com/default...NoWebContent=1
Rebecca
On Sun, 12 Sep 2004 04:43:12 GMT, Rebecca <Re*****@JaxonFamily.net> wrote: Chuck wrote: 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 centered accross all columns?
Chuck ...
I knew this looked familiar. It really is possible. I asked this question a few years ago and was pointed to the following article:
http://support.microsoft.com/default...NoWebContent=1
Rebecca
Thanks for the suggestion. It doesn't really address my particular problem.
However, the site also has a database with many examples of reports. The
example for printing odd or even page numbers is a cleaner solution than what
I've been using.
Chuck
.... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David Horowitz |
last post by:
Hi folks.
I need to create a report that has a Group Header that pulls certain data
from the Detail section. It's something like this:
+--Report----------------------------------------
|...
|
by: sri_san |
last post by:
Hello,
I have a datagrid in which the header needs to span over 2
columns. I have tried creating a tableCells and tableRow at runtime and
set the columnspan property of a cell to 2. But, the...
|
by: Olav Tollefsen |
last post by:
Is it possible to create a DataGrid footer to span multiple columns?
Olav
|
by: keithb |
last post by:
I'm just learning ASP.NET 2.0, so I apologize for asking a question which
probably has an obvious answer. The Standard toolbox in VS2K5 has a control
called Table. Placing the control on a web page...
|
by: lorirobn |
last post by:
Hi...
I think this is a really simple question, but I can't find the answer.
I have a subreport that has columns and column headings. The subreport
can span over several pages. The column...
|
by: rech340 |
last post by:
Hi, I created labels using the label wizard. I then added a group
header for a FN/LN field. I moved the following text box to the group
header:
=Trim( & ", " & )
Remaining in the detail...
|
by: zandiT |
last post by:
hello everyone
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report...
|
by: zandiT |
last post by:
hello everyone
when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report...
|
by: deames |
last post by:
I have an access report that combines project data with project planning considerations. It includes several sub reports and VBA coding on the on print function to print lines between the different...
|
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: 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:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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: 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,...
|
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: 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,...
|
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...
| |