473,507 Members | 2,443 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

printing a stock book type page

I have two tables.
The ITEM RECD table containing the fields -- recd_invoice_ no,
invoice_date,part_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

May 23 '07 #1
0 1125

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

Similar topics

3
2826
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...
1
2040
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,...
5
3450
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...
8
9586
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...
0
1810
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...
0
1475
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)...
1
5682
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...
1
3181
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...
4
1886
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...
0
7223
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,...
0
7114
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...
0
7321
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,...
0
7377
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...
1
5045
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...
0
4702
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...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1544
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 ...
1
762
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.