473,804 Members | 3,549 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report Creation Problems

I need to create a report based on 4 tables
1. tbl_KidsList
2. tbl_Sub_Address
3. tbl_Sub_Phone
4. tbl_Sub_Parents

Tables 2-4 are actually subforms that are placed upon the KidsList
form.

The report will list the kids name, addresses, phone numbers, and
parents.

Questions
1. How do I add all the tables to the report so all the fields will
be listed in the fields list?

2. I guess I have to connect or join the tables via the client ID so
all of the data will be listed in one instance. How do I do that?
Nov 12 '05 #1
1 1242
You embed a separate Report in each Subreport control... and each Report
will have its own Field List. There won't be, and I am not sure how you'd
expect to use, a "consolidat ed" field list for the main report and all
subreports.

Larry Linson
Microsoft Access MVP
"Mark Lees" <ma*******@byu. edu> wrote in message
news:c4******** *************** ***@posting.goo gle.com...
I need to create a report based on 4 tables
1. tbl_KidsList
2. tbl_Sub_Address
3. tbl_Sub_Phone
4. tbl_Sub_Parents

Tables 2-4 are actually subforms that are placed upon the KidsList
form.

The report will list the kids name, addresses, phone numbers, and
parents.

Questions
1. How do I add all the tables to the report so all the fields will
be listed in the fields list?

2. I guess I have to connect or join the tables via the client ID so
all of the data will be listed in one instance. How do I do that?

Nov 12 '05 #2

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

Similar topics

1
2489
by: Sachin | last post by:
Hi, I am working on ASP.Net 2.0 Beta 2 I am having problems creating crystal report using dataset I created a new dataset (DS_ExpCode) and a datatable (DT_ExpCode) under App_Code folder. Then i create a new crystal report A Standard Report Creation Wizard window popus up with available datasource I selected Project Data -> ADO.Net Dataset, i see the dataset recently
0
1291
by: z.ghulam | last post by:
Hi, I'm creating a new databse and have a couple of problems I'd greatly appreciate any feedback on. 1) I have an order form and would like to set it, so that when the form is opened, the focus is set to my reference field and the find command is executed prompting the user for the reference he/she wants to find. I pasted the code from a Find command box i created, but cant work out how to use the setfocus when the form is opened to go...
6
2320
by: ldn95887 | last post by:
I have been using Lebans ReportToPDF code for a couple months without problems. We recently changed the format of the invoice and now the first line of the detail section of my report is missing 2 of the 9 fields. The rest of the report is fine. In looking at his website there is a version note on 2/21/06 indicating he fixed the "missing lines produced by the report line tool issue". I am wondering if this was the problem I am...
5
3741
by: jmar | last post by:
I posted a week ago and received one response. I'm looking for the opinion of several experienced .NET people before I proceed so I'm posting again. Sorry for the repost... I am updating a VB4.0 quote generation program to VB.net. The old program takes user inputs, performs calculations, saves the data to Access databases and uses Crystal Reports 5.0 to generate a quote. A while back users obviously wanted to be able to edit/e-mail ...
5
2599
by: Tim Marshall | last post by:
I'm thinking of using Stephen Lebans Report to PDF utility/dll in a Jet application I'm running (I want to be able email some reports with complex information and the conversion to html just doesn't do it very well). I'm wondering what effect or possible conflict there might be on a system, such as mine or a user's, that already have Adobe Acrobat Professional installed. I'm assuming there wouldn't be - that Stephen's procedures would...
3
1813
by: John | last post by:
In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with the wizzard. The report is based on a temp table that is created when the user pushes a button. After creation of the table the pushbutton opens the report. Now something weird happens. When I open the report manually a few or more times it remains intact. However, when I open the report from the form's pushbutton code for the first time, the report will open OK....
4
4237
by: lupo666 | last post by:
Hi everybody, this time I have three problems driving me nuts :-((( (1) I have a report with 20 or so Yes/No "squares". Is there a way to either hide/show the "square" or change the yes/no relative textbox, depending on value? (2)
2
2045
by: blackduck603 | last post by:
Hi, I am fairly new to Access programming and Reports. I have inherited a project and am trying to understand some of the inner workings. There is a field named Overall in the Detail section of my report. The Control source for this field is SumOfbalance (and no - I did NOT forget to capitalize the b in balance). After a good deal of digging, I managed to find a reference to this field in a query in the VB code associated with this report. A...
10
9126
by: Snoopy33 | last post by:
I have a DB that I developed on access XP (2002) and deployed over a year ago. No one has had problems printing any of the reports within the DB until we started loading 2007 on new computers. The access 2007 users cannot print one of the reports. This is maddening since I cannot duplicate the issue on any computer that runs 2003 or below. Is there something going on that I'm not seeing? Does anyone have any suggestions at all on...
0
9706
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
10580
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...
0
10335
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...
0
10082
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
9157
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...
0
6854
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
5525
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
4301
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
3
2993
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.