hi ya,
i have set up a database with a section to print reports as per the requirments of the project. the project is to manage environemental weed management across a wide area. As the area is so large it has been broken up into infestation zones with sites nested within.
My problem relates to the production of reports. I have produced reports that will accumulate all works conducted within an infestation zone and give back associated data such as money spent, chemicals, area treated, etc.
Unfortunately the report doesn't have all the info in it, some sites have just slipped past the radar despite being assocaited with an infestation zone.
I checked the association by looking at the tables and i can see that these sites are within the infestation zone.
Starting to pull out my hair in frustratuion.
Is there any well known problem with reports and access 2000?
A
3  1100  nico5038 3,080
Recognized Expert Specialist
Hard to tell from a distance, but the first thing that comes to mind is that you have missing data on the lowest level.
When there are no records for the detail level and you JOIN a main table with the subtable, then the missing rows will suppress the maintable rows.
Only a LEFT (or RIGHT) join will make them visible.
In the graphical query editor double click the connection line between your tables and chose option 2 or 3 making the required table "leading".
When still in trouble, posting the report's query might help.
Nic;o)
Hard to tell from a distance, but the first thing that comes to mind is that you have missing data on the lowest level.
When there are no records for the detail level and you JOIN a main table with the subtable, then the missing rows will suppress the maintable rows.
Only a LEFT (or RIGHT) join will make them visible.
In the graphical query editor double click the connection line between your tables and chose option 2 or 3 making the required table "leading".
When still in trouble, posting the report's query might help.
Nic;o)
Thanks Nic,
I have looked into the relationships and it doesn't seem to be the problem all sites are referenced with an infestation zone. you mentioned posting the code of the query. This may be the problem as my report isn't based on a query rather just a compliation of data across tables, some subreports are based on queries as they need area calculations.
Is it necessary to base a report on a query? another intersting delima is that other reports i have created based upon species or site or agency as opposed to the infestation zone, all work fine, i really don't know whats happening
NeoPa 32,568
Recognized Expert Moderator MVP
The report may be based on :
1 A table.
2 A QueryDef (Query)
3 Some SQL string.
Please post the following depending on above :
If 1, The layout of table giving field names and types.
If 2, The SQL of the QueryDef (found by designing query and switching to SQL view).
If 3, The SQL string itself.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Lane LiaBraaten |
last post by:
I am developing a GUI that uses multiple threading.Threads, and Queue.Queues
for communicating between the threads, and threading.Timers for checking the
queues.
Everything works well (runs to completion and exits) on my RedHat7.3 machine,
but it doesn't work (hangs like some thread or queue is blocking)on RH9.
However, when I ssh into the RH9 box from my RH7.3 box, the app runs fine(on
my RH7.3 screen).
Now the madness sets...
|
by: jez123456 |
last post by:
Hi
My users, use ms access for querying and reporting on a backend database,
however they need to replace ms access with a new reporting tool.
I’m thinking of developing my own reporting engine in C# to replace the
existing ms access model.
Are there any c# reporting application samples that I could look at to get
started?
|
by: Woody Splawn |
last post by:
I am asking this question here because I asked this question in the
Reporting Services Newsgroup and did not get an answer. Does anyone know if
Reporting Services is intended to work in a client/Server or Local machine
environment? Based on what I have seen my guess is yes but that is a guess.
In some materal it talks about it running on a web server but my supposition
is that this does not necessarily mean that it would not make for a...
|
by: rmk |
last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ?????
I have ASP.NET 1.1 and 2.0 installed on my laptop.
I have Visual Studio 2003 and 2005 installed on my laptop.
I have my default website configured for ASP.NET 2.0.
I have the developer edition of SQL Server 2000 installed on my laptop as
|
by: YellowFin Announcements |
last post by:
Whitepaper: "Yellowfin Reporting" enables Embedded Business
Intelligence
--------------------------------------------------------------------------------
Embedded reports are a standard requirement of most applications. But
users are increasingly demanding more sophisticated reporting from
applications - seeking such features as custom report design, ad hoc
report creation and analytics. Developers that want to embed business...
| | |
by: Kayvine |
last post by:
Hi guys, this is a question I have for an assignment, it is pretty long, but I am not asking for the code(well if someone wants to write I'll be really happy, lol), but I just want to know how to start it and what main topics in C I will need to cover in the assignment. Thanks a lot.
CSC180 Assignment #3: Menu Madness
Due Date: Thursday, November 8th at 1:00am
Contents:
· General Info
· What to Hand In
o Submission Instructions
|
by: =?Utf-8?B?SmFja2Rhdw==?= |
last post by:
Hi!
I just up-graded my "Dell Help & Support Center" and now every time I start
upthe Dell folder is open on the desk top.
How do I make it GO AWAY, lest madness overtake me.
Thanks!
--
DAW
|
by: raylopez99 |
last post by:
Took a look at all the fuss about "lambda expressions" from Jon
Skeet's excellent book "C# in Depth". Jon has an example, reproduced
below (excerpt) on lambda expressions.
My n00b take: it's like SQL and those 'high level' languages that try
to be too clever by half and pack a lot of syntax in as short a space
as possible. Like Egyptian hieroglyphics, like Chinese, like those
non-alphabet languages, it's just way too much information...
|
by: Pavel Minaev |
last post by:
On Aug 14, 1:37 pm, raylopez99 <raylope...@yahoo.comwrote:
You are, of course, entitled to your opinion, but lambdas are a part
of C# 3.0, and any C# developer has to know their ins and outs if only
to be able to maintain other people's code.
Also, every time I hear such sentiments - "generics/closures/type
inference/... are hard to understand and compromise
readability" (there were plenty of such as new major language features
were...
|
by: JTP PR |
last post by:
Business Intelligence software company, Yellowfin today announced its
successful foray into the Asia Pacific telecommunications sector
through its expanding partner network. Two organisations, InterAcct
Solutions and Utilibill have selected the Yellowfin web-based Business
Intelligence (BI) reporting application as the front end presentation
layer for their customer business reporting solutions throughout Asia
Pacific.
The Yellowfin BI...
|
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,...
| | |
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...
|
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...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
|
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...
| |
