报表要求如下:
数据源:
表:
CREATE TABLE KangDR.dbo.t_BaseLine_SharpInstrument (
FID INT NOT NULL
,FHospitalID INT NULL
,FUserName VARCHAR(20) NULL
,FYearMonth VARCHAR(20) NULL
,FInjuryTimes INT NULL
,FOperatorID INT NULL
,FDate DATETIME NULL
,FSex INT NULL
,FWorkAge DECIMAL(4, 2) NULL
,FWorkTypeID INT NULL
,FTrain INT NULL
,FAmpouleBottleBurstTimes INT NULL
,FAmpouleBottleBurstType INT NULL
,FSource INT NOT NULL DEFAULT (0)
,FDeptID INT NOT NULL DEFAULT (0)
,CONSTRAINT PK_T_BN_BASELINESHARPINSTRUMEN PRIMARY KEY CLUSTERED (FID)
) ON [PRIMARY]
GO
FID INT NOT NULL
,FHospitalID INT NULL
,FUserName VARCHAR(20) NULL
,FYearMonth VARCHAR(20) NULL
,FInjuryTimes INT NULL
,FOperatorID INT NULL
,FDate DATETIME NULL
,FSex INT NULL
,FWorkAge DECIMAL(4, 2) NULL
,FWorkTypeID INT NULL
,FTrain INT NULL
,FAmpouleBottleBurstTimes INT NULL
,FAmpouleBottleBurstType INT NULL
,FSource INT NOT NULL DEFAULT (0)
,FDeptID INT NOT NULL DEFAULT (0)
,CONSTRAINT PK_T_BN_BASELINESHARPINSTRUMEN PRIMARY KEY CLUSTERED (FID)
) ON [PRIMARY]
GO
CREATE TABLE KangDR.dbo.t_BaseLine_SharpInstrumentDetial (
FID INT NULL
,FParentID INT NULL
,FSourceExposure INT NULL
,FPollutionStatus INT NULL
,FBloodBorneDiseases INT NULL
,FDiseaseType INT NULL
,FOrtherDiseaseType VARCHAR(50) NULL
,FReported INT NULL
,FHappenType INT NULL
,FHappenPlaces INT NULL
,FInstrumentID INT NULL
,FHappenOrtherType VARCHAR(200) NULL
,FHappenOrtherPlaces VARCHAR(200) NULL
,FOrtherInstrument VARCHAR(200) NULL
) ON [PRIMARY]
GO
FID INT NULL
,FParentID INT NULL
,FSourceExposure INT NULL
,FPollutionStatus INT NULL
,FBloodBorneDiseases INT NULL
,FDiseaseType INT NULL
,FOrtherDiseaseType VARCHAR(50) NULL
,FReported INT NULL
,FHappenType INT NULL
,FHappenPlaces INT NULL
,FInstrumentID INT NULL
,FHappenOrtherType VARCHAR(200) NULL
,FHappenOrtherPlaces VARCHAR(200) NULL
,FOrtherInstrument VARCHAR(200) NULL
) ON [PRIMARY]
GO
视图:
SELECT
main.FID
,main.FHospitalID
,main.FUserName
,main.FYearMonth
,main.FInjuryTimes
,main.FOperatorID
,main.FDate
,main.FSex
,main.FWorkAge
,main.FWorkTypeID
,main.FTrain
main.FID
,main.FHospitalID
,main.FUserName
,main.FYearMonth
,main.FInjuryTimes
,main.FOperatorID
,main.FDate
,main.FSex
,main.FWorkAge
,main.FWorkTypeID
,main.FTrain