Integrationsstatus 2010 - 10008vox

<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>

Introduction

The production team

Function	Name
Consultant (DK)	Ulrik Hjarnaa
Data Consultant (VN)	Đàm Thục Vy Vân
Data Consultant (VN)	Huỳnh Huy Phong

Assignment

Our assignments for this project are:

• Create two table reports; each report must include the listed questions as frequency tables and then as cross tables on demographic background variables; Create this as two tabulation script so that it will be to run multiple times.They should have nice table layout and be converted to PDF.

Questionnaire: 10008vox - IntegrationsStatus 2010

Variables report 1: (Report name: 10008vox – Indenrigsministeriet)

Q1inm

Q2inm

Q3inm

Q4inm

Variables report 2: (Report name: 10008vox – RUC)

RUC_1

RUC_2

Demographic variables (Column):

Demographic_Gender

D_Demographic_AgeGroup

D_Demographic_RegionMinimize

RefugeeStatus_dupe

Origin

• Create the stylesheet that takes care of as much as possible of the settings.
  

Project location

All resources for this project must be created under the project named 10008vox - Integrationsstatus 2010 located on mycatinet.catglobe.com

Tabulation scripts:

• 10008vox – Indenrigsministeriet

setReportStyleSheetId(550);

array aAxes = {"Q1inm_SQ_1","Q1inm_SQ_2","Q1inm_SQ_3","Q1inm_SQ_4","Q1inm_SQ_5","Q2inm","Q3inm","Q4inm"};

array bAxes = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};

Tabulation_setTableLayout(TableChartLayout_Ifka);

Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setCountAnswer(true);
Tabulation_setTotalAnswerText("Total sample size");
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setMergeStatisticPctItem(true);

//set values for Abs column
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
array fill_AbsCol = {19,{17,0,0,0},2,true};
string valign = "center";
string halign_AbsCol = "right";
number decimal = 0;
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);

//set values for Count Answer Row
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
string halign_CountAnswer = "left";
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);

//set values for Headers column
array font_Header = DiagramFontStyle_getDefault(); 
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";    
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;    
array fill_style = DiagramFillStyle_getDefault();   
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);

for (number i=0;i < arrayCount(aAxes);i=i+1)
{
 createFrequenceDiagram(aAxes[i]);
}

style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);

for (i=0;i < arrayCount(aAxes);i=i+1)
{
 for (number j=0;j < arrayCount(bAxes);j=j+1)
 {
   createCrossDiagram({aAxes[i]},{bAxes[j]});
 }
}

Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setHasPageNumber(true);
Tabulation_setShowResultAsPdf(true);

• 10008vox – RUC
  

setReportStyleSheetId(550);

array aRow = {"RUC_1","RUC_2"};

array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};

Tabulation_setTableLayout(TableChartLayout_Ifka);

Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setCountAnswer(true);
Tabulation_setTotalAnswerText("Total sample size");
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setMergeStatisticPctItem(true);

//set values for Abs column
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
array fill_AbsCol = {19,{17,0,0,0},2,true};
string valign = "center";
string halign_AbsCol = "right";
number decimal = 0;
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);

//set values for Count Answer Row
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
string halign_CountAnswer = "left";
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);

//set values for Headers column
array font_Header = DiagramFontStyle_getDefault(); 
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Arial";    
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 8 ;    
array fill_style = DiagramFillStyle_getDefault();   
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);

for (number i=0;i < arrayCount(aRow);i=i+1)
{
 createFrequenceDiagram(aRow[i]);
}

style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);    
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;    
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;    
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] =  "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);

for (i=0;i < arrayCount(aCol);i=i+1)
{
 for (number j=0;j < arrayCount(aRow);j=j+1)
 {
   createCrossDiagram({aRow[j]},{aCol[i]});
 }
}

Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setHasPageNumber(true);
Tabulation_setShowResultAsPdf(true);

Deliveries

Status report

Setup Tabulation report for providing consultant and management with easy overview of project progress.