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 |
|
shahnawazar
Starting Member
1 Post |
 Posted - 2008-03-17 : 04:53:57
|
| Please help me to make Cross tab ReportMY DATABASE TABLESJOBS---------------------Jobs (JobID numeric identity,CustomerListID Nvarchar(150),BranchName Nvarchar(150),TechnicianListID nvarchar (150),Hours numeric (9),Minutes numeric (9),JobDescription nvarchar (250),Contact nvarchar(150),Billable nvarchar (50),QB nvarchar (150),Notes nvarchar (250),JobDay nvarchar (150) ,JobMonth nvarchar (150),JobYear nvarchar (150),JobDate smalldatetime,DeliveryBookNo numeric ,DeliveryBookPageNo numeric,DateCreated datetime)Technicians---------------Technicians(TechnicianID nvarchar (250), TechnicianName nvarchar (250),Password nvarchar (150),Category nvarchar (150))Customers----------Customers(CustomerID numeric identity,CustomerListID nvarchar (250),FullName nvarchar (250))REPORT DISPLAY LIKE THISCUSTOMER NAME |DATE*1 2 3 TO 28/30|GRANDTOTAL ------------------------------------------------------------------CUST1 2(HOURS)* |2CUST2 9 |9 ------------------------------------------------------------------GRANDTOTAL 2 9 | 10 2(HOURS)* FROM JOBS TABLE,SPENT HOURS FOR CUSTOMER1 on 1st OF MONTH & 9(HOURS) 30th OF MONTH FOR CUSTOMER2CUST1 FROM CUSTOMER TABLEDATE* DAYS OF MONTH WHEN JOB DONE FOR CUSTOMER PLEASE HELP ME TO MAKE THIS REPORT IN MS-VSTUDIO-ASP AND MS SQL SERVERshah |
|
|
|
|
|
|
|
Cross Tab Report in ASP