I have two tables.
The ITEM RECD table containing the fields -- recd_invoice_ no,
invoice_date,pa rt_no,qty.
The ITEM ISSUE table containing fields- issue_no, date, part_no,qty.
The two tables are related by the part_no field.
How do I print a stock book type report for each item individually
with all the recd item details on left side and the issued item
details on the right side? All the recd & issue details for all dates
need to be there in the report.
The problem is further illustrated below :
ITEM RECD Table:
INV NO INV DATE PART NO QTY RECD
0278 12/04/07 542T765 4
0279 13/04/07 543T786 5
0290 16/04/07 542T765 2
ITEM ISSUED Table:
ISSUE NO ISSUE DATE PART NO QTY ISSD
212 13/04/07 542T765 3
The report FOR PART NO 542T765 will be like :
INV NO DATE QTYRECD ISSUENO ISSUEDATE QTY BALANCE
0278 12/04/07 4 Blank Blank Blank 4
Blank Blank Blank 212 13/04/07 3 1
0290 16/04/07 2 Blank Blank Blank 3
0  1131  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John Evans |
last post by:
Hello folks.
I have designed a system in C++ 6.0 which manages sales and stock for my
company. Output from the system is in the form of .csv files. The user
needs to be able to print these .csv files (between 1 and 10 copies,
depending).
My problem is that I do not want the user to actually see the .csv file. So
I need the user to print documents directly from C++. I have tried using
the TPrintDialog, and using the...
|
by: ramesh |
last post by:
In my above mail i forgot to add Stock Trace info.
below is the Stock Trace info. Can anybody knows about
this problem.
Stock Trace
Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode,
String str) +74
Microsoft.Win32.RegistryKey.SetValue(String name,
Object value) +1610
|
by: VMI |
last post by:
I have a BMP image (the form is also in PDF) that contains a scanned copy of
a paper form that we need to fill out. Is it possible to use this image in
my application so that the application can print out the form and the data
that the user entered? For example, the user loads the application and a
normal Windows Form asks for the user's name. When the user enters the name
and clicks on the "Print" button, I'd like to print the form in the...
|
by: Tinus |
last post by:
Hello all,
Because you have been so helpfull the last couple of times, I thought after
testing and wasting more than 20 pages (and google-ling for 3 days :-( ). I
would ask you again for your help.
The problem is this:
If I print a rectangle which begins at (0,0) and the margins are also set to
0 (l:0, t:0, r:0, b:0) then it prints fine (ok, not quite because 0,0 is
inside the none printable area but I corrected for that by checking...
|
by: Nigel |
last post by:
I successfully create a .NET Component (Visual Basic .NET) that would
print, unfortunately when used within a web browser it appears that .NET
security doesn't allow you to run code that interacts with the file system
(including printing) from the web browser. How do I disabled this so I can
get my windows form control to work within IE?
Also, do any have any printing code or know how I can implement multipage
printing using the...
| | |
by: Nigel |
last post by:
The Visual Basic .NET Step by Step book has the following code and text:
Imports System.Drawing.Printing
Private Sub PrintText(ByVal sender As Object, ByVal ev As
PrintPageEventArgs)
ev.Graphics.DrawString(TextBox1.Text, New Font("Arial", 11,
FontStyle.Regular), Brushes.Black, 120, 120)
ev.HasMorePages = False
End Sub
|
by: hamil |
last post by:
I am trying to print a graphic file (tif) and also use the PrintPreview
control, the PageSetup control, and the Print dialog control. The code
attached is a concatination of two examples taken out of a Microsoft book,
"Visual Basic,Net Step by Step" in Chapter 18.
All but the bottom two subroutines will open a text file, and then allow me
to use the above controls, example 1. The bottom two subroutines will print
a graphic file, example...
|
by: Lorn |
last post by:
I'm going to be attempting my most challenging programming task to date
and was wondering if I could get some input on what would be the most
efficient way of working with stock price quote data for an entire
order book. I'm working with a raw text data stream that delivers
quotes in realtime for each price level with the quantity of shares,
the ID of the exchange that is honoring the quote, and the side of the
market it is on. For...
|
by: jodi |
last post by:
Hi, I am really newbie in Java
I need to build an applet that prints a text, but, it can not roll the page
I mean, when I print like
"TEST ONE
TEST TWOO
TEST THREEE"
the printer can not roll the paper below the three lines
because I am using those fiscal printers...
down below is the, modified, code I found in internet...
i am trying to do that in about 4 hours without any good result.
|
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...
|
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: 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,...
|
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...
|
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...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
