/// <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];
}