473,623 Members | 2,790 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Forms with Group Headers

7 New Member
I would like to create a subform that acts like a report. Ideally, the subform would display continuous records but would have a group header. Using an example of types of companies-it would look like this:

Manufacturing
. . .3M
. . .Pepsico
. . .Cummings
Service
. . .Capital Accounting
. . .Sam's Delivery
. . .Typing Unlimited

Each record is coded with the type of company (i.e., Manufacturing, Service, etc.)

This is no problem with a report but I can't seem to find an elegant way to put this in a subform.

Any ideas?
Jul 30 '07 #1
1 1337
hjozinovic
167 New Member
Hi M.

Looks like report that should have a subreport on it.
Report should show type of companies, and a subreport should show Companies for each Type of company.
Subreport should be linked with the Main Report, and shuld be placed in Detail section of the Main Report just below the type of company control.

Here you have attached Test database (Last post) that does what you need:
http://www.thescripts.com/forum/thread724506.html

Hope it helps...
h.
Dec 11 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3288
by: Chris Dunaway | last post by:
A quick scan of the group did not immediately reveal an answer to my questions so here goes. First let me describe my app and then I'll ask the questions. I am writing a Windows Forms App (not Web Forms) that serves as a thin client to some web services. In other words, the Windows Forms app will be installed on the client machines and that app will call web services that are deployed on my server.
2
2981
by: Vincent Poinot | last post by:
I'd like to implement some sort of search function on my site, so I took Google sample code and tried it, i.e. basically: <form method="GET" action="http://www.google.com/search"> <input type="hidden" name="as_sitesearch" value="www.relinquiere.com"> <input type="text" name="q" size="15" value=""> <input type="image" id="submit" value="" src="..." ...> </form> It works fine, most of the time: if I type in accented characters, they
3
1917
by: John M | last post by:
Hi, I must be missing something blindingly obvious. If I don't want a page header to appear on a report header I set 'Not with Rpt Hdr/Ftr' in the report. But I don't want the Page Header where I have a group header. Wher can I set this?? I'm sure I'll be embarassed by a simple answer ... but I can't find it.
6
38286
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 centered accross all columns? Chuck ....
1
2420
by: lmawler | last post by:
Hi, I am trying to make a report which groups together parents and their children. I have three levels. I currently have three group headings and one detail section. I have some fields that are specific to the children that I have in details, and I have some fields which span all of the entries (regardless of parent or child)... My problem is that if I put these fields which span entries into details, there's a big space. If I put them...
1
1016
gchq
by: gchq | last post by:
Hi there Attempting to populate a dynamic table with data - that in itself is not a problem, but getting group headers IS giving me a headache. Know I've done this before, but can I remember how? Data is brought in using odbcDataReader then read between 'while' and 'end while' statements into dynamic rows. The group headers (Category) are held in the same database table Platform is VB.Net
5
2054
by: Cheb | last post by:
I am writing a simple 'contact us' email form and I am aware I should protect it from code injection and malicious email hijacks. I have used mysql_escape_string() to remove any newlines in the headers but do I need to protect the message body too? Should I include MIME content headers too? And should I be worried about HTML inclusion in the body? Thanks Chris R.
8
6064
by: inpuarg | last post by:
I 'm developing a c# (.net 2.0) windows forms application and in this application i want to connect to a java servlet page (HTTPS) (which is servlet 2.4 and which may be using Web Based SSO Sun Java System Access Manager but i 'm not sure), handle session management, get token, send data using post and get methods etc. I listened http traffic using Fiddler and sending the same messages from my application but browser based navigation is...
1
2732
by: J360 | last post by:
In Access 2003, I'm creating a dynamic report and am trying to place text boxes into group headers. One report will have 6 group levels. I can place controls in the first two group headers easily by using the acGroupLevel1/2Header option. How do I place in the other group headers? acGroupLevel3Header doesn't appear to exist and manually typing it doesn't seem to work.
0
8224
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
8163
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8610
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8324
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
8469
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5561
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
4070
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
2597
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
1471
bsmnconsultancy
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.