Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
augustin_p
Starting Member
21 Posts |
 Posted - 2002-04-04 : 05:21:05
|
| Hi, I need to display an annual report of Issues and Receipts of materials. The report should look something like below.Material Name Jan Feb ------------- -- --- - -- -- --- Issues Receipts Issues ReceiptsMaterialA 100 12 300 400and so on for a year.I have a separate tables for Issues and Receipts of materials. which is the best way to achieve this? I would like to achieve this using a stored proc without using multiple update statements.Table Defns------------1) Material Master-----------------MaterialIdMaterialName2) Issues----------IssueDateIssueQuantityMaterialId3) Receipts------------ReceiptDateReceiptQuantityMaterialId |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-04 : 06:32:43
|
| little bit confused....(possibly result of the formatting)3/4 columns named at top of report...yet 5 columns of data...can you post a more comprehensive sample of input data (covering multiple materials, input dates, etc)....and a longer sample output data set....?take care with the layout, to minimise display problems....(maybe the problems are at my end....in my display font!!)...but note that columnar data displays best in "courier/courier new" format...gives spaces the same width as text. |
 |
|
|
|
|
|
Query for Annual Report