//TODO: Code Review Issue 11/05/05: Give a more specific summary rather than
//using 'object' word.
// Done 24/05/2005
/// <summary>
/// Makes this field render itself as an RDL Field to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("Field");
xmlWriter.WriteAttributeString("Name", _name);
RdlRender.AddLine(xmlWriter, "DataField", _caption);
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL MatrixRow to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
string TextboxValue = "";
if (_isSummable)
{
if (_groupingLevel == 0)
{
TextboxValue = "=Sum(Fields!" + _fieldName + ".Value)";
}
else
{
TextboxValue = @"=Sum(iif(Fields!GroupingLevel.Value <= " + _groupingLevel +
", cdbl(Fields!" + _fieldName + ".Value), cdbl(0)))";
}
}
_textboxStyle.Format = RdlFormatter.FormatData(_dataType);
//TODO: Code Review Issue 11/05/05: indent the code as in XML to increase readability
// Done 24/05/2005
xmlWriter.WriteStartElement("MatrixRow");
RdlRender.AddLine(xmlWriter, "Height", "1cm");
xmlWriter.WriteStartElement("MatrixCells");
xmlWriter.WriteStartElement("MatrixCell");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, TextboxValue, _textboxStyle, "",
"", "", "", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement(); // ReportItems
xmlWriter.WriteEndElement(); // MatrixCell
xmlWriter.WriteEndElement(); // MatrixCells
xmlWriter.WriteEndElement(); // MatrixRow
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes object render itself as an RDL Details type to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("Details");
xmlWriter.WriteStartElement("TableRows");
xmlWriter.WriteStartElement("TableRow");
xmlWriter.WriteStartElement("TableCells");
foreach (TableDetailsTextBox Textbox in _tableDetailsTextBoxList)
{
Textbox.Render(xmlWriter);
}
xmlWriter.WriteEndElement(); // TableCells
// Render footer RDL. Add Visibility information if drillDownGroup != ""
RdlRender.AddLine(xmlWriter, "Height", ".25in");
if (_drillDownGroup != "")
{
xmlWriter.WriteStartElement("Visibility");
RdlRender.AddLine(xmlWriter, "Hidden", "true");
RdlRender.AddLine(xmlWriter, "ToggleItem", "Group" + _drillDownGroup);
xmlWriter.WriteEndElement(); // Visibility
}
xmlWriter.WriteEndElement(); // TableRow
xmlWriter.WriteEndElement(); // TableRows
xmlWriter.WriteEndElement(); // Details
}
/// <summary>
/// Renders this style in RDL using the supplied XmlWriter.
/// </summary>
/// <param name="xmlWriter">The XmlWriter used to write the RDL.</param>
public void Render2010TextRun(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("Style");
//xmlWriter.WriteStartElement("BorderStyle");
//RdlRender.AddLine(xmlWriter, "Top", _borderStyle);
//RdlRender.AddLine(xmlWriter, "Bottom", _borderStyle);
//RdlRender.AddLine(xmlWriter, "Left", _borderStyle);
//RdlRender.AddLine(xmlWriter, "Right", _borderStyle);
//xmlWriter.WriteEndElement(); // BorderStyle
//xmlWriter.WriteStartElement("BorderColor");
//RdlRender.AddLine(xmlWriter, "Top", _borderColour);
//RdlRender.AddLine(xmlWriter, "Bottom", _borderColour);
//RdlRender.AddLine(xmlWriter, "Left", _borderColour);
//RdlRender.AddLine(xmlWriter, "Right", _borderColour);
//xmlWriter.WriteEndElement(); // BorderColour
//RdlRender.AddLine(xmlWriter, "BackgroundColor", _backgroundColour);
//RdlRender.AddLine(xmlWriter, "PaddingLeft", _paddingLeft);
//RdlRender.AddLine(xmlWriter, "PaddingRight", _paddingRight);
//RdlRender.AddLine(xmlWriter, "PaddingTop", _paddingTop);
//RdlRender.AddLine(xmlWriter, "PaddingBottom", _paddingBottom);
RdlRender.AddLine(xmlWriter, "FontSize", _fontSize);
RdlRender.AddLine(xmlWriter, "FontWeight", _fontWeight);
//21/07/05 LL - TIR0200 Set Text Alignment
//RdlRender.AddLine(xmlWriter, "TextAlign", _textAlign);
//RdlRender.AddLine(xmlWriter, "VerticalAlign", _verticalAlign);
RdlRender.AddLine(xmlWriter, "Color", _color);
RdlRender.AddLine(xmlWriter, "TextDecoration", _textDecoration);
RdlRender.AddLine(xmlWriter, "Format", _format);
// end Style tag
xmlWriter.WriteEndElement();//Style
}
public void Render2010TextBox(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("Style");
xmlWriter.WriteStartElement("TopBorder");
RdlRender.AddLine(xmlWriter, "Color", _borderColour);
RdlRender.AddLine(xmlWriter, "Style", _borderStyle);
xmlWriter.WriteEndElement(); // TopBorder
xmlWriter.WriteStartElement("BottomBorder");
RdlRender.AddLine(xmlWriter, "Color", _borderColour);
RdlRender.AddLine(xmlWriter, "Style", _borderStyle);
xmlWriter.WriteEndElement(); // BottomBorder
xmlWriter.WriteStartElement("LeftBorder");
RdlRender.AddLine(xmlWriter, "Color", _borderColour);
RdlRender.AddLine(xmlWriter, "Style", _borderStyle);
xmlWriter.WriteEndElement(); // LeftBorder
xmlWriter.WriteStartElement("RightBorder");
RdlRender.AddLine(xmlWriter, "Color", _borderColour);
RdlRender.AddLine(xmlWriter, "Style", _borderStyle);
xmlWriter.WriteEndElement(); // RightBorder
RdlRender.AddLine(xmlWriter, "BackgroundColor", _backgroundColour);
RdlRender.AddLine(xmlWriter, "PaddingLeft", _paddingLeft);
RdlRender.AddLine(xmlWriter, "PaddingRight", _paddingRight);
RdlRender.AddLine(xmlWriter, "PaddingTop", _paddingTop);
RdlRender.AddLine(xmlWriter, "PaddingBottom", _paddingBottom);
//????? RdlRender.AddLine(xmlWriter, "TextAlign", _textAlign);
RdlRender.AddLine(xmlWriter, "VerticalAlign", _verticalAlign);
RdlRender.AddLine(xmlWriter, "Format", _format);
// end Style tag
xmlWriter.WriteEndElement();//Style
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
/// <summary>
/// Makes object render itself as an RDL Query to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: Add necessary comment on each code block and
//indent the code as in XML where possible to increase readability
// Done 24/05/2005
xmlWriter.WriteStartElement("Query");
RdlRender.AddLine(xmlWriter, "DataSourceName", "DataSource1");
RdlRender.AddLine(xmlWriter, "CommandType", "Text");
xmlWriter.WriteStartElement("CommandText");
//Puts the current user code into the SQL context info. The SetContextInfo stored procedure must exist on the database.
xmlWriter.WriteString("EXECUTE [SetContextInfo] @ReportUserCode ");
xmlWriter.WriteString(_queryText);
xmlWriter.WriteEndElement(); //CommandText
RdlRender.AddLine(xmlWriter, "Timeout", "120");
// Each queryParameter must render itself
if (_queryParameters == null || _queryParameters.Count > 0)
{
xmlWriter.WriteStartElement("QueryParameters");
foreach (string Item in _queryParameters)
{
xmlWriter.WriteStartElement("QueryParameter");
xmlWriter.WriteAttributeString("Name", "@" + Item);
RdlRender.AddLine(xmlWriter, "Value", "=Parameters!" +
Item + ".Value");
xmlWriter.WriteEndElement(); // QueryParameter
}
xmlWriter.WriteEndElement(); // QueryParameters
}
xmlWriter.WriteEndElement(); // Query
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL Textbox to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, "=Fields!" + _name + ".Value",
_textboxStyle, "", "", "", "", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
}
/// <summary>
/// Makes object render itself as an RDL Footer type to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: indent the code as in XML to increase readability
// Done 24/05/2005
ReportingServicesStyle _textboxStyle10pt = new ReportingServicesStyle(
ReportingServicesStyle.TextBoxStyle.TabularReport10pt);
//RdlRender.AddLine(xmlWriter, "RepeatOnNewPage", "true");
//Report Description
xmlWriter.WriteStartElement("TablixRow");
RdlRender.AddLine(xmlWriter, "Height", ".25in");
xmlWriter.WriteStartElement("TablixCells");
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteStartElement("CellContents");
xmlWriter.WriteStartElement("ColSpan");
xmlWriter.WriteString(_colSpan);
xmlWriter.WriteEndElement();//ColSpan
RdlRender.AddTextbox2010(xmlWriter, "reportDescription", _reportDescription, _textboxStyle10pt, "", "0.25cm", "15.00cm", "3.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement(); //CellContents
xmlWriter.WriteEndElement(); //TablixCell
for (int x = 0; x < (int.Parse(_colSpan) - 1); x++)
{
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteEndElement(); //TablixCell
}
xmlWriter.WriteEndElement(); //TablixCells
xmlWriter.WriteEndElement(); //TablixRow
//Report Filters
foreach (ReportFilterBusinessObject _CurrentFilter in _filterItemList)
{
FilterCount++;
_Filter = "Filter" + FilterCount.ToString();
xmlWriter.WriteStartElement("TablixRow");
RdlRender.AddLine(xmlWriter, "Height", ".25in");
xmlWriter.WriteStartElement("TablixCells");
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteStartElement("CellContents");
xmlWriter.WriteStartElement("ColSpan");
xmlWriter.WriteString(_colSpan);
xmlWriter.WriteEndElement();//ColSpan
_FilterDescription = "Data Filter Applied : " + _CurrentFilter.DataItemCaption + " " + _CurrentFilter.Operand + " " + _CurrentFilter.FilterValue;
RdlRender.AddTextbox2010(xmlWriter, _Filter, _FilterDescription, _textboxStyle10pt, "", "0.25cm", "15.00cm", "3.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement(); //CellContents
xmlWriter.WriteEndElement(); //TablixCell
for (int x = 0; x < (int.Parse(_colSpan) - 1); x++)
{
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteEndElement(); //TablixCell
}
xmlWriter.WriteEndElement(); //TablixCells
xmlWriter.WriteEndElement(); //TablixRow
}
}
public void RenderAxes2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("ChartAxis");
xmlWriter.WriteAttributeString("Name", _seriesName);
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "Format", "#,0;(#,0)");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
xmlWriter.WriteEndElement();//Style
xmlWriter.WriteStartElement("ChartAxisTitle");
RdlRender.AddLine(xmlWriter, "Caption", "Units");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartAxisTitle
//RdlRender.AddLine(xmlWriter,"Interval","1");
RdlRender.AddLine(xmlWriter, "IntervalType", "Default");
//xmlWriter.WriteStartElement("ChartMajorGridLines");
//RdlRender.AddLine(xmlWriter,"Enabled","False");
//xmlWriter.WriteStartElement("Style");
//xmlWriter.WriteStartElement("Border");
//RdlRender.AddLine(xmlWriter,"Color","Gainsboro");
//xmlWriter.WriteEndElement();//Border
//xmlWriter.WriteEndElement();//Style
//xmlWriter.WriteEndElement();//ChartMajorGridLines
xmlWriter.WriteStartElement("ChartMinorGridLines");
RdlRender.AddLine(xmlWriter, "Enabled", "False");
xmlWriter.WriteStartElement("Style");
xmlWriter.WriteStartElement("Border");
RdlRender.AddLine(xmlWriter, "Color", "Gainsboro");
RdlRender.AddLine(xmlWriter, "Style", "Dotted");
xmlWriter.WriteEndElement(); //Border
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartMinorGridLines
//xmlWriter.WriteStartElement("ChartMajorTickMarks");
//RdlRender.AddLine(xmlWriter,"IntervalType","Auto");
//xmlWriter.WriteEndElement();//ChartMajorTickMarks
xmlWriter.WriteStartElement("ChartMinorTickMarks");
RdlRender.AddLine(xmlWriter, "Length", "0.5");
RdlRender.AddLine(xmlWriter, "IntervalType", "Auto");
xmlWriter.WriteEndElement();//ChartMinorTickMarks
RdlRender.AddLine(xmlWriter, "CrossAt", "NaN");
RdlRender.AddLine(xmlWriter, "Interlaced", "true");
RdlRender.AddLine(xmlWriter, "Minimum", "NaN");
RdlRender.AddLine(xmlWriter, "Maximum", "NaN");
xmlWriter.WriteStartElement("ChartAxisScaleBreak");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement(); //ChartAxisScaleBreak
xmlWriter.WriteEndElement(); //ChartAxis
}
/// <summary>
/// Makes object render itself as an RDL TableCell type to an XmlWriter object.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteStartElement("CellContents");
RdlRender.AddTextbox2010(xmlWriter, "Header" + _name, _caption, _textboxStyle,
"Center", "0in", "0in", ".5in", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement(); //CellContents
xmlWriter.WriteEndElement(); //TablixCell
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes object render itself as an RDL TableCell type to an XmlWriter object.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("TableCell");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, "Header" + _name, _caption, _textboxStyle,
"Center", "0in", "0in", ".5in", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL Textbox to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
//21/07/05 LL - TIR0200 - Align Column Heading with Details
_textboxStyle.TextAlign = "Right";
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, "=Fields!" + _name + ".Value",
_textboxStyle, "", "", "", "", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes object render itself as an RDL ReportParameter to an XmlWriter object.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("ReportParameter");
xmlWriter.WriteAttributeString("Name", _name);
// Render relevant data type
switch (_type)
{
case "char":
case "varchar":
case "nchar":
case "nvarchar":
RdlRender.AddLine(xmlWriter, "DataType", "String");
break;
case "datetime":
case "date":
case "time":
case "timestamp":
RdlRender.AddLine(xmlWriter, "DataType", "DateTime");
break;
case "money":
case "decimal":
case "numeric":
RdlRender.AddLine(xmlWriter, "DataType", "Float");
break;
case "int":
RdlRender.AddLine(xmlWriter, "DataType", "Integer");
break;
default:
//TODO: Code Review Issue 11/05/05: Replace the hard-coded message by a Resource Helper Text
// Done 24/05/2005
throw new Exception(Resource.GetString("RES_EXCEPTION_REPORTPARAMETER_INVALIDDATATYPE"));
}
// ValidValues: This displays parameters with values in a drop-down list
// if the item is not a value type
if (!_isValueType)
{
xmlWriter.WriteStartElement("ValidValues");
xmlWriter.WriteStartElement("DataSetReference");
RdlRender.AddLine(xmlWriter, "DataSetName", _name + "ParameterDataSet");
RdlRender.AddLine(xmlWriter, "ValueField", _name);
xmlWriter.WriteEndElement(); // DataSetReference
xmlWriter.WriteEndElement(); // ValidValues
}
RdlRender.AddLine(xmlWriter, "Prompt", _caption);
RdlRender.AddLine(xmlWriter, "AllowBlank", "true");
RdlRender.AddLine(xmlWriter, "Nullable", "true");
xmlWriter.WriteEndElement(); // ReportParameter
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL Subtotal to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: Indent blocks of code as in XML to increase readability.
// Done 24/05/2005
xmlWriter.WriteStartElement("Subtotal");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, "Total", _textboxStyle, "", "", "", "",
"true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL StaticRow to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: give comment and/or indent the code as in XML
//to increase readability
// Done 24/05/2005
xmlWriter.WriteStartElement("StaticRow");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, _fieldName, _textboxStyle, "Right",
"", "", "", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
public void Render2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("ChartSeries");
xmlWriter.WriteAttributeString("Name", SeriesDataItem.Name);
xmlWriter.WriteStartElement("ChartDataPoints");
xmlWriter.WriteStartElement("ChartDataPoint");
xmlWriter.WriteStartElement("ChartDataPointValues");
RdlRender.AddLine(xmlWriter, "X", "=Fields!" + _categoryName + ".Value");
RdlRender.AddLine(xmlWriter, "Y", "=Sum(Fields!" + _seriesName + ".Value)");
xmlWriter.WriteEndElement();//ChartDataPointValues
xmlWriter.WriteStartElement("ChartDataLabel");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement();//ChartDataLabel
RdlRender.AddLine(xmlWriter, "ToolTip", "=FormatNumber(Sum(Fields!" + _seriesName + ".Value),0,true,false,true)");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
xmlWriter.WriteEndElement();//Style
xmlWriter.WriteStartElement("ChartMarker");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement(); //ChartMarker
RdlRender.AddLine(xmlWriter, "DataElementOutput", "Output");
xmlWriter.WriteEndElement(); //ChartDataPoint
xmlWriter.WriteEndElement(); //ChartDataPoints
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "ShadowOffset", "0pt");
xmlWriter.WriteEndElement();//Style
xmlWriter.WriteStartElement("ChartEmptyPoints");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteStartElement("ChartMarker");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement();//ChartMarker
xmlWriter.WriteStartElement("ChartDataLabel");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement(); //ChartDataLabel
xmlWriter.WriteEndElement(); //ChartEmptyPoints
RdlRender.AddLine(xmlWriter, "ValueAxisName", _seriesName);
RdlRender.AddLine(xmlWriter, "CategoryAxisName", _categoryName);
xmlWriter.WriteStartElement("ChartSmartLabel");
RdlRender.AddLine(xmlWriter, "CalloutLineColor", "Black");
RdlRender.AddLine(xmlWriter, "MinMovingDistance", "0pt");
xmlWriter.WriteEndElement(); //ChartSmartLabel
xmlWriter.WriteEndElement(); //ChartSeries
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as an RDL Subtotal to a XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
//21/07/05 LL - TIR0200 Align Column Heading with Details
_textboxStyle.TextAlign = "Right";
//TODO: Code Review Issue 11/05/05: Indent blocks of code as in XML to increase readability.
xmlWriter.WriteStartElement("Subtotal");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, _name, "Total", _textboxStyle, "",
"", "", "", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes object render itself as an RDL TableCell to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
string TextboxValue = _isEmpty ? "" : "=Fields!" + _name + ".Value";
string Alignment = RdlFormatter.FormatAlignment(_dataType);
_textboxStyle.Format = RdlFormatter.FormatData(_dataType);
xmlWriter.WriteStartElement("TableCell");
xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(xmlWriter, "Details" + _name, TextboxValue, _textboxStyle,
Alignment, "0in", "0in", ".5in", "true", "", "", "", "", "", "", "", "", "", "");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
/// <summary>
/// Makes object render itself as an RDL TableCell to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
string TextboxValue = _isEmpty ? "" : "=Fields!" + _name + ".Value";
string Alignment = RdlFormatter.FormatAlignment(_dataType);
_textboxStyle.Format = RdlFormatter.FormatData(_dataType);
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteStartElement("CellContents");
RdlRender.AddTextbox2010(xmlWriter, "Details" + _name, TextboxValue, _textboxStyle,
Alignment, "0in", "0in", ".5in", "true", "", "", "", "", "", "", "", "", "", "", _hyperlink);
xmlWriter.WriteEndElement(); //CellContents
xmlWriter.WriteEndElement(); //TablixCell
}
/// <summary>
/// Makes object render itself as an RDL Header type to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("TablixRow");
RdlRender.AddLine(xmlWriter, "Height", ".25in");
xmlWriter.WriteStartElement("TablixCells");
foreach (ITableHeaderTextBox TextBox in _tableHeaderTextBoxList)
{
TextBox.Render2010(xmlWriter);
}
xmlWriter.WriteEndElement(); //TablixCells
xmlWriter.WriteEndElement(); //TablixRow
// RdlRender.AddLine(xmlWriter, "RepeatOnNewPage", "true");
}
/// <summary>
/// Makes object render itself as an RDL Details type to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("TablixRow");
RdlRender.AddLine(xmlWriter, "Height", ".25in");
xmlWriter.WriteStartElement("TablixCells");
foreach (TableDetailsTextBox Textbox in _tableDetailsTextBoxList)
{
Textbox.Render2010(xmlWriter);
}
xmlWriter.WriteEndElement(); // TablixCells
xmlWriter.WriteEndElement(); // TablixRow
}
/// <summary>
/// Makes object render itself as an RDL TableCell to an XmlWriter object.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render2010(XmlWriter xmlWriter)
{
string TextboxValue = "";
// If this textbox is empty and the data that its column represents may
// be summed, then it displays the sum of the values in its column
// that are within its group.
if (_isEmpty)
{
/* TEMPORARILY REMOVED */
if (_isSummable)
{
if (_groupingLevel == 0)
{
TextboxValue = @"=Sum(Fields!" + _itemName + ".Value)";
}
else
{
// Only give this textbox a value if the field this textbox is grouped by
// is at a lower or equal grouping level than this textbox
if (_newGroupListIndex <= _groupingLevel)
{
TextboxValue = @"=Sum(iif(Fields!GroupingLevel.Value <= " + _groupingLevel +
", cdbl(Fields!" + _itemName + ".Value), cdbl(0)), " + '\u0022' + "Grouping" + _groupName + '\u0022' + ")";
}
}
}
/* */
}
else
{
TextboxValue = "=Fields!" + _name + ".Value";
}
_textboxStyle.Format = RdlFormatter.FormatData(_dataType);
xmlWriter.WriteStartElement("TablixCell");
xmlWriter.WriteStartElement("CellContents");
RdlRender.AddTextbox2010(xmlWriter, "Group" + _name, TextboxValue, _textboxStyle,
RdlFormatter.FormatAlignment(_dataType), "0in", "0in", ".5in", "true",
"", "", "", "", "", "", "", "", "", "", _hyperlink);
xmlWriter.WriteEndElement(); //CellContents
xmlWriter.WriteEndElement(); //TablixCell
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes object render itself as an RDL Header type to an XmlWriter instance.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: indent the code as in XML to increase readability
// Done 24/05/2005
xmlWriter.WriteStartElement("Header");
RdlRender.AddLine(xmlWriter, "RepeatOnNewPage", "true");
xmlWriter.WriteStartElement("TableRows");
xmlWriter.WriteStartElement("TableRow");
xmlWriter.WriteStartElement("TableCells");
foreach (TableHeaderTextBox TextBox in _tableHeaderTextBoxList)
{
TextBox.Render(xmlWriter);
}
xmlWriter.WriteEndElement();
RdlRender.AddLine(xmlWriter, "Height", ".25in");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Renders this object as a RowGrouping in RDL to an XmlWriter.
/// </summary>
/// <param name="xmlWriter">The XmlWriter to render the object to.</param>
public void Render(XmlWriter xmlWriter)
{
//TODO: Code Review Issue 11/05/05: Indent blocks of code as in XML to increase readability.
// Done 24/05/2005
xmlWriter.WriteStartElement("RowGrouping");
RdlRender.AddLine(xmlWriter, "Width", "3.5cm");
xmlWriter.WriteStartElement("DynamicRows");
xmlWriter.WriteStartElement("Grouping");
xmlWriter.WriteAttributeString("Name", _name + "RowGrouping");
xmlWriter.WriteStartElement("GroupExpressions");
RdlRender.AddLine(xmlWriter, "GroupExpression", "=Fields!" + _name + ".Value");
xmlWriter.WriteEndElement(); // GroupExpressions
xmlWriter.WriteEndElement(); // Grouping
xmlWriter.WriteStartElement("Sorting");
xmlWriter.WriteStartElement("SortBy");
RdlRender.AddLine(xmlWriter, "SortExpression", "=Fields!" + _name + ".Value");
RdlRender.AddLine(xmlWriter, "Direction", "Ascending");
xmlWriter.WriteEndElement(); // SortBy
xmlWriter.WriteEndElement(); // Sorting
if (_drillDownGroup != "")
{
xmlWriter.WriteStartElement("Visibility");
RdlRender.AddLine(xmlWriter, "ToggleItem", _drillDownGroup);
RdlRender.AddLine(xmlWriter, "Hidden", "true");
xmlWriter.WriteEndElement();
}
_matrixDynamicRowTextBox.Render(xmlWriter);
if (_isSubTotal)
{
_matrixDynamicRowSubTotal.Render(xmlWriter);
}
xmlWriter.WriteEndElement(); // DynamicRows
xmlWriter.WriteEndElement(); // RowGrouping
}
/// <summary>
/// Stub.
/// </summary>
/// <returns></returns>
public void Render(XmlWriter xmlWriter)
{
if (!_wrapperRequired)
{
_query.Render(xmlWriter);
}
else
{
xmlWriter.WriteStartElement("Query");
RdlRender.AddLine(xmlWriter, "DataSourceName", "DataSource1");
RdlRender.AddLine(xmlWriter, "CommandType", "Text");
xmlWriter.WriteStartElement("CommandText");
xmlWriter.WriteString(GetQueryText());
xmlWriter.WriteEndElement(); //CommandText
RdlRender.AddLine(xmlWriter, "Timeout", "120");
// Each queryParameter must render itself
if (_parameterList == null || _parameterList.Count > 0 || _queryParameterList.Count > 0)
{
xmlWriter.WriteStartElement("QueryParameters");
foreach (string Item in _queryParameterList)
{
xmlWriter.WriteStartElement("QueryParameter");
xmlWriter.WriteAttributeString("Name", "@" + Item);
RdlRender.AddLine(xmlWriter, "Value", "=Parameters!" +
Item + ".Value");
xmlWriter.WriteEndElement(); // QueryParameter
}
xmlWriter.WriteEndElement(); // QueryParameters
}
xmlWriter.WriteEndElement(); // Query
}
}
/// <summary>
/// Makes object render itself in RDL to an XmlWriter object.
/// </summary>
/// <param name="xmlWriter">The XMLWriter to be rendered to.</param>
public void Render(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("DataSet");
xmlWriter.WriteAttributeString("Name", _name + "DataSet");
xmlWriter.WriteStartElement("Fields");
//TODO: Code Review Issue : 10/05/2005 - Casing for method variable.
//Also should use {} for loop statement for clarity
foreach (Field f in _fieldList)
{
f.Render(xmlWriter);
}
xmlWriter.WriteStartElement("Field");
xmlWriter.WriteAttributeString("Name", "GroupingLevel");
RdlRender.AddLine(xmlWriter, "DataField", "GroupingLevel");
xmlWriter.WriteEndElement(); // Field
xmlWriter.WriteEndElement(); // Fields
_queryWrapper.Render(xmlWriter);
xmlWriter.WriteEndElement(); // DataSet
}
/// <summary>
/// Renders this MatrixReport in RDL.
/// </summary>
/// <returns>A Byte array containing the raw RDL data.</returns>
public Byte[] Render()
{
//TODO: Code Review Issue 11/05/05: Add necessary comment on each code block and
//indent the code as in XML where possible to increase readability
// Done 24/05/2005
_xmlWriter.WriteStartDocument();
_xmlWriter.WriteStartElement("Report");
_xmlWriter.WriteAttributeString("xmlns",
"http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition");
RdlRender.AddLine(_xmlWriter, "Width", "1in");
RdlRender.AddLine(_xmlWriter, "PageWidth", "11.5in");
RdlRender.AddLine(_xmlWriter, "TopMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "BottomMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "LeftMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "RightMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "PageHeight", "7.9375in");
_xmlWriter.WriteStartElement("PageHeader");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddImage(_xmlWriter, "Image1", "2.59259cm", "3.8cm",
"1.0cm", "Embedded", "Esf", "AutoSize");
RdlRender.AddTextbox(_xmlWriter, "TitleTextbox", "DWP Small Systems Ad Hoc Reporting System",
_textboxStyle, "Left", "0.3cm", "5.0cm", "10cm", "true", "0.95cm", "2", "",
"", "", "", "", "", "", "");
RdlRender.AddTextbox(_xmlWriter, "PageHeader", "=Globals!ReportName",
_textboxStyle, "Left", "2.85714cm", "1.26984cm", "14.92063cm", "true",
"", "", "", "", "", "", "", "", "", "");
foreach (String _parameterName in _parameterList)
{
_parameterCount++;
RdlRender.AddTextbox(_xmlWriter, "Parameter" + _parameterCount.ToString(), _parameterName, _textboxStyle,
"Left", "2.85714cm", "1.26984cm", "14.92063cm", "true", "", "", "", "",
"", "", "", "", "", "");
}
_xmlWriter.WriteEndElement(); // ReportItems
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "Height", "1.375in");
_xmlWriter.WriteEndElement(); // PageHeader
_xmlWriter.WriteStartElement("Body");
RdlRender.AddLine(_xmlWriter, "Height", "5in");
_xmlWriter.WriteStartElement("ReportItems");
// Add table of keys to dynamic rows/columns
ReportingServicesStyle BoldBorderedTextBoxStyle = new ReportingServicesStyle(ReportingServicesStyle.TextBoxStyle.BoldBordered);
// "", "Solid", "Black", "", "", "", "", "10pt", "Bold", "", "", "", "");
ReportingServicesStyle PlainBorderedTextBoxStyle = new ReportingServicesStyle(ReportingServicesStyle.TextBoxStyle.PlainBordered);
// "", "Solid", "Black", "", "", "", "", "10pt", "", "", "", "", "");
// Table's header
_xmlWriter.WriteStartElement("Table");
_xmlWriter.WriteAttributeString("Name", "KeyTable");
RdlRender.AddLine(_xmlWriter, "Left", "1.26984cm");
RdlRender.AddLine(_xmlWriter, "DataSetName", _matrixDataSetName + "DataSet");
_xmlWriter.WriteStartElement("Style");
_xmlWriter.WriteStartElement("BorderStyle");
RdlRender.AddLine(_xmlWriter, "Default", PlainBorderedTextBoxStyle.BorderStyle);
_xmlWriter.WriteEndElement(); // BorderStyle
_xmlWriter.WriteEndElement(); // Style
_xmlWriter.WriteStartElement("Header");
_xmlWriter.WriteStartElement("TableRows");
_xmlWriter.WriteStartElement("TableRow");
RdlRender.AddLine(_xmlWriter, "Height", "1cm");
_xmlWriter.WriteStartElement("TableCells");
_xmlWriter.WriteStartElement("TableCell");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "KeyTableRows", "Dynamic Rows",
BoldBorderedTextBoxStyle, "Center", "", "", "", "", "", "", "", "", "",
"", "", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // TableCell
_xmlWriter.WriteStartElement("TableCell");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "KeyTableColumns", "Dynamic Columns",
BoldBorderedTextBoxStyle, "Center", "", "", "", "", "", "", "", "", "",
"", "", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // TableCell
_xmlWriter.WriteEndElement(); // TableCells
_xmlWriter.WriteEndElement(); // TableRow
// Add the names of the rows and columns to the table
for (int RowNum = 0;
RowNum < _columnTotalDataItemList.Count && RowNum < _rowTotalDataItemList.Count;
RowNum++)
{
string ColumnItem = _columnTotalDataItemList[RowNum] != null ?
(_columnTotalDataItemList[RowNum]).Caption : "";
string RowItem = _rowTotalDataItemList[RowNum] != null ?
(_rowTotalDataItemList[RowNum]).Caption : "";
_xmlWriter.WriteStartElement("TableRow");
RdlRender.AddLine(_xmlWriter, "Height", "0.8cm");
_xmlWriter.WriteStartElement("TableCells");
_xmlWriter.WriteStartElement("TableCell");
_xmlWriter.WriteStartElement("ReportItems");
// Column text box
RdlRender.AddTextbox(_xmlWriter, "KeyTableRow" + RowNum, RowItem,
PlainBorderedTextBoxStyle, "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // TableCell
_xmlWriter.WriteStartElement("TableCell");
_xmlWriter.WriteStartElement("ReportItems");
// Row text box
RdlRender.AddTextbox(_xmlWriter, "KeyTableColumn" + RowNum, ColumnItem,
PlainBorderedTextBoxStyle, "", "", "", "", "", "", "", "", "", "", "",
"", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // TableCell
_xmlWriter.WriteEndElement(); // TableCells
_xmlWriter.WriteEndElement(); // TableRow
}
_xmlWriter.WriteEndElement(); // TableRows
_xmlWriter.WriteEndElement(); // Header
_xmlWriter.WriteStartElement("TableColumns");
_xmlWriter.WriteStartElement("TableColumn");
RdlRender.AddLine(_xmlWriter, "Width", "5.0cm");
_xmlWriter.WriteEndElement(); // TableColumn
_xmlWriter.WriteStartElement("TableColumn");
RdlRender.AddLine(_xmlWriter, "Width", "5.0cm");
_xmlWriter.WriteEndElement(); // TableColumn
_xmlWriter.WriteEndElement(); // TableColumns
_xmlWriter.WriteEndElement(); // Table
// End of table of keys rendering
_xmlWriter.WriteStartElement("Matrix");
_xmlWriter.WriteAttributeString("Name", "Matrix1");
RdlRender.AddLine(_xmlWriter, "DataSetName", _matrixDataSetName + "DataSet");
RdlRender.AddLine(_xmlWriter, "Top", "2.5cm");
RdlRender.AddLine(_xmlWriter, "Left", ".5in");
RdlRender.AddLine(_xmlWriter, "Height", ".5in");
RdlRender.AddLine(_xmlWriter, "Width", "6in");
_xmlWriter.WriteStartElement("Corner");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "CornerTextbox", "", _cornerTextboxStyle,
"", "", "", "", "true", "", "", "", "", "", "", "", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // Corner
// Render MatrixRows
_xmlWriter.WriteStartElement("MatrixRows");
foreach (MatrixRow CurrentRow in _matrixRowList)
{
CurrentRow.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement(); // MatrixRows
_xmlWriter.WriteStartElement("MatrixColumns");
_xmlWriter.WriteStartElement("MatrixColumn");
RdlRender.AddLine(_xmlWriter, "Width", "3.25cm");
_xmlWriter.WriteEndElement(); // MatrixColumns
_xmlWriter.WriteEndElement(); // MatrixColumn
// Render ColumnGroupings
_xmlWriter.WriteStartElement("ColumnGroupings");
foreach (MatrixDynamicColumnGrouping CurrentColGroup in _dynamicColumnGroupingList)
{
CurrentColGroup.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement();
// Render RowGroupings
_xmlWriter.WriteStartElement("RowGroupings");
foreach (MatrixDynamicRowGrouping CurrentRowGroup in _dynamicRowGroupingList)
{
CurrentRowGroup.Render(_xmlWriter);
}
_xmlWriter.WriteStartElement("RowGrouping");
RdlRender.AddLine(_xmlWriter, "Width", "3.5cm");
_xmlWriter.WriteStartElement("StaticRows");
foreach (MatrixStaticRow CurrentRow in _matrixStaticRowList)
{
CurrentRow.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement(); // StaticRows
_xmlWriter.WriteEndElement(); // RowGrouping
_xmlWriter.WriteEndElement(); // RowGroupings
RdlRender.AddLine(_xmlWriter, "NoRows", Resource.GetString("RES_REPORT_NOROWSRETURNED"));
_xmlWriter.WriteEndElement(); // Matrix
_xmlWriter.WriteEndElement(); // ReportItems
RdlRender.AddLine(_xmlWriter, "ColumnSpacing", "1cm");
_xmlWriter.WriteEndElement(); // Body
// DataSources
_xmlWriter.WriteStartElement("DataSources");
_xmlWriter.WriteStartElement("DataSource");
_xmlWriter.WriteAttributeString("Name", "DataSource1");
// _xmlWriter.WriteStartElement("ConnectionProperties");
RdlRender.AddLine(_xmlWriter, "DataSourceReference", "/" + _dataSource);
// RdlRender.AddLine(_xmlWriter, "DataProvider", "SQL");
// RdlRender.AddLine(_xmlWriter, "ConnectString", _dbConnectionString);
// RdlRender.AddLine(_xmlWriter, "IntegratedSecurity", "false");
// RdlRender.AddLine(_xmlWriter, "Prompt", "false");
// _xmlWriter.WriteEndElement(); // ConnectionProperties
_xmlWriter.WriteEndElement(); // DataSource
_xmlWriter.WriteEndElement(); // DataSources
// Datasets
_xmlWriter.WriteStartElement("DataSets");
foreach (Dataset CurrentDataset in _datasetList)
{
CurrentDataset.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement();
// ReportParameters
if (_reportParameterList != null && _reportParameterList.Count > 0)
{
_xmlWriter.WriteStartElement("ReportParameters");
foreach (ReportParameter CurrentParameter in _reportParameterList)
{
CurrentParameter.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement();
}
// EmbeddedImages
_xmlWriter.WriteStartElement("EmbeddedImages");
_xmlWriter.WriteStartElement("EmbeddedImage");
_xmlWriter.WriteAttributeString("Name", "Esf");
RdlRender.AddLine(_xmlWriter, "MIMEType", "image/bmp");
_xmlWriter.WriteStartElement("ImageData");
// Image data
FileStream ImageStream = new FileStream(HttpContext.Current.Server.MapPath(
ConfigurationManager.AppSettings["SmallSystemsLogoImage"]), FileMode.Open, FileAccess.Read);
byte[] ImageByteArray = new Byte[ImageStream.Length];
ImageStream.Read(ImageByteArray, 0, (int)ImageStream.Length);
ImageStream.Close();
_xmlWriter.WriteBase64(ImageByteArray, 0, ImageByteArray.Length);
_xmlWriter.WriteEndElement(); // ImageData
_xmlWriter.WriteEndElement(); // EmbeddedImage
_xmlWriter.WriteEndElement(); // EmbeddedImages
// Report footer
_xmlWriter.WriteStartElement("PageFooter");
RdlRender.AddLine(_xmlWriter, "Height", "1.0cm");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "ReportDescriptionTextBox", _reportDescription,
BoldBorderedTextBoxStyle, "", "0.25cm", "1.0cm", "16.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
//Report Filters
foreach (ReportFilterBusinessObject _CurrentFilter in _filterItemList)
{
FilterCount++;
_Filter = "Filter" + FilterCount.ToString();
_FilterDescription = "Data Filter Applied : " + _CurrentFilter.DataItemCaption + " " + _CurrentFilter.Operand + " " + _CurrentFilter.FilterValue;
RdlRender.AddTextbox(_xmlWriter, _Filter, _FilterDescription, BoldBorderedTextBoxStyle, "", "0.25cm", "1.00cm", "16.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
}
_xmlWriter.WriteEndElement(); // Report
_xmlWriter.WriteEndDocument();
_xmlWriter.Flush();
_memoryStream.Close();
return(_memoryStream.GetBuffer());
//_stream.Close();
//return new byte[0];
}
//TODO: Code Review Issue 11/05/05: Give a more detailed summary.
// Done 24/05/2005
/// <summary>
/// Makes this object render itself as an RDL Report type to an XmlWriter instance.
/// It calls upon all objects immediately beneath it (TableHeader, TableGroup,
/// TableDetails, Datasets, ReportParameters) to render themselves also.
/// </summary>
/// <returns>A Byte array containing the raw RDL data.</returns>
public Byte[] Render()
{
// Styles for the textboxes
ReportingServicesStyle _textboxStyle14pt = new ReportingServicesStyle(
ReportingServicesStyle.TextBoxStyle.TabularReport14pt);
ReportingServicesStyle _textboxStyle10pt = new ReportingServicesStyle(
ReportingServicesStyle.TextBoxStyle.TabularReport10pt);
_xmlWriter.WriteStartDocument();
_xmlWriter.WriteStartElement("Report");
_xmlWriter.WriteAttributeString("xmlns",
"http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition");
RdlRender.AddLine(_xmlWriter, "Width", "1.0in");
RdlRender.AddLine(_xmlWriter, "PageWidth", "11.5in");
RdlRender.AddLine(_xmlWriter, "TopMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "BottomMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "LeftMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "RightMargin", "0.25in");
RdlRender.AddLine(_xmlWriter, "PageHeight", "7.9375in");
RdlRender.AddLine(_xmlWriter, "Language", "en-GB");
_xmlWriter.WriteStartElement("PageHeader");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "TitleTextbox", "DWP Small Systems Ad Hoc Reporting System",
_textboxStyle14pt, "Left", "0.3cm", "5.0cm", "10cm", "true", "0.95cm", "2", "",
"", "", "", "", "", "", "");
RdlRender.AddTextbox(_xmlWriter, "PageHeader", "=Globals!ReportName", _textboxStyle14pt,
"Left", "2.85714cm", "1.26984cm", "14.92063cm", "true", "1cm", "", "", "",
"", "", "", "", "", "");
RdlRender.AddImage(_xmlWriter, "Image1", "2.59259cm", "3.8cm",
"1.0cm", "Embedded", "Esf", "AutoSize");
int ParameterCount = 0;
int X = 0;
string ParameterHeight = "";
foreach (String _parameterName in _parameterList)
{
ParameterCount++;
X = ParameterCount;
X = X + 3;
ParameterHeight = X.ToString() + "cm";
RdlRender.AddTextbox(_xmlWriter, "Parameter" + ParameterCount.ToString(), _parameterName, _textboxStyle14pt,
"Left", ParameterHeight, "1.26984cm", "14.92063cm", "true", "1cm", "", "", "",
"", "", "", "", "", "");
}
_xmlWriter.WriteEndElement(); // ReportItems
X = ParameterCount;
X = X + 4;
ParameterHeight = X.ToString() + ".8cm";
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "Height", ParameterHeight);
_xmlWriter.WriteEndElement(); // PagHeader
_xmlWriter.WriteStartElement("Body");
RdlRender.AddLine(_xmlWriter, "Height", "5in");
_xmlWriter.WriteStartElement("ReportItems");
_xmlWriter.WriteStartElement("Table");
_xmlWriter.WriteAttributeString("Name", "Table1");
RdlRender.AddLine(_xmlWriter, "DataSetName", "TableDataSet");
RdlRender.AddLine(_xmlWriter, "Top", "0in");
RdlRender.AddLine(_xmlWriter, "Left", ".5in");
RdlRender.AddLine(_xmlWriter, "Height", "0in");
RdlRender.AddLine(_xmlWriter, "Width", "6in");
// TableHeader
_tableHeader.Render(_xmlWriter);
// TableGroups
if (_tableGroupList == null || _tableGroupList.Count > 0)
{
_xmlWriter.WriteStartElement("TableGroups");
foreach (TableGroup group in _tableGroupList)
{
group.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement(); // TableGroups
}
_xmlWriter.WriteStartElement("Style");
_xmlWriter.WriteEndElement();
// Write table columns
_xmlWriter.WriteStartElement("TableColumns");
for (int i = 0; i < _selectedDataItems.Count; i++)
{
_xmlWriter.WriteStartElement("TableColumn");
RdlRender.AddLine(_xmlWriter, "Width", "1.5in");
_xmlWriter.WriteEndElement();
}
_xmlWriter.WriteEndElement(); // TableColumns
// TableDetails
if (_isSummaryReport == false)
{
_tableDetails.Render(_xmlWriter);
}
RdlRender.AddLine(_xmlWriter, "NoRows", Resource.GetString("RES_REPORT_NOROWSRETURNED"));
// TableFooter
_tableFooter.Render(_xmlWriter);
_xmlWriter.WriteEndElement(); // Table
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // Body
// DataSources
_xmlWriter.WriteStartElement("DataSources");
_xmlWriter.WriteStartElement("DataSource");
_xmlWriter.WriteAttributeString("Name", "DataSource1");
RdlRender.AddLine(_xmlWriter, "DataSourceReference", "/" + _dataSource);
/*_xmlWriter.WriteStartElement("ConnectionProperties");
* RdlRender.AddLine( _xmlWriter, "DataProvider", "SQL");
* RdlRender.AddLine( _xmlWriter, "ConnectString", _dbConnectionString);
* RdlRender.AddLine( _xmlWriter, "IntegratedSecurity", "false");
* RdlRender.AddLine( _xmlWriter, "Prompt", "false");
* _xmlWriter.WriteEndElement(); // ConnectionProperties */
_xmlWriter.WriteEndElement(); // DataSource
_xmlWriter.WriteEndElement(); // DataSources
// Datasets
_xmlWriter.WriteStartElement("DataSets");
foreach (Dataset CurrentDataSet in _datasetList)
{
CurrentDataSet.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement();
// ReportParameters
if (_reportParametersList != null && _reportParametersList.Count > 0)
{
_xmlWriter.WriteStartElement("ReportParameters");
foreach (ReportParameter CurrentParameter in _reportParametersList)
{
CurrentParameter.Render(_xmlWriter);
}
_xmlWriter.WriteEndElement();
}
// EmbeddedImages
_xmlWriter.WriteStartElement("EmbeddedImages");
_xmlWriter.WriteStartElement("EmbeddedImage");
_xmlWriter.WriteAttributeString("Name", "Esf");
RdlRender.AddLine(_xmlWriter, "MIMEType", "image/bmp");
_xmlWriter.WriteStartElement("ImageData");
// Image data
FileStream ImageStream = new FileStream(
ConfigurationManager.AppSettings["SmallSystemsLogoImage"], FileMode.Open, FileAccess.Read);
byte[] ImageByteArray = new byte[ImageStream.Length];
ImageStream.Read(ImageByteArray, 0, (int)ImageStream.Length);
ImageStream.Close();
_xmlWriter.WriteBase64(ImageByteArray, 0, ImageByteArray.Length);
_xmlWriter.WriteEndElement(); // ImageData
_xmlWriter.WriteEndElement(); // EmbeddedImage
_xmlWriter.WriteEndElement(); // EmbeddedImages
// Report footer
_xmlWriter.WriteStartElement("PageFooter");
RdlRender.AddLine(_xmlWriter, "Height", "1.0cm");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox(_xmlWriter, "UserTextBox", "=User!UserID",
_textboxStyle10pt, "", "0.25cm", "1.0cm", "6.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
RdlRender.AddTextbox(_xmlWriter, "ExecutionTimeTextBox", "=Globals!ExecutionTime",
_textboxStyle10pt, "", "0.25cm", "7.00cm", "6.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
RdlRender.AddTextbox(_xmlWriter, "PageNumberTextBox", "=Globals!PageNumber",
_textboxStyle10pt, "", "0.25cm", "15.00cm", "3.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // PageFooter
_xmlWriter.WriteEndElement(); // Report
_xmlWriter.WriteEndDocument();
_xmlWriter.Flush();
_memoryStream.Close();
return(_memoryStream.GetBuffer());
//_stream.Close();
// return new byte[0];
}
/// <summary>
/// Makes this object render itself as an RDL Report type to an XmlWriter instance.
/// It calls upon all objects immediately beneath it (TableHeader, TableGroup,
/// TableDetails, Datasets, ReportParameters) to render themselves also.
/// </summary>
/// <returns>A Byte array containing the raw RDL data.</returns>
public Byte[] Render2010()
{
// Styles for the textboxes
ReportingServicesStyle _textboxStyle14pt = new ReportingServicesStyle(
ReportingServicesStyle.TextBoxStyle.TabularReport14pt);
ReportingServicesStyle _textboxStyle10pt = new ReportingServicesStyle(
ReportingServicesStyle.TextBoxStyle.TabularReport10pt);
_xmlWriter.WriteStartDocument();
_xmlWriter.WriteStartElement("Report");
_xmlWriter.WriteAttributeString("xmlns",
"http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition");
_xmlWriter.WriteAttributeString("xmlns:cl",
"http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition");
RdlRender.AddLine(_xmlWriter, "AutoRefresh", "0");
// DataSources
_xmlWriter.WriteStartElement("DataSources");
_xmlWriter.WriteStartElement("DataSource");
_xmlWriter.WriteAttributeString("Name", "DataSource1");
RdlRender.AddLine(_xmlWriter, "DataSourceReference", "/" + _dataSource);
/*_xmlWriter.WriteStartElement("ConnectionProperties");
* RdlRender.AddLine( _xmlWriter, "DataProvider", "SQL");
* RdlRender.AddLine( _xmlWriter, "ConnectString", _dbConnectionString);
* RdlRender.AddLine( _xmlWriter, "IntegratedSecurity", "false");
* RdlRender.AddLine( _xmlWriter, "Prompt", "false");
* _xmlWriter.WriteEndElement(); // ConnectionProperties */
_xmlWriter.WriteEndElement(); // DataSource
_xmlWriter.WriteEndElement(); // DataSources
// Datasets
_xmlWriter.WriteStartElement("DataSets");
foreach (Dataset CurrentDataSet in _datasetList)
{
CurrentDataSet.Render2010(_xmlWriter);
}
_xmlWriter.WriteEndElement(); //DataSets
//ReportSections
_xmlWriter.WriteStartElement("ReportSections");
//ReportSection
_xmlWriter.WriteStartElement("ReportSection");
_xmlWriter.WriteStartElement("Body");
RdlRender.AddLine(_xmlWriter, "Height", "5in");
_xmlWriter.WriteStartElement("ReportItems");
_xmlWriter.WriteStartElement("Tablix");
_xmlWriter.WriteAttributeString("Name", "Table1");
RdlRender.AddLine(_xmlWriter, "DataSetName", "TableDataSet");
RdlRender.AddLine(_xmlWriter, "NoRowsMessage", Resource.GetString("RES_REPORT_NOROWSRETURNED"));
RdlRender.AddLine(_xmlWriter, "Top", "0in");
RdlRender.AddLine(_xmlWriter, "Left", ".5in");
RdlRender.AddLine(_xmlWriter, "Height", "0in");
RdlRender.AddLine(_xmlWriter, "Width", "6in");
_xmlWriter.WriteStartElement("TablixBody");
// Write table columns
_xmlWriter.WriteStartElement("TablixColumns");
for (int i = 0; i < _fieldDataItems.Count; i++)
{
_xmlWriter.WriteStartElement("TablixColumn");
RdlRender.AddLine(_xmlWriter, "Width", "1.5in");
_xmlWriter.WriteEndElement(); // TablixColumn
}
_xmlWriter.WriteEndElement(); // TablixColumns
// Write table rows
_xmlWriter.WriteStartElement("TablixRows");
// TableHeader
_tableHeader.Render2010(_xmlWriter);
// TableGroups
if (_tableGroupList != null && _tableGroupList.Count > 0)
{
foreach (TableGroup group in _tableGroupList)
{
group.Render2010(_xmlWriter);
}
}
// TableDetails
if (_isSummaryReport == false)
{
_tableDetails.Render2010(_xmlWriter);
}
// TableFooter
_tableFooter.Render2010(_xmlWriter);
_xmlWriter.WriteEndElement(); // TablixRows
_xmlWriter.WriteEndElement(); // TablixBody
_xmlWriter.WriteStartElement("TablixColumnHierarchy");
_xmlWriter.WriteStartElement("TablixMembers");
for (int i = 0; i < _fieldDataItems.Count; i++)
{
_xmlWriter.WriteStartElement("TablixMember");
_xmlWriter.WriteEndElement(); // TablixMember
}
_xmlWriter.WriteEndElement(); // TablixMembers
_xmlWriter.WriteEndElement(); // TablixColumnHierarchy
_xmlWriter.WriteStartElement("TablixRowHierarchy");
_xmlWriter.WriteStartElement("TablixMembers");
//Add Header row member
_xmlWriter.WriteStartElement("TablixMember");
RdlRender.AddLine(_xmlWriter, "KeepWithGroup", "After");
RdlRender.AddLine(_xmlWriter, "FixedData", "true");
RdlRender.AddLine(_xmlWriter, "RepeatOnNewPage", "true");
RdlRender.AddLine(_xmlWriter, "KeepTogether", "true");
_xmlWriter.WriteEndElement(); // TablixMember
//Add Group and details hierarchy members
if (_tableGroupList != null && _tableGroupList.Count > 0)
{
for (int i = 0; i < _tableGroupList.Count; i++)//
{
_xmlWriter.WriteStartElement("TablixMember");
_xmlWriter.WriteStartElement("Group");
_xmlWriter.WriteAttributeString("Name", "Grouping" + _tableGroupList[i].Name);
if (_tableGroupList[i].IsDataMapDisplayedGroup) // check if data map neds displaying
{
RdlRender.AddLine(_xmlWriter, "DocumentMapLabel", "=Fields!" + _tableGroupList[i].Name + ".Value");
}
if (_isPageOnFirstItem && i == 0)
{
_xmlWriter.WriteStartElement("PageBreak");
RdlRender.AddLine(_xmlWriter, "BreakLocation", "Between");
_xmlWriter.WriteEndElement(); // PageBreak
}
_xmlWriter.WriteStartElement("GroupExpressions");
RdlRender.AddLine(_xmlWriter, "GroupExpression", "=Fields!" + _tableGroupList[i].Name + ".Value");
_xmlWriter.WriteEndElement(); // GroupExpressions
_xmlWriter.WriteEndElement(); // Group
_xmlWriter.WriteStartElement("SortExpressions");
_xmlWriter.WriteStartElement("SortExpression");
RdlRender.AddLine(_xmlWriter, "Value", "=Fields!" + _tableGroupList[i].Name + ".Value");
//RdlRender.AddLine(xmlWriter, "Direction", "Ascending");
_xmlWriter.WriteEndElement(); // SortExpression
_xmlWriter.WriteEndElement(); // SortExpressions
_xmlWriter.WriteStartElement("TablixMembers");
_xmlWriter.WriteStartElement("TablixMember");
if (i > 0 && _isDrillDown)
{
_xmlWriter.WriteStartElement("Visibility");
RdlRender.AddLine(_xmlWriter, "Hidden", "true");
RdlRender.AddLine(_xmlWriter, "ToggleItem", "Group" + _tableGroupList[i - 1].Name);
_xmlWriter.WriteEndElement(); // Visibility
}
RdlRender.AddLine(_xmlWriter, "KeepWithGroup", "After");
RdlRender.AddLine(_xmlWriter, "KeepTogether", "true");
_xmlWriter.WriteEndElement(); // TablixMember
}
}
// TableDetails
if (_isSummaryReport == false)
{
_xmlWriter.WriteStartElement("TablixMember");
_xmlWriter.WriteStartElement("Group");
_xmlWriter.WriteAttributeString("Name", "Table1_Details_Group");
//if (_isDataMapDisplayedGroup == true) // check if data map neds displaying
//{
// RdlRender.AddLine(xmlWriter, "Label", "=Fields!" + _name + ".Value");
//}
RdlRender.AddLine(_xmlWriter, "DataElementName", "Detail");
_xmlWriter.WriteEndElement(); // Group
_xmlWriter.WriteStartElement("TablixMembers");
_xmlWriter.WriteStartElement("TablixMember");
if (_isDrillDown)
{
_xmlWriter.WriteStartElement("Visibility");
RdlRender.AddLine(_xmlWriter, "Hidden", "true");
RdlRender.AddLine(_xmlWriter, "ToggleItem", "Group" + _tableGroupList[_tableGroupList.Count - 1].Name);
_xmlWriter.WriteEndElement(); // Visibility
}
_xmlWriter.WriteEndElement(); // TablixMember
_xmlWriter.WriteEndElement(); // TablixMembers
RdlRender.AddLine(_xmlWriter, "DataElementName", "Detail_Collection");
RdlRender.AddLine(_xmlWriter, "DataElementOutput", "Output");
RdlRender.AddLine(_xmlWriter, "KeepTogether", "true");
_xmlWriter.WriteEndElement(); // TablixMember
}
//Close down the group hierarchies
if (_tableGroupList != null && _tableGroupList.Count > 0)
{
for (int i = 0; i < _tableGroupList.Count; i++) //
{
_xmlWriter.WriteEndElement(); // TablixMembers
_xmlWriter.WriteEndElement(); // TablixMember
}
}
//Add Footer report name member
_xmlWriter.WriteStartElement("TablixMember");
RdlRender.AddLine(_xmlWriter, "KeepWithGroup", "Before");
RdlRender.AddLine(_xmlWriter, "RepeatOnNewPage", "true");
RdlRender.AddLine(_xmlWriter, "KeepTogether", "true");
_xmlWriter.WriteEndElement(); // TablixMember
//Add Footer filter selections
for (int i = 0; i < _noOfFilters; i++)
{
_xmlWriter.WriteStartElement("TablixMember");
RdlRender.AddLine(_xmlWriter, "KeepWithGroup", "Before");
RdlRender.AddLine(_xmlWriter, "RepeatOnNewPage", "true");
RdlRender.AddLine(_xmlWriter, "KeepTogether", "true");
_xmlWriter.WriteEndElement(); // TablixMember
}
_xmlWriter.WriteEndElement(); // TablixMembers
_xmlWriter.WriteEndElement(); // TablixRowHierarchy
_xmlWriter.WriteStartElement("Style");
_xmlWriter.WriteEndElement();
_xmlWriter.WriteEndElement(); // Tablix
foreach (Chart currentChart in _chartList)
{
currentChart.Render2010(_xmlWriter);
}
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // Body
RdlRender.AddLine(_xmlWriter, "Width", (_selectedDataItems.Count * 1.5 < 11.5)?"11.5in":(_selectedDataItems.Count * 1.5).ToString() + "in");
_xmlWriter.WriteStartElement("Page");
_xmlWriter.WriteStartElement("PageHeader");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox2010(_xmlWriter, "TitleTextbox", "DWP Small Systems Ad Hoc Reporting System",
_textboxStyle14pt, "Left", "0.3cm", "2in", "6in", "true", "0.95cm", "2", "",
"", "", "", "", "", "", "");
RdlRender.AddTextbox2010(_xmlWriter, "PageHeader", "=Globals!ReportName", _textboxStyle14pt,
"Left", "2.85714cm", "0.5in", "6in", "true", "1cm", "", "", "",
"", "", "", "", "", "");
RdlRender.AddImage2010(_xmlWriter, "Image1", "2.59259cm", "1.5in",
"0.5in", "Embedded", "Esf", "AutoSize");
int ParameterCount = 0;
int X = 0;
string ParameterHeight = "";
foreach (String _parameterName in _parameterList)
{
ParameterCount++;
X = ParameterCount;
X = X + 3;
ParameterHeight = X.ToString() + "cm";
RdlRender.AddTextbox2010(_xmlWriter, "Parameter" + ParameterCount.ToString(), _parameterName, _textboxStyle14pt,
"Left", ParameterHeight, "0.5in", "6in", "true", "1cm", "", "", "",
"", "", "", "", "", "");
}
_xmlWriter.WriteEndElement(); // ReportItems
X = ParameterCount;
X = X + 4;
ParameterHeight = X.ToString() + ".8cm";
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "Height", ParameterHeight);
_xmlWriter.WriteEndElement(); // PagHeader
// Report footer
_xmlWriter.WriteStartElement("PageFooter");
RdlRender.AddLine(_xmlWriter, "Height", "1.0cm");
RdlRender.AddLine(_xmlWriter, "PrintOnFirstPage", "true");
RdlRender.AddLine(_xmlWriter, "PrintOnLastPage", "true");
_xmlWriter.WriteStartElement("ReportItems");
RdlRender.AddTextbox2010(_xmlWriter, "UserTextBox", "=Parameters!ReportUserName.Value",
_textboxStyle10pt, "", "0.25cm", "1.0cm", "6.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
RdlRender.AddTextbox2010(_xmlWriter, "ExecutionTimeTextBox", "=Globals!ExecutionTime",
_textboxStyle10pt, "", "0.25cm", "7.00cm", "6.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
RdlRender.AddTextbox2010(_xmlWriter, "PageNumberTextBox", "=Globals!PageNumber",
_textboxStyle10pt, "", "0.25cm", "15.00cm", "3.00cm", "true", "0.5cm", "1",
"", "", "", "", "", "", "", "");
_xmlWriter.WriteEndElement(); // ReportItems
_xmlWriter.WriteEndElement(); // PageFooter
_xmlWriter.WriteEndElement(); // Page
_xmlWriter.WriteEndElement(); // RepoetSection
_xmlWriter.WriteEndElement(); // ReportSections
//Add a report parameter for user id
_xmlWriter.WriteStartElement("ReportParameters");
_xmlWriter.WriteStartElement("ReportParameter");
_xmlWriter.WriteAttributeString("Name", "ReportUserName");
// Render relevant data type
RdlRender.AddLine(_xmlWriter, "DataType", "String");
RdlRender.AddLine(_xmlWriter, "Prompt", "User Name");
RdlRender.AddLine(_xmlWriter, "Hidden", "true");
_xmlWriter.WriteEndElement(); // ReportParameter
_xmlWriter.WriteStartElement("ReportParameter");
_xmlWriter.WriteAttributeString("Name", "ReportUserCode");
// Render relevant data type
RdlRender.AddLine(_xmlWriter, "DataType", "String");
RdlRender.AddLine(_xmlWriter, "Prompt", "User Name");
RdlRender.AddLine(_xmlWriter, "Hidden", "true");
_xmlWriter.WriteEndElement(); // ReportParameter
// ReportParameters
if (_reportParametersList != null && _reportParametersList.Count > 0)
{
foreach (ReportParameter CurrentParameter in _reportParametersList)
{
CurrentParameter.Render2010(_xmlWriter);
}
}
_xmlWriter.WriteEndElement();
// EmbeddedImages
_xmlWriter.WriteStartElement("EmbeddedImages");
_xmlWriter.WriteStartElement("EmbeddedImage");
_xmlWriter.WriteAttributeString("Name", "Esf");
RdlRender.AddLine(_xmlWriter, "MIMEType", "image/bmp");
_xmlWriter.WriteStartElement("ImageData");
// Image data
FileStream ImageStream = new FileStream(
HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["SmallSystemsLogoImage"]), FileMode.Open, FileAccess.Read);
byte[] ImageByteArray = new byte[ImageStream.Length];
ImageStream.Read(ImageByteArray, 0, (int)ImageStream.Length);
ImageStream.Close();
_xmlWriter.WriteBase64(ImageByteArray, 0, ImageByteArray.Length);
_xmlWriter.WriteEndElement(); // ImageData
_xmlWriter.WriteEndElement(); // EmbeddedImage
_xmlWriter.WriteEndElement(); // EmbeddedImages
RdlRender.AddLine(_xmlWriter, "ConsumeContainerWhitespace", "true");
_xmlWriter.WriteEndElement(); // Report
_xmlWriter.WriteEndDocument();
//****TESTING*************
// _xmlWriter.Flush();
// XmlDocument doc = RdlRender.CreateXmlDocument(_memoryStream);
//*****************/
_xmlWriter.Flush();
_memoryStream.Close();
return(_memoryStream.ToArray());// GetBuffer();
//_stream.Close();
// return new byte[0];
}
public void Render2010(XmlWriter xmlWriter)
{
xmlWriter.WriteStartElement("Chart");
xmlWriter.WriteAttributeString("Name", "Chart" + _sortOrder.ToString());
xmlWriter.WriteStartElement("ChartCategoryHierarchy");
xmlWriter.WriteStartElement("ChartMembers");
xmlWriter.WriteStartElement("ChartMember");
xmlWriter.WriteStartElement("Group");
xmlWriter.WriteAttributeString("Name", "Chart" + _sortOrder.ToString() + "_CategoryGroup");
xmlWriter.WriteStartElement("GroupExpressions");
string categoryTableName = CurrentDataModel.DataTables.Single(x => x.Code == _categoryDataItem.DataTableCode).Name; // DataAccessUtilities.RepositoryLocator<IDataTableRepository>().GetByCode(_categoryDataItem.DataTableCode).Name;
RdlRender.AddLine(xmlWriter, "GroupExpression", "=Fields!" + _categoryName + ".Value");
xmlWriter.WriteEndElement(); //GroupExpressions
xmlWriter.WriteEndElement(); //Group
xmlWriter.WriteStartElement("SortExpressions");
xmlWriter.WriteStartElement("SortExpression");
RdlRender.AddLine(xmlWriter, "Value", "=Fields!" + categoryTableName + _categoryDataItem.Name + ".Value");
xmlWriter.WriteEndElement(); //SortExpression
xmlWriter.WriteEndElement(); //SortExpressions
RdlRender.AddLine(xmlWriter, "Label", "=Fields!" + categoryTableName + _categoryDataItem.Name + ".Value");
xmlWriter.WriteEndElement(); //ChartMember
xmlWriter.WriteEndElement(); //ChartMembers
xmlWriter.WriteEndElement(); //ChartCategoryHierarchy
xmlWriter.WriteStartElement("ChartSeriesHierarchy");
xmlWriter.WriteStartElement("ChartMembers");
foreach (ChartSeries seriesItem in _seriesItems)
{
xmlWriter.WriteStartElement("ChartMember");
RdlRender.AddLine(xmlWriter, "Label", seriesItem.SeriesDataItem.Caption);
xmlWriter.WriteEndElement();//ChartMember
}
xmlWriter.WriteEndElement(); //ChartMembers
xmlWriter.WriteEndElement(); //ChartSeriesHierarchy
xmlWriter.WriteStartElement("ChartData");
xmlWriter.WriteStartElement("ChartSeriesCollection");
foreach (ChartSeries seriesItem in _seriesItems)
{
seriesItem.Render2010(xmlWriter);
}
xmlWriter.WriteEndElement(); //ChartSeriesCollection
xmlWriter.WriteEndElement(); //ChartData
xmlWriter.WriteStartElement("ChartAreas");
xmlWriter.WriteStartElement("ChartArea");
xmlWriter.WriteAttributeString("Name", "Default");
xmlWriter.WriteStartElement("ChartCategoryAxes");
xmlWriter.WriteStartElement("ChartAxis");
xmlWriter.WriteAttributeString("Name", _categoryName);
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
xmlWriter.WriteEndElement();//Style
xmlWriter.WriteStartElement("ChartAxisTitle");
RdlRender.AddLine(xmlWriter, "Caption", _categoryDataItem.Caption);
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartAxisTitle
RdlRender.AddLine(xmlWriter, "Interval", "1");
RdlRender.AddLine(xmlWriter, "IntervalType", "Default");
xmlWriter.WriteStartElement("ChartMajorGridLines");
RdlRender.AddLine(xmlWriter, "Enabled", "False");
xmlWriter.WriteStartElement("Style");
xmlWriter.WriteStartElement("Border");
RdlRender.AddLine(xmlWriter, "Color", "Gainsboro");
xmlWriter.WriteEndElement(); //Border
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartMajorGridLines
xmlWriter.WriteStartElement("ChartMinorGridLines");
RdlRender.AddLine(xmlWriter, "Enabled", "False");
xmlWriter.WriteStartElement("Style");
xmlWriter.WriteStartElement("Border");
RdlRender.AddLine(xmlWriter, "Color", "Gainsboro");
RdlRender.AddLine(xmlWriter, "Style", "Dotted");
xmlWriter.WriteEndElement(); //Border
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartMinorGridLines
xmlWriter.WriteStartElement("ChartMajorTickMarks");
RdlRender.AddLine(xmlWriter, "IntervalType", "Auto");
xmlWriter.WriteEndElement();//ChartMajorTickMarks
xmlWriter.WriteStartElement("ChartMinorTickMarks");
RdlRender.AddLine(xmlWriter, "Length", "0.5");
xmlWriter.WriteEndElement();//ChartMinorTickMarks
RdlRender.AddLine(xmlWriter, "CrossAt", "NaN");
RdlRender.AddLine(xmlWriter, "Minimum", "NaN");
RdlRender.AddLine(xmlWriter, "Maximum", "NaN");
RdlRender.AddLine(xmlWriter, "Angle", "-90");
RdlRender.AddLine(xmlWriter, "LabelsAutoFitDisabled", "true");
xmlWriter.WriteStartElement("ChartAxisScaleBreak");
RdlRender.AddLine(xmlWriter, "Style", "");
xmlWriter.WriteEndElement(); //ChartAxisScaleBreak
xmlWriter.WriteEndElement(); //ChartAxis
xmlWriter.WriteEndElement(); //ChartCategoryAxes
xmlWriter.WriteStartElement("ChartValueAxes");
foreach (ChartSeries currentSeries in _seriesItems)
{
currentSeries.RenderAxes2010(xmlWriter);
}
xmlWriter.WriteEndElement();//ChartValueAxes
xmlWriter.WriteStartElement("ChartThreeDProperties");
RdlRender.AddLine(xmlWriter, "Enabled", "true");
RdlRender.AddLine(xmlWriter, "ProjectionMode", "Perspective");
RdlRender.AddLine(xmlWriter, "Rotation", "7");
RdlRender.AddLine(xmlWriter, "Inclination", "15");
RdlRender.AddLine(xmlWriter, "DepthRatio", "200");
RdlRender.AddLine(xmlWriter, "WallThickness", "2");
RdlRender.AddLine(xmlWriter, "Clustered", "true");
xmlWriter.WriteEndElement();//ChartThreeDProperties
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundColor", "White");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "BackgroundGradientEndColor", "#00ffffff");
RdlRender.AddLine(xmlWriter, "BackgroundHatchType", "None");
RdlRender.AddLine(xmlWriter, "ShadowOffset", "0pt");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartArea
xmlWriter.WriteEndElement(); //ChartAreas
xmlWriter.WriteStartElement("ChartLegends");
xmlWriter.WriteStartElement("ChartLegend");
xmlWriter.WriteAttributeString("Name", "Default");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundColor", "#ffffff");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
xmlWriter.WriteEndElement();//Style
xmlWriter.WriteStartElement("ChartLegendTitle");
xmlWriter.WriteElementString("Caption", null);
//RdlRender.AddLine(xmlWriter,"Caption","");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "FontSize", "8pt");
RdlRender.AddLine(xmlWriter, "FontWeight", "Bold");
RdlRender.AddLine(xmlWriter, "TextAlign", "Center");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartLegendTitle
RdlRender.AddLine(xmlWriter, "HeaderSeparatorColor", "#cccccc");
RdlRender.AddLine(xmlWriter, "ColumnSeparatorColor", "#cccccc");
xmlWriter.WriteEndElement(); //ChartLegend
xmlWriter.WriteEndElement(); //ChartLegends
xmlWriter.WriteStartElement("ChartTitles");
xmlWriter.WriteStartElement("ChartTitle");
xmlWriter.WriteAttributeString("Name", "Default");
RdlRender.AddLine(xmlWriter, "Caption", _title);
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "FontWeight", "Bold");
RdlRender.AddLine(xmlWriter, "TextAlign", "General");
RdlRender.AddLine(xmlWriter, "VerticalAlign", "Top");
RdlRender.AddLine(xmlWriter, "Color", "#eaf5f7");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartTitle
xmlWriter.WriteEndElement(); //ChartTitles
RdlRender.AddLine(xmlWriter, "Palette", "BrightPastel");
xmlWriter.WriteStartElement("ChartBorderSkin");
RdlRender.AddLine(xmlWriter, "ChartBorderSkinType", "FrameTitle1");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundColor", "#005db3");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "Color", "#eaf5f7");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartBorderSkin
xmlWriter.WriteStartElement("ChartNoDataMessage");
xmlWriter.WriteAttributeString("Name", "NoDataMessage");
RdlRender.AddLine(xmlWriter, "Caption", "No Data Available");
xmlWriter.WriteStartElement("Style");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "TextAlign", "General");
RdlRender.AddLine(xmlWriter, "VerticalAlign", "Top");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //ChartNoDataMessage
RdlRender.AddLine(xmlWriter, "DataSetName", _datasetName);
xmlWriter.WriteStartElement("PageBreak");
RdlRender.AddLine(xmlWriter, "BreakLocation", "Start");
xmlWriter.WriteEndElement(); //PageBreak
RdlRender.AddLine(xmlWriter, "Top", (1.73825 + (8 * _sortOrder)).ToString() + "in"); // To make charts go below each other "1.73825in");
RdlRender.AddLine(xmlWriter, "Left", "0.5in");
RdlRender.AddLine(xmlWriter, "Height", "7.46875in");
RdlRender.AddLine(xmlWriter, "Width", "7.2492in");
RdlRender.AddLine(xmlWriter, "ZIndex", "1");
xmlWriter.WriteStartElement("Style");
xmlWriter.WriteStartElement("Border");
RdlRender.AddLine(xmlWriter, "Color", "LightGrey");
RdlRender.AddLine(xmlWriter, "Style", "Solid");
xmlWriter.WriteEndElement();//Border
RdlRender.AddLine(xmlWriter, "BackgroundColor", "#ffffff");
RdlRender.AddLine(xmlWriter, "BackgroundGradientType", "None");
RdlRender.AddLine(xmlWriter, "BackgroundGradientEndColor", "#ffffff");
xmlWriter.WriteEndElement(); //Style
xmlWriter.WriteEndElement(); //Chart
}
