Help in dbr.compare

(2 posts) (2 voices)

Tags:

No tags yet.

  1. ajitdixit, Member

    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

  2. myDBR Team, Key Master

    a) How to make 'dbr.calc' make calculations in dbr.compare

    Update to the newest myDBR version and you can use dbr.calc with dbr.compare

    b) How to make Header Title Left Aligned in dbe.compare

    You can override the default centering. If you want headers aligned to left and have only numeric data fields and want to align them to right you can use:

    select 'dbr.css', 'table.compare td.pageview_cell1 {text-align:left} table.compare td {text-align:right}';

    Can I mix dbr.compare with crosstab reports

    Compare and crosstab reports are fundamentally different concepts and you can choose between them, not combine them.

    --
    myDBR Team


Reply

You must log in to post.