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 |
|
van73
Starting Member
7 Posts |
 Posted - 2008-01-04 : 04:00:55
|
| Hi all,I have a table like this whose deatils which I need to use are Date OpeningStock Delivered Recvd RemQtyI need to display monthly Billing report like this for the month/dates selected (that forms the parameters - from and To date) week Week1 Week2 Week3 Week4day Mo Te We Th Fr Sa SudateAug1............This row has Opening stock for that day....This row the Qty DeliveredThis row the Quantity receivedDaily Balance StockWeekly Highest Inventory --- this should show the max(balance stock) for that weekAll details are available in the table. Its only the format that I should put into. I tried with PIVOT but was not succesful.Basically columns in the table become rows in the format except for the date column. Any ideas??? |
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-01-04 : 06:03:04
|
Do it in the presentation layer ;)You could knock that up in Crystal Reports in 10 minutes I reckon (that is, if you're familiar with that particular application).Alternatively... Can you port the code for the PIVOT that you tried?
George<3Engaged! |
 |
|
|
|
|
|
Is this possible???