ServiceManager.Report.Compliance.ControlManagement.COReport.ReportRdl (ReportResource)

Element properties:

TypeReportResource
File NameServiceManager.Report.GRC.ControlManagement.COReport.rdl
AccessibilityPublic

Source Code:

<ReportResource ID="ServiceManager.Report.Compliance.ControlManagement.COReport.ReportRdl" Accessibility="Public" FileName="ServiceManager.Report.GRC.ControlManagement.COReport.rdl" MIMEType="application/octet-stream"/>

File Content: ServiceManager.Report.GRC.ControlManagement.COReport.rdl

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
<DataSources>
<DataSource Name="DWDataMart">
<DataSourceReference>DWDataMart</DataSourceReference>
<rd:DataSourceID>d4ffb4f6-bd0a-4358-822f-0b33ad3cef2b</rd:DataSourceID>
<rd:SecurityType>None</rd:SecurityType>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="COStatus_Table">
<Fields>
<Field Name="COStatusId">
<DataField>COSTatusId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="HeaderValue">
<DataField>HeaderValue</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="COStatusValue">
<DataField>COStatusValue</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DWDataMart</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ServiceManager_Report_GRC_ControlManagement_SP_GetCOCountByStatus</CommandText>
<QueryParameters>
<QueryParameter Name="@ADValue">
<Value>=Parameters!ADValue.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@OwnedBy">
<Value>=Parameters!OwnedBy.Value</Value>
</QueryParameter>
<QueryParameter Name="@AssignedTo">
<Value>=Parameters!AssignedTo.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProgramId">
<Value>=Parameters!ProgramId.Value</Value>
</QueryParameter>
<QueryParameter Name="@ADCategoryId">
<Value>=Parameters!ADCategoryId.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Body><Script>
<ReportItems>
<Tablix Name="Tablix1">
<TablixBody>
<TablixColumns>
<TablixColumn>
<Width>6.75in</Width>
</TablixColumn>
</TablixColumns>
<TablixRows>
<TablixRow>
<Height>0.25781in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle6">
<ReportItems>
<Image Name="Image26">
<Source>Embedded</Source>
<Value>CO</Value>
<Sizing>FitProportional</Sizing>
<Top>0.02156in</Top>
<Left>0.34715in</Left>
<Height>0.19792in</Height>
<Width>0.15625in</Width>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Image>
<Textbox Name="HeaderValue2">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!COStatusId.Value</Value>
<Style></Style>
<Color>White</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>HeaderValue</rd:DefaultName>
<Left>0.10063in</Left>
<Height>0.25781in</Height>
<Width>0.21875in</Width>
<ZIndex>1</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Textbox>
<Textbox Name="HeaderValue">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=Fields!HeaderValue.Value</Value>
<Style /></Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>HeaderValue</rd:DefaultName>
<Left>0.57285in</Left>
<Height>0.25in</Height>
<Width>4.57292in</Width>
<ZIndex>2</ZIndex>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
<TablixRow>
<Height>0.25in</Height>
<TablixCells>
<TablixCell>
<CellContents>
<Rectangle Name="Rectangle2">
<ReportItems>
<Subreport Name="COReportsByStatus2">
<ReportName>ServiceManager.Report.Compliance.ControlManagement.CODetailReport</ReportName>
<Parameters>
<Parameter Name="StatusId">
<Value>=Fields!COStatusId.Value</Value>
</Parameter>
<Parameter Name="StartDate">
<Value>=Parameters!StartDate.Value</Value>
</Parameter>
<Parameter Name="EndDate">
<Value>=Parameters!EndDate.Value</Value>
</Parameter>
<Parameter Name="ProgramId">
<Value>=Parameters!ProgramId.Value</Value>
</Parameter>
<Parameter Name="ADValue">
<Value>=Parameters!ADValue.Value</Value>
</Parameter>
<Parameter Name="OwnedBy">
<Value>=Parameters!OwnedBy.Value</Value>
</Parameter>
<Parameter Name="AssignedTo">
<Value>=Parameters!AssignedTo.Value</Value>
</Parameter>
<Parameter Name="ADCategoryId">
<Value>=Parameters!ADCategoryId.Value</Value>
</Parameter>
</Parameters>
<Left>0.46875in</Left>
<Height>0.25in</Height>
<Width>6.28125in</Width>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Subreport>
</ReportItems>
<KeepTogether>true</KeepTogether>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Rectangle>
</CellContents>
</TablixCell>
</TablixCells>
</TablixRow>
</TablixRows>
</TablixBody>
<TablixColumnHierarchy>
<TablixMembers>
<TablixMember />
</TablixMembers>
</TablixColumnHierarchy>
<TablixRowHierarchy>
<TablixMembers>
<TablixMember>
<Group Name="Details1" />
<TablixMembers>
<TablixMember />
<TablixMember>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>HeaderValue2</ToggleItem>
</Visibility>
</TablixMember>
</TablixMembers>
</TablixMember>
</TablixMembers>
</TablixRowHierarchy>
<DataSetName>COStatus_Table</DataSetName>
<Height>0.50781in</Height>
<Width>6.75in</Width>
<Style></Style>
<Border>
<Style></Style>None</Style>
</Border>
</Style>
</Tablix>
</ReportItems>
<Height>0.50781in</Height>
<Style /></Style>
</Script></Body>
<ReportParameters>
<ReportParameter Name="ProgramId">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Program</Prompt>
</ReportParameter>
<ReportParameter Name="OwnedBy">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Owned By</Prompt>
</ReportParameter>
<ReportParameter Name="AssignedTo">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Assigned To</Prompt>
</ReportParameter>
<ReportParameter Name="ADCategoryId">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>-1</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Authority Document Category</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="ADValue">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Authority Document Title</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=DateAdd("d", -7, Today())</Value>
</Values>
</DefaultValue>
<Prompt>StartDate</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=DateAdd("d", +1, Today())</Value>
</Values>
</DefaultValue>
<Prompt>End Date</Prompt>
</ReportParameter>
</ReportParameters>
<Code><Script>Public Function GetRowCount()as String

Return "Row Count"

End Function</Script></Code>
<Width>6.75in</Width>
<Page>
<LeftMargin>1in</LeftMargin>
<RightMargin>1in</RightMargin>
<TopMargin>1in</TopMargin>
<BottomMargin>1in</BottomMargin>
<Style /></Style>
</Page>
<EmbeddedImages>
<EmbeddedImage Name="CO">
<MIMEType>image/png</MIMEType>
<ImageData>iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA5dJREFUeNo8Ul1MHFUYPffOnZndmdld2e7CAluwW2oKDSo/UhMSflIjsT+pEaNJTZum0USTRvTJaNToi/HFZ9MnrTwoMcaflFbUUlJbbakRaCHUlopgF9jN0oVlZ2dnZu9cpyZ6Hr6n75x83zmHPHl6CD8sXUMyXcLBT2/AlAQSQT2VkrTDmpAez+ikalnl6Sy3f744kBq9l9AzEvfwH5gg/iQEnifgCaG36FVvtGrRE+lGo/5Mi46p7So2FALXrRzn3LtDhBjxCD6kAlv/CjAB3FdkutLXHU68V91Q0/vdEzFMNGtIcxdumYNVPDiKDFt4O3Wz8pbk8L0FQ3pa9lCUjqkxRL64zFJ9uz+nXY3dl3qiWG4JQ7cFgq6AC4G8TJBad/HSdBknfyvj0LyV8m6vIXIzM87Iegk71t3nDE3rSvckQXMlxCwbpkzBJQUlG3h2Yh1HrluIVQgcRmAJCc+v4bULmewwcyVBGyIPnDB1FSGvDAuyvyT5vshgeRMnv1xD7808ij4xRwG5QuEQCsPQtToePcC69kzvyN+IPCwbcQjdgF1ewmFyG5KUgzNZgXQriottfUg2xMFiMdCqOLT6BJZXNiF/8HoP21i2HmK0KhyrbsYjySakysdRS1eB+neBIRMLyif4dX4fznccAzQNEqXoqgmBsAw8RW1nVoFFqhRFUU/9iG1/jKK2NwO4KqB2AJFONB36GI9NjWFs/inQeNS/DBjfLKKGcDQFtCBt7+GznKIQn1mCNjV7P1j/f78od44As/1+xiVcGhiEGarx43ZBKxxW0cLfDpCDtERpfXC+wKw5R5ZAExzFHIEQvgj17ee3UHSimCm3gromuE/2PA9lTmAKGSss8rVUiR4QhYW/WDXowWvJ3SReV0GokgPxi7No
JvH+76/gl2wrApIDQgm2ZAPdU9+gdmkGFxr3DrNC2YC5ven0Wcd+9dH2o3vGFuZAnSs4Zw9gsbwTRS+MgGyiKAJ+1Rn2++RnJj/DVxull0v9Q98zSbiwa+rqm9vaHjRkFx9NUyyqLyKoSFAUAaLaKFANic0sXvBN7vjzMs5lM++sVfgpzdoE45wjGokMNiST+vjZ0W+Dd7m7LS4POqFqEvQU1BZX0Lk6h+67V2DmV5ZHCoW3c5Y9rAZU+G6BEUL6jVDozcmrV6+b3Du6K2xudWZG9kWyG/vdNewKFbbCRsBK/5T3Ju5xfkYIrPot/x//CDAAVvOKgefHBCoAAAAASUVORK5CYII=</ImageData>
</EmbeddedImage>
</EmbeddedImages>
<rd:ReportID>a3fd9544-7508-4ba9-8ebc-b469293c0642</rd:ReportID>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>