This is my code ;
I have 3 questions
a) How to make 'dbr.calc' make calculations in dbr.compare
b) How to make Header Title Left Aligned in dbe.compare
c) Can I mix dbr.compare with crosstab reports
Regards ,
/*
SELECT 'dbr.calc' , '[%InTime]' , '(([WITHIN120])/[NOOFTESTS])*100'
SELECT 'dbr.calc' , '[%D30]' , '([DELAY30]/[NOOFTESTS])*100'
SELECT 'dbr.calc' , '[%D60]' , '([DELAY60]/[NOOFTESTS])*100'
SELECT 'dbr.calc' , '[%D90]' , '([DELAY90]/[NOOFTESTS])*100'
SELECT 'dbr.calc' , '[%D120]' , '([DELAY120]/[NOOFTESTS])*100'
SELECT 'dbr.calc' , '[%D120PLUS]' , '([DELAY120PLUS]/[NOOFTESTS])*100'
*/
select 'dbr.compare'
select 'dbr.compare.options', 'no_compare', 'ReportType';
-- select 'dbr.compare.options', 'compare_column', '[%InTime]', 'ReportType';
select 'dbr.column.title' , '[NoOfPatients]' , 'Number Of Patients' ;
select 'dbr.column.title' , '[NOOFTESTS]' , 'Number Of Tests Done' ;
select 'dbr.column.title' , '[WITHIN120]' , 'Number Of Tests Report Released in 2 Hours' ;
select 'dbr.column.title' , '[% Of InTime]' , '% Number Of Tests Report Released in 2 Hours' ;
select 'dbr.column.title' , 'DELAY30' , 'Number Of Tests Report Released in 2 Hours 30 Minutes' ;
select 'dbr.column.title' , '[% Of DELAY30]' , '% Number Of Tests Report Released in 2 Hours 30 Minutes' ;
select 'dbr.column.title' , 'DELAY60' , 'Number Of Tests Report Released in 3 Hours' ;
select 'dbr.column.title' , '[% Of DELAY60]' , '% Number Of Tests Report Released in 3 Hours' ;
select 'dbr.column.title' , 'DELAY90' , 'Number Of Tests Report Released in 3 Hours 30 Minutes' ;
select 'dbr.column.title' , '[% Of DELAY90]' , '% Number Of Tests Report Released in 3 Hours 30 Minutes' ;
select 'dbr.column.title' , 'DELAY120' , 'Number Of Tests Report Released in 4 Hours' ;
select 'dbr.column.title' , '[% Of DELAY120]' , '% Number Of Tests Report Released in 4 Hours' ;
select 'dbr.column.title' , 'DELAY120PLUS' , 'Number Of Tests Report Released after 4 Hours' ;
select 'dbr.column.title' , '[% Of DELAY120PLUS]' , '% Number Of Tests Report Released after 4 Hours' ;
select 'dbr.column.title' , '[SRTORESULT]' , 'Average Time in Minutes Sample Receipt To Result ' ;
select 'dbr.column.title' , '[RESULTTOVAL]' , 'Average Time in Minutes Result To Technical Validation ' ;
select 'dbr.column.title' , '[VALTOAUTH]' , 'Average Time in Minutes Technical Validation To Approval' ;
select 'dbr.column.title' , '[AUTHTOPDF]' , 'Average Time in Minutes Approval To PDF' ;
select 'dbr.column.title' , '[SRTOPDF]' , 'Average Time in Minutes Sample Receipt To PDF' ;
select 'dbr.column.title' , '[SRTOAUTH]' , 'Average Time in Minutes Sample Receipt To Approval' ;
select 'dbr.header.colclass', '[ReportType]' , 'align_l';
select 'dbr.header.colclass', '[NoOfPatients]' , 'align_l';
select 'dbr.header.colclass', 3 , 'align_l';
select 'dbr.header.colclass', 4 , '[text-align: left]';
select 'dbr.header.colclass', 5 , '[text-align: left]';
select 'dbr.header.colclass', 6 , '[text-align: left]';
select 'dbr.header.colclass', 7 , '[text-align: left]';
select 'dbr.header.colclass', 8 , '[text-align: left]';
select 'dbr.headerstyle', 'align_l';
SELECT [ReportType]
, [NoOfPatients]
,[NOOFTESTS]
,[WITHIN120]
,CAST((CAST([WITHIN120] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of InTime]
,[DELAY30]
,CAST((CAST([DELAY30] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of DELAY30]
,[DELAY60]
,CAST((CAST([DELAY60] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of DELAY60]
,[DELAY90]
,CAST((CAST([DELAY90] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of DELAY90]
,[DELAY120]
,CAST((CAST([DELAY120] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of DELAY120]
,[DELAY120PLUS]
,CAST((CAST([DELAY120PLUS] as DECIMAL(18,2))/[NOOFTESTS])*100 as DECIMAL(18,2)) [% Of DELAY120PLUS]
,[SRTORESULT]
,[RESULTTOVAL]
,[VALTOAUTH]
,[AUTHTOPDF]
-- ,[SRTOPDF]
-- , [SRTOAUTH]
, SRTORESULT + RESULTTOVAL + VALTOAUTH + AUTHTOPDF SRTOPDF
, SRTORESULT + RESULTTOVAL + VALTOAUTH SRTOAUTH
