static string GenerateTableRow(ReportBuilder reportBuilder, ReportTable table)
{
ReportColumns[] columns = table.ReportDataColumns;
ReportTextBoxControl ColumnCell = new ReportTextBoxControl();
ReportScale colHeight = ColumnCell.Size;
ReportDimensions padding = new ReportDimensions();
if (columns == null)
{
return("");
}
string strTableRow = "";
strTableRow = @"<TablixRow>
<Height>0.6cm</Height>
<TablixCells>";
for (int i = 0; i < columns.Length; i++)
{
ColumnCell = columns[i].ColumnCell;
padding = ColumnCell.Padding;
strTableRow += @"<TablixCell>
<CellContents>
" + GenerateTextBox("txtCell_" + table.ReportName + "_", ColumnCell.Name, "", true, padding) + @"
</CellContents>
</TablixCell>";
}
strTableRow += @"</TablixCells></TablixRow>";
return(strTableRow);
}
static string GetTextBox(string textBoxName, ReportDimensions padding = null, params string[] strValues)
{
string strTextBox = "";
strTextBox = @" <Textbox Name=""" + textBoxName + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>";
for (int i = 0; i < strValues.Length; i++)
{
strTextBox += GetTextRun(strValues[i].ToString());
}
strTextBox += @"</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + textBoxName + @"</rd:DefaultName>
<Top>1.0884cm</Top>
<Left>0cm</Left>
<Height>0.6cm</Height>
<Width>7.93812cm</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>";
strTextBox += GetDimensions(padding) + @"</Style>
</Textbox>";
return(strTextBox);
}
static string GenerateTableHeaderRow(ReportBuilder reportBuilder, ReportTable table)
{
ReportColumns[] columns = table.ReportDataColumns;
ReportTextBoxControl ColumnCell = new ReportTextBoxControl();
ReportDimensions padding = new ReportDimensions();
if (columns == null)
{
return("");
}
string strTableRow = "";
strTableRow = @"<TablixRow>
<Height>0.6cm</Height>
<TablixCells>";
for (int i = 0; i < columns.Length; i++)
{
ColumnCell = columns[i].ColumnCell;
padding = columns[i].HeaderColumnPadding;
strTableRow += @"<TablixCell>
<CellContents>
" + GenerateTextBox("txtHeader_" + table.ReportName + "_", ColumnCell.Name, columns[i].HeaderText == null || columns[i].HeaderText.Trim() == "" ? ColumnCell.Name : columns[i].HeaderText, false, padding) + @"
</CellContents>
</TablixCell>";
}
strTableRow += @"</TablixCells></TablixRow>";
return(strTableRow);
}
private static string GetFirstRowDimensions(ReportDimensions padding = null, string backgroundColor = null)
{
string strDimensions = "";
if (padding != null || backgroundColor != null)
{
if (padding.Default == 0)
{
strDimensions += string.Format("<BackgroundColor>" + backgroundColor + @"</BackgroundColor>");
strDimensions += string.Format("<PaddingLeft>{0}pt</PaddingLeft>", padding.Left);
strDimensions += string.Format("<PaddingRight>{0}pt</PaddingRight>", padding.Right);
strDimensions += string.Format("<PaddingTop>{0}pt</PaddingTop>", padding.Top);
strDimensions += string.Format("<PaddingBottom>{0}pt</PaddingBottom>", padding.Bottom);
}
else
{
strDimensions += string.Format("<BackgroundColor>" + backgroundColor + @"</BackgroundColor>");
strDimensions += string.Format("<PaddingLeft>{0}pt</PaddingLeft>", padding.Default);
strDimensions += string.Format("<PaddingRight>{0}pt</PaddingRight>", padding.Default);
strDimensions += string.Format("<PaddingTop>{0}pt</PaddingTop>", padding.Default);
strDimensions += string.Format("<PaddingBottom>{0}pt</PaddingBottom>", padding.Default);
}
}
return(strDimensions);
}
static string GetHeaderTextBox(string textBoxName, string left = "1cm", ReportDimensions padding = null, params string[] strValues)
{
string manao = "17.5cm";
string strTextBox = "";
// string left = "1cm";
strTextBox = @" <Textbox Name=""" + textBoxName + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>";
string widthxml = "7.93812cm";
for (int i = 0; i < strValues.Length; i++)
{
strTextBox += GetHeaderTextRun(strValues[i].ToString());
}
//if (poss == 2)
//{
// widthxml = TamanoTitulo.ToString() + "cm";
// left = "3cm";
//}
//else
//{
// left = "1cm";
// widthxml = "7.93812cm";
//}
strTextBox += @"</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + textBoxName + @"</rd:DefaultName>
<Top>0.5cm</Top>
<Left>" + left + @"</Left>
<Height>0.6cm</Height>
<Width>" + widthxml + @"</Width>
<ZIndex>2</ZIndex>
<Style>
<Border>
<Style>None</Style>
</Border>";
strTextBox += GetDimensions(padding) + @"</Style>
</Textbox>";
return(strTextBox);
}
static ReportBuilder InitAutoGenerateReport(ReportBuilder reportBuilder, int[] lista)
{
if (reportBuilder != null && reportBuilder.DataSource != null && reportBuilder.DataSource.Tables.Count > 0)
{
DataSet ds = reportBuilder.DataSource;
int _TablesCount = ds.Tables.Count;
ReportTable[] reportTables = new ReportTable[_TablesCount];
if (reportBuilder.AutoGenerateReport)
{
for (int j = 0; j < _TablesCount; j++)
{
DataTable dt = ds.Tables[j];
ReportColumns[] columns = new ReportColumns[dt.Columns.Count];
ReportDimensions ColumnPadding = new ReportDimensions();
ColumnPadding.Default = 2;
for (int i = 0; i < dt.Columns.Count; i++)
{
ReportScale ColumnScale = new ReportScale();
// ColumnScale.Width = 4;
ColumnScale.Height = 1;
ColumnScale.Width = 0.25 * lista[i];
TamanoTitulo += (0.25 * lista[i]);
columns[i] = new ReportColumns()
{
ColumnCell = new ReportTextBoxControl()
{
Name = dt.Columns[i].ColumnName, Size = ColumnScale, Padding = ColumnPadding
},
HeaderText = dt.Columns[i].ColumnName, HeaderColumnPadding = ColumnPadding
};
}
reportTables[j] = new ReportTable()
{
ReportName = dt.TableName, ReportDataColumns = columns
};
}
}
reportBuilder.Body = new ReportBody();
reportBuilder.Body.ReportControlItems = new ReportItems();
reportBuilder.Body.ReportControlItems.ReportTable = reportTables;
}
return(reportBuilder);
}
static string GenerateFirstWhiteSpacesRow(ReportBuilder reportBuilder, ReportTable table, string filter)
{
ReportColumns[] columns = table.ReportDataColumns;
ReportTextBoxControl ColumnCell = new ReportTextBoxControl();
ReportScale colHeight = ColumnCell.Size;
ReportDimensions padding = new ReportDimensions();
if (columns == null)
{
return("");
}
string strTableRow = "";
strTableRow += @"<TablixRow>
<Height>0.6cm</Height>
<TablixCells>";
for (int i = 0; i < columns.Length; i++)
{
if (i == 0)
{
ColumnCell = columns[i].ColumnCell;
padding = ColumnCell.Padding;
strTableRow += @"<TablixCell>
<CellContents>
" + GenerateFirstRowWhiteTextBox(filter, filter, ColumnCell.Name, "", true, padding) + @"
</CellContents>
</TablixCell>";
}
else
{
count += 3;
ColumnCell = columns[i].ColumnCell;
padding = ColumnCell.Padding;
strTableRow += @"<TablixCell />";
}
}
strTableRow += @"</TablixCells>
</TablixRow>";
return(strTableRow);
}
private static string GetDimensions(ReportDimensions padding = null)
{
string strDimensions = "";
if (padding != null)
{
if (padding.Default == 0)
{
strDimensions += string.Format("<PaddingLeft>{0}pt</PaddingLeft>", padding.Left);
strDimensions += string.Format("<PaddingRight>{0}pt</PaddingRight>", padding.Right);
strDimensions += string.Format("<PaddingTop>{0}pt</PaddingTop>", padding.Top);
strDimensions += string.Format("<PaddingBottom>{0}pt</PaddingBottom>", padding.Bottom);
}
else
{
strDimensions += string.Format("<PaddingLeft>{0}pt</PaddingLeft>", padding.Default);
strDimensions += string.Format("<PaddingRight>{0}pt</PaddingRight>", padding.Default);
strDimensions += string.Format("<PaddingTop>{0}pt</PaddingTop>", padding.Default);
strDimensions += string.Format("<PaddingBottom>{0}pt</PaddingBottom>", padding.Default);
}
}
return(strDimensions);
}
static string GenerateTextBox(string strControlIDPrefix, string strName, string strValueOrExpression = "", bool isFieldValue = true, ReportDimensions padding = null)
{
string strTextBox = "";
strTextBox = @" <Textbox Name=""" + strControlIDPrefix + strName + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>";
if (isFieldValue)
{
strTextBox += @"<Value>=Fields!" + strName + @".Value</Value>";
}
else
{
strTextBox += @"<Value>" + strValueOrExpression + "</Value>";
}
strTextBox += @"<Style />
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + strControlIDPrefix + strName + @"</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>" + GetDimensions(padding) + @"</Style>
</Textbox>";
return(strTextBox);
}
static string GenerateHeaderTableTextBox(string strControlIDPrefix, string strName, string strValueOrExpression = "", bool isFieldValue = true, ReportDimensions padding = null, string tipoleta = "Calibri", string tamanioletra = "8pt")
{
string strTextBox = "";
strTextBox = @" <Textbox Name=""" + strControlIDPrefix + strName + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>";
if (isFieldValue)
{
strTextBox += @"<Value>=Fields!" + strName + @".Value</Value>";
}
else
{
strTextBox += @"<Value>" + strValueOrExpression + "</Value>";
}
strTextBox += @"<Style>
<FontFamily>" + tipoleta + @"</FontFamily>
<FontSize>" + tamanioletra + @"</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Center</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + strControlIDPrefix + strName + @"</rd:DefaultName>
<Style>
<BackgroundColor>#DDDDDD</BackgroundColor>
<FontWeight>Bold</FontWeight>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>" + GetDimensions(padding) + @"</Style>
</Textbox>";
return(strTextBox);
}
static string GenerateWhiteTextBox(string strControlIDPrefix, string strName, string strValueOrExpression = "", bool isFieldValue = true, ReportDimensions padding = null, string tipoleta = "Calibri", string tamanioletra = "8pt")
{
string strTextBox = "";
strTextBox += @"<Textbox Name=""" + strControlIDPrefix + strName + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value/>";
strTextBox += @"<Style>
<FontFamily>" + tipoleta + @"</FontFamily>
<FontSize>" + tamanioletra + @"</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + strControlIDPrefix + strName + @"</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>" + GetDimensions(padding) + @"</Style>
</Textbox>";
return(strTextBox);
}
static string GenerateFirstRowWhiteTextBox(string filter, string strControlIDPrefix, string strName, string strValueOrExpression = "", bool isFieldValue = true, ReportDimensions padding = null, string tipoleta = "Calibri", string tamanioletra = "8pt")
{
string strTextBox = "";
strTextBox += @"<Textbox Name=""" + filter + @""">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=""Agrupado por " + filter + @": "" +Fields!" + filter + @".Value</Value>";
strTextBox += @"<Style>
<FontFamily>" + tipoleta + @"</FontFamily>
<FontSize>" + tamanioletra + @"</FontSize>
</Style>
</TextRun>
</TextRuns>
<Style />
</Paragraph>
</Paragraphs>
<rd:DefaultName>" + filter + @"</rd:DefaultName>
<Style>
<Border>
<Color>LightGrey</Color>
<Style>Solid</Style>
</Border>" + GetFirstRowDimensions(padding, "LightBlue") + @"</Style>
</Textbox>
<ColSpan>" + 5 + @"</ColSpan>
<rd:Selected>true</rd:Selected>";
return(strTextBox);
}
