Difference between revisions of "Integrationsstatus 2010 - 10008vox"

From Catglobe Wiki
Jump to: navigation, search
(→‎Project location)
Line 68: Line 68:
 
<source lang="csharp">
 
<source lang="csharp">
  
−
setReportStyleSheetId(550);  
+
setReportStyleSheetId(550);
  
−
array aAxes = {"Q1inm_SQ_1","Q1inm_SQ_2","Q1inm_SQ_3","Q1inm_SQ_4","Q1inm_SQ_5","Q2inm","Q3inm","Q4inm"};  
+
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"};  
+
array bAxes = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
  
−
array fill_style1 = DiagramFillStyle_getDefault();
+
Tabulation_setTableLayout(TableChartLayout_Ifka);
−
array font_AbsCol = DiagramFontStyle_getDefault();
 
−
font_AbsCol[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
 
−
font_AbsCol[DIAGRAM_FONT_STYLE_FACE] = "Arial";
 
−
font_AbsCol[DIAGRAM_FONT_STYLE_SIZE] = 9;
 
−
array style_decimal = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
 
−
style_decimal[TABLE_DIAGRAM_STYLE_FILL] = fill_style1;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_FONT] = font_AbsCol;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 
−
style_decimal[TABLE_DIAGRAM_STYLE_HALIGN] = "right";
 
−
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn, style_decimal);  
 
  
−
array font_RowHeader = DiagramFontStyle_getDefault();  
+
Tabulation_setAbsText("abs");
−
font_RowHeader[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#FFFFFF");  
+
Tabulation_setPctText("%");
−
font_RowHeader[DIAGRAM_FONT_STYLE_FACE] = "Arial";
+
Tabulation_setCountAnswer(true);
−
font_RowHeader[DIAGRAM_FONT_STYLE_SIZE] = 11&nbsp;;
+
Tabulation_setTotalAnswerText("Total sample size");
−
array fill_style = DiagramFillStyle_getDefault();  
+
Tabulation_setEnableOddEvenRowHeader(true);
−
fill_style[DIAGRAM_FILL_STYLE_COLOR ] = Color_getByRGB("#2666AA");  
+
Tabulation_setMergeStatisticPctItem(true);
−
array style_alignment = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
 
−
style_alignment[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
 
−
style_alignment[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
 
−
style_alignment[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 
−
style_alignment[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
 
−
Tabulation_setDiagramStyle(TableDiagram_RowHeader, style_alignment);  
 
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeader, style_alignment);  
 
  
−
array style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
+
//set values for Abs column
−
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;  
+
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
−
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
+
array fill_AbsCol = {19,{17,0,0,0},2,true};
−
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";  
+
string valign = "center";
−
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "center";  
+
string halign_AbsCol = "right";
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_colheader);  
+
number decimal = 0;
−
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_colheader);
+
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
−
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_colheader);  
+
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);
  
−
for (number i=0;i < arrayCount(aAxes);i=i+1) {
+
//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]);
 
  createFrequenceDiagram(aAxes[i]);
 +
}
  
−
}
+
style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
−
 
+
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;  
−
style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
+
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;  
−
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;  
+
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
−
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;  
+
style_header[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
−
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";  
+
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);
−
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "left";  
 
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_colheader);
 
−
 
 
−
for (i=0;i < arrayCount(aAxes);i=i+1) {
 
  
 +
for (i=0;i < arrayCount(aAxes);i=i+1)
 +
{
 
  for (number j=0;j < arrayCount(bAxes);j=j+1)
 
  for (number j=0;j < arrayCount(bAxes);j=j+1)
 
  {
 
  {
 
   createCrossDiagram({aAxes[i]},{bAxes[j]});
 
   createCrossDiagram({aAxes[i]},{bAxes[j]});
 
  }
 
  }
 +
}
  
−
}
+
Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);
−
 
+
Tabulation_setHasPageNumber(true);
−
Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);  
+
Tabulation_setShowResultAsPdf(true);
−
Tabulation_setShowResultAsPdf(true);  
 
  
 
</source>  
 
</source>  
Line 141: Line 143:
 
<source lang="csharp">
 
<source lang="csharp">
  
−
setReportStyleSheetId(550);  
+
setReportStyleSheetId(550);
 +
 
 +
array aRow = {"RUC_1","RUC_2"};
  
−
array aRow = {"RUC_1","RUC_2"};  
+
array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
  
−
array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};  
+
Tabulation_setTableLayout(TableChartLayout_Ifka);
  
−
array fill_style1 = DiagramFillStyle_getDefault();  
+
Tabulation_setAbsText("abs");
−
array font_AbsCol = DiagramFontStyle_getDefault();  
+
Tabulation_setPctText("%");
−
font_AbsCol[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");  
+
Tabulation_setCountAnswer(true);
−
font_AbsCol[DIAGRAM_FONT_STYLE_FACE] = "Arial";  
+
Tabulation_setTotalAnswerText("Total sample size");
−
font_AbsCol[DIAGRAM_FONT_STYLE_SIZE] = 9&nbsp;;
+
Tabulation_setEnableOddEvenRowHeader(true);
−
array style_decimal = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
+
Tabulation_setMergeStatisticPctItem(true);
−
style_decimal[TABLE_DIAGRAM_STYLE_FILL] = fill_style1;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_FONT] = font_AbsCol;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;
 
−
style_decimal[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
 
−
style_decimal[TABLE_DIAGRAM_STYLE_HALIGN] = "right";
 
−
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn, style_decimal);  
 
  
−
array font_RowHeader = DiagramFontStyle_getDefault();
+
//set values for Abs column
−
font_RowHeader[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#FFFFFF");
+
array font = {18,"Arial",8,{17,0,0,0},false,false,false,true};
−
font_RowHeader[DIAGRAM_FONT_STYLE_FACE] = "Arial";
+
array fill_AbsCol = {19,{17,0,0,0},2,true};
−
font_RowHeader[DIAGRAM_FONT_STYLE_SIZE] = 11&nbsp;;  
+
string valign = "center";
−
array fill_style = DiagramFillStyle_getDefault();  
+
string halign_AbsCol = "right";
−
fill_style[DIAGRAM_FILL_STYLE_COLOR ] = Color_getByRGB("#2666AA");
+
number decimal = 0;
−
array style_alignment = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
+
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
−
style_alignment[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
+
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);
−
style_alignment[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;  
 
−
style_alignment[TABLE_DIAGRAM_STYLE_VALIGN] = "center";  
 
−
style_alignment[TABLE_DIAGRAM_STYLE_HALIGN] = "left";  
 
−
Tabulation_setDiagramStyle(TableDiagram_RowHeader, style_alignment);  
 
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeader, style_alignment);  
 
  
−
array style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
+
//set values for Count Answer Row
−
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
+
array font_CountAnswer = {18,"Arial",8,{17,0,0,0},true,false,false,false};
−
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
+
string halign_CountAnswer = "left";
−
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";  
+
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
−
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "center";  
+
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_colheader);
 
−
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_colheader);  
 
−
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_colheader);  
 
  
−
for (number i=0;i < arrayCount(aRow);i=i+1) {
+
//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]);
 
  createFrequenceDiagram(aRow[i]);
 +
}
  
−
}
+
style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
−
 
+
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;  
−
style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);  
+
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;  
−
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;  
+
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
−
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;  
+
style_header[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
−
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";  
+
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_header);
−
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "left";  
 
−
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_colheader);
 
−
 
 
−
for (i=0;i < arrayCount(aCol);i=i+1) {
 
  
 +
for (i=0;i < arrayCount(aCol);i=i+1)
 +
{
 
  for (number j=0;j < arrayCount(aRow);j=j+1)
 
  for (number j=0;j < arrayCount(aRow);j=j+1)
 
  {
 
  {
 
   createCrossDiagram({aRow[j]},{aCol[i]});
 
   createCrossDiagram({aRow[j]},{aCol[i]});
 
  }
 
  }
 +
}
  
−
}
+
Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);
−
 
+
Tabulation_setHasPageNumber(true);
−
Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);  
+
Tabulation_setShowResultAsPdf(true);
−
Tabulation_setShowResultAsPdf(true);  
 
  
 
</source>
 
</source>

Revision as of 10:12, 28 January 2011

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

Path.png

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.


Retrieved from "http://wiki.catglobe.com/index.php?title=Integrationsstatus_2010_-_10008vox&oldid=14136"