473,796 Members | 2,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need help with Crystal Reports

Hi all,

Excuse the ignorance, but I'm like a blind man trying to navigate a
maze here...

I have two access tables called "material" and "job". I need to make a
report that lists all materials in the "material" table whose quantity
has fallen below a certain point. I also need to note if that material
is needed to complete a current order (hence the "Job" table). All I
have to do to note this is display a Job #.

The problem is that any given material may, or may not have a
corresponding record in the "Job" table. If the material is not in the
"Job" table I want to display a blank where the Job # would otherwise
be displayed. As it stands right now, as soon as I include the Job #
from the "Job" table the report ignores all records that do not have a
match in both databases.

Any help would be greatly appreciated.

Matthew

Nov 13 '05 #1
2 1256

ma*****@bozeman ds.com wrote:
Hi all,

Excuse the ignorance, but I'm like a blind man trying to navigate a
maze here...

I have two access tables called "material" and "job". I need to make a report that lists all materials in the "material" table whose quantity has fallen below a certain point. I also need to note if that material is needed to complete a current order (hence the "Job" table). All I
have to do to note this is display a Job #.

The problem is that any given material may, or may not have a
corresponding record in the "Job" table. If the material is not in the "Job" table I want to display a blank where the Job # would otherwise
be displayed. As it stands right now, as soon as I include the Job #
from the "Job" table the report ignores all records that do not have a match in both databases.


You need to do an outer join on the Job table. If there are no
matching Job Numbers, the column will be NULL. You may need to deal
with this gracefully in Crystal Reports, but as Access has a vastly
superior reporting subsystem, an Aston Martin to Crystal Reports' Ford
Pinto, we don't generally concern ourselves much with CR.

Good luck.

Edward

Nov 13 '05 #2
Thanks. I'll give that a try.

Nov 13 '05 #3

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

Similar topics

13
15181
by: kristoff plasun | last post by:
I have a problem with a C++ DCOM application that prints Crystal Reports with data from Oracle. The SQL query is relatively complex but when the report is printed from the Crystal Reports designer it shows up very fast. When the report is printed from my application it takes about ten times as long to get the report to appear. When printing straight from the Crystal Reports
4
2286
by: Wendy Elizabeth | last post by:
I would like to know how to print a crystal report that was generated in the ..NET framework using a Visual Basic.NET web application and/or a Visual basic.NET windows application. When crystal reports runs by itself, you can do a print preview to see what the report will look like. I would like to know how to do this using crystal reports that is embedded in the Visual Studio.net 1.1 professional and enterprise architect versions. ...
1
1104
by: Gidi | last post by:
Hi, I have some tables which represent reports the user asked for, and i want to give him the ability to print them (with a printer), till now i painted the tables by my self and draw the results into it. but i understand that with crystal reports it will be better and much more easier. where can i learn about working with crystal reports and Sql Database?
3
2349
by: Vince Mele | last post by:
We are having a small problem with a couple of reports we developed for a client website. On two of the reports, sometimes (most of the time) we receive a warning message before the output of the report is presented in the browser. The warning message says "This page contains both secure and non-secure items. Do you want to display the non-secure items Yes, No, Cancel)". The site was developed using ASP.NET, VB.NET, and Crystal Reports...
2
3566
by: fig000 | last post by:
Hi everyone, I recently wrote a vb.net app which includes some crystal reports. The user has very little money in their budget and have been without a working application for quite a while. This being the case I worked with what was available: I used vb.net and crystal 8.5. The crystal reports are being viewed in the crystal report viewer which is still included in vb.net. I went ahead with developing this project because I found that...
1
4318
by: Lyners | last post by:
Hello all, I have created an ASP.NET website that uses Crystal Reports that works on the localhost (my PC), but when I copy it to the server it does not. The problem is ExcelUseConstantColumnWidth = False. On my PC when exporting a report, it works - columns are varible width to fit the field, from the server it does not - I get constant width columns. I suspect it is a DLL issue, but so far all my comparisons are coming out the same.
2
8990
by: =?Utf-8?B?UGF1bA==?= | last post by:
Hi I am running .net framwork 2.0 on a server and after installing a web ap that has crystal reports in it there is an error, cant find crystal report dlls that are in the web.config file. Just wondering is there a crystal report installation that needs to be done on the server? vs.net is not installed on the server, just the framework. thanks. -- Paul G Software engineer.
11
2910
by: NewGuytoNetworking | last post by:
I have an XML that my company sends out daily it used to be created by SQL but I now have to use crystal reports and I can't seem to get it to line up the same. Please help with any references or how to rewrite my schema. I will try to provide pictures of what currently have. (This is Mine from Crystal Reports) <?xml version="1.0" encoding="UTF-8" ?> - <BSASStockStatus xmlns="urn:crystal-reports:schemas"...
1
2313
by: appandairajc | last post by:
Hi Friends, I have a problem in Crystal Reports. I have a web application and it was published in machine. I am running that application through a virtual path. All the pages are working fine, but some pages which contains CrystalReportViewer are not working and i got an Exception which is given below. "An error has occurred while attempting to load the Crystal Reports runtime. Either the Crystal Reports registry key...
0
1353
by: akshaycjoshi | last post by:
Most of you people are already familier with the working of crystal reports unlike me.I am working on an application when I have no other option but to use CR. It is very diff. for me to read an entire book on CR for a simple report, so I thought if you people can help me :) Here is the table structure. http://img26.imageshack.us/img26/295/crystalpz9.png I opened the crystal reports in VS 2005 and added the crystal report and using the...
0
9680
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...
1
10173
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
10006
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
9052
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...
1
7547
isladogs
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6788
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
5441
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
4116
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
2925
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.