View source for Integrationsstatus 2010 - 10008vox

<accesscontrol>Main:MyGroup</accesscontrol>
== Introduction  ==

=== The production team  ===

{| border="1" class="CGTable"
|-
! Function 
! Name
|-
| Consultant (DK) 
| Ulrik Hjarnaa
|-
| Data Consultant (VN) 
| [[Đàm Thục Vy Vân]]
|-
| Data Consultant (VN) 
| [[Huỳnh Huy Phong]]
|}

=== Assignment<br>  ===

Our assignments for this project are: <br> 

*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.

'''<u>Questionnaire:</u>''' 10008vox - IntegrationsStatus 2010 

<u>'''Variables report 1:'''</u> (Report name: '''''10008vox – Indenrigsministeriet''''') 

Q1inm 

Q2inm 

Q3inm 

Q4inm 

<u>'''Variables report 2:'''</u> (Report name: ''10008vox – RUC'') 

RUC_1 

RUC_2 

<u>'''Demographic variables (Column):<br>'''</u> 

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.<br>

=== Project location<br>  ===

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

[[Image:Path.png]]<br> 

'''Tabulation scripts:'''<br> 

*''<u>10008vox – Indenrigsministeriet</u>''<u></u>

<source lang="csharp">

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);

</source> 

*<u>''10008vox – RUC''</u><br>

<source lang="csharp">

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);

</source>

== Deliveries  ==

=== Status report  ===

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

<br> 

[[Category:Production_guidelines]]