如何通过SQL实现这样的报表,请大侠们指点。。。 不知道如何插入图片,请大侠们在这儿看一下报表截图http://hi.csdn.net/space-2821520-do-album-picid-584316.html 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --相关表的创建if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Z_Order]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Z_Order]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Z_OrderE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Z_OrderE]GO--表体CREATE TABLE [dbo].[Z_LH_Order] ( [FID] [int] NOT NULL , -- [FBillNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , --单据号 [FCustNo] [int] NOT NULL , --客户代码 [FTime] [datetime] NULL , --制单时间 [FBillerNo] [int] NOT NULL , --制单人代码 [FCheckerNo] [int] NOT NULL , --审核人代码 [FCheckTime] [datetime] NULL , --审核时间 [FCarNO] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --车牌号 [FProType] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --包装类型(包装/散装) [FSumActQty] [decimal](23, 10) NOT NULL , --执行数量 [FSumActAmount] [decimal](23, 10) NOT NULL , --执行金额 [FStatus] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --车辆状态 [FConcreteNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --水泥编号代码 [FQTY] [decimal](23, 10) NULL , --车辆载重 [FBaseEmp] [int] NOT NULL , --业务员代码 [FWarehouseID] [int] NOT NULL , --仓库代码 [FCarTare] [decimal](23, 10) NOT NULL , --车辆皮重 ) ON [PRIMARY]GO--明细CREATE TABLE [dbo].[Z_OrderE] ( [FEntryID] [int] IDENTITY (1, 1) NOT NULL , --分录号 [FID] [int] NOT NULL , [FProductNo] [int] NOT NULL , --产品代码((2758:散装P.O42.5; 2760: 散装P.C32.5; --2762:包装P.C32.5; 2764:包装P.O42.5 [FProductName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --产品名称(散装P.O42.5/散装P.C32.5/包装P.C32.5/包装P.O42.5) [FPrice] [decimal](23, 10) NOT NULL , --单价 [FType] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --规格型号(包装/散装) [FActQty] [decimal](23, 10) NOT NULL , --执行数量 [FActAmount] [decimal](23, 10) NOT NULL , --执行金额 [FBillNO_E] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --关联单号(与发货计划关联) [FEntryID_E] [int] NOT NULL , --关联分录号(与发货计划关联) [FPlanDate] [datetime] NULL , --发货计划日期(与发货计划关联) [FCust_E] [int] NOT NULL --关联客户(与发货计划关联)) ON [PRIMARY]GO /*----------------------------------------------------------*//*---------------------测试数据-----------------------------*//*---------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)Values(29091,'00024758',15320,'2010-07-08 15:38:55',16394,0,NULL,'123','散装',15,4500,'已进厂','2C10068',20,9798,'01',5)/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E) Values(1,29091,2758,'散装P.O42.5',300,'散装',15,4500,'0',0,'2010-07-08',15320)/*----------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)Values(29092,'00024759',15321,'2010-07-08 15:38:58',16394,0,NULL,'124','散装',15,4200,'已进厂','2C10069',20,9798,'01',5)/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E) Values(1,29092,2760,'散装P.C32.5',280,'散装',15,4200,'0',0,'2010-07-08',15321)/*----------------------------------------------------------*//*----------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)Values(29093,'00024760',15322,'2010-07-08 17:38:55',16394,0,NULL,'1211','包装',15,4800,'已进厂','2C10068',20,9798,'01',5)/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E) Values(1,29093,2764,'包装P.O42.5',320,'包装',15,4800,'0',0,'2010-07-08',15322)/*----------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)Values(29094,'00024761',15323,'2010-07-08 15:38:58',16394,0,NULL,'124','散装',15,4500,'已进厂','2C10069',20,9798,'01',5)/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E) Values(1,29094,2762,'包装P.C32.5',300,'包装',15,4500,'0',0,'2010-07-08',15323)/*----------------------------------------------------------*/ 大侠们的意思是需要联系开发商做一个这样的报表了用SQL是否能够实现呢? 晕,你知不知报表是什么东东哦?要用其它开发工具做的,用来显示数据的,不是用SQL开发的.... 就是想请教大侠用SQL语句是否能实现那样的查询统计如果能用开发工具做,当然不用求助了 呵呵CSDN的大侠都退隐山林了么? 简单的update....散分. sp_addlinkedserver sqlserver里面有个函数可以截取[database].[dbo].[table]这里面的database,dbo的是什么了 备份时间的安排问题 如何取得时间重叠的数据 文本导入sql2000数据库急(高分) delphi 和sqlserver的问题(在线) MSSQL里建表的SQL语句的问题 无法启动分布式服务是怎么回事,谢谢各位老大 SQL SERVER TRIGGER 聚集索引和非聚集索引的概念、区别、及使用方法? 通过SQL2000查询SQL2008的数据如何实现
drop table [dbo].[Z_Order]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Z_OrderE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Z_OrderE]
GO
--表体
CREATE TABLE [dbo].[Z_LH_Order] (
[FID] [int] NOT NULL , --
[FBillNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , --单据号
[FCustNo] [int] NOT NULL , --客户代码
[FTime] [datetime] NULL , --制单时间
[FBillerNo] [int] NOT NULL , --制单人代码
[FCheckerNo] [int] NOT NULL , --审核人代码
[FCheckTime] [datetime] NULL , --审核时间
[FCarNO] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --车牌号
[FProType] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --包装类型(包装/散装)
[FSumActQty] [decimal](23, 10) NOT NULL , --执行数量
[FSumActAmount] [decimal](23, 10) NOT NULL , --执行金额
[FStatus] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --车辆状态
[FConcreteNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --水泥编号代码
[FQTY] [decimal](23, 10) NULL , --车辆载重
[FBaseEmp] [int] NOT NULL , --业务员代码
[FWarehouseID] [int] NOT NULL , --仓库代码
[FCarTare] [decimal](23, 10) NOT NULL , --车辆皮重
) ON [PRIMARY]
GO
--明细
CREATE TABLE [dbo].[Z_OrderE] (
[FEntryID] [int] IDENTITY (1, 1) NOT NULL , --分录号
[FID] [int] NOT NULL ,
[FProductNo] [int] NOT NULL , --产品代码((2758:散装P.O42.5; 2760: 散装P.C32.5;
--2762:包装P.C32.5; 2764:包装P.O42.5
[FProductName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --产品名称(散装P.O42.5/散装P.C32.5/包装P.C32.5/包装P.O42.5)
[FPrice] [decimal](23, 10) NOT NULL , --单价
[FType] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL , --规格型号(包装/散装)
[FActQty] [decimal](23, 10) NOT NULL , --执行数量
[FActAmount] [decimal](23, 10) NOT NULL , --执行金额
[FBillNO_E] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , --关联单号(与发货计划关联)
[FEntryID_E] [int] NOT NULL , --关联分录号(与发货计划关联)
[FPlanDate] [datetime] NULL , --发货计划日期(与发货计划关联)
[FCust_E] [int] NOT NULL --关联客户(与发货计划关联)
) ON [PRIMARY]
GO
/*---------------------测试数据-----------------------------*/
/*---------------------------------------------------------*/
INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)
Values(29091,'00024758',15320,'2010-07-08 15:38:55',16394,0,NULL,'123','散装',15,4500,'已进厂','2C10068',20,9798,'01',5)
/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E)
Values(1,29091,2758,'散装P.O42.5',300,'散装',15,4500,'0',0,'2010-07-08',15320)
/*----------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)
Values(29092,'00024759',15321,'2010-07-08 15:38:58',16394,0,NULL,'124','散装',15,4200,'已进厂','2C10069',20,9798,'01',5)
/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E)
Values(1,29092,2760,'散装P.C32.5',280,'散装',15,4200,'0',0,'2010-07-08',15321)
/*----------------------------------------------------------*//*----------------------------------------------------------*/
INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)
Values(29093,'00024760',15322,'2010-07-08 17:38:55',16394,0,NULL,'1211','包装',15,4800,'已进厂','2C10068',20,9798,'01',5)
/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E)
Values(1,29093,2764,'包装P.O42.5',320,'包装',15,4800,'0',0,'2010-07-08',15322)
/*----------------------------------------------------------*/INSERT INTO Z_Order(FID,FBillNo,FCustNo,FTime,FBillerNo,FCheckerNo,FCheckTime,FCarNO,FProType,FSumActQty,FSumActAmount,FStatus,FConcreteNo,FQTY,FBaseEmp,FWarehouseID,FCarTare)
Values(29094,'00024761',15323,'2010-07-08 15:38:58',16394,0,NULL,'124','散装',15,4500,'已进厂','2C10069',20,9798,'01',5)
/*----------------------------------------------------------*/INSERT INTO Z_OrderE(FEntryID,FID,FProductNo,FProductName,FPrice,FType,FActQty,FActAmount,FBillNO_E,FEntryID_E,FPlanDate,FCust_E)
Values(1,29094,2762,'包装P.C32.5',300,'包装',15,4500,'0',0,'2010-07-08',15323)
/*----------------------------------------------------------*/
如果能用开发工具做,当然不用求助了