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

Element properties:

Type	ReportResource
File Name	ServiceManager.Report.GRC.ControlManagement.CAReport.rdl
Accessibility	Public

Source Code:

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

File Content: ServiceManager.Report.GRC.ControlManagement.CAReport.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>9d6bcae5-dc4d-45d8-8ac0-56b7d77b4de7</rd:DataSourceID>


      <rd:SecurityType>None</rd:SecurityType>


    </DataSource>


  </DataSources>


  <DataSets>


    <DataSet Name="CAStatus_Table">


      <Fields>


        <Field Name="CAStatusId">


          <DataField>CAStatusId</DataField>


          <rd:TypeName>System.Int32</rd:TypeName>


        </Field>


        <Field Name="HeaderValue">


          <DataField>HeaderValue</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


        <Field Name="CAStatusValue">


          <DataField>CAStatusValue</DataField>


          <rd:TypeName>System.String</rd:TypeName>


        </Field>


      </Fields>


      <Query>


        <DataSourceName>DWDataMart</DataSourceName>


        <CommandType>StoredProcedure</CommandType>


        <CommandText>ServiceManager_Report_GRC_ControlManagement_SP_GetCACountByStatus</CommandText>


        <QueryParameters>


          <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="@ADValue">


            <Value>=Parameters!ADValue.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.38208in</Height>


              <TablixCells>


                <TablixCell>


                  <CellContents>


                    <Rectangle Name="Rectangle6">


                      <ReportItems>


                        <Image Name="Image26">


                          <Source>Embedded</Source>


                          <Value>CA</Value>


                          <Sizing>FitProportional</Sizing>


                          <Top>0.02156in</Top>


                          <Left>0.3541in</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!CAStatusId.Value</Value>


                                  <Style></Style>


                                    <Color>White</Color>


                                  </Style>


                                </TextRun>


                              </TextRuns>


                              <Style /></Style>


                            </Paragraph>


                          </Paragraphs>


                          <rd:DefaultName>HeaderValue</rd:DefaultName>


                          <Left>0.1041in</Left>


                          <Height>0.25in</Height>


                          <Width>0.20833in</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.53812in</Left>


                          <Height>0.25in</Height>


                          <Width>5.38542in</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.CADetailReport</ReportName>


                          <Parameters>


                            <Parameter Name="StatusId">


                              <Value>=Fields!CAStatusId.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>CAStatus_Table</DataSetName>


        <Height>0.63208in</Height>


        <Width>6.75in</Width>


        <Style></Style>


          <Border>


            <Style></Style>None</Style>


          </Border>


        </Style>


      </Tablix>


    </ReportItems>


    <Height>0.63208in</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>Start Date</Prompt>


    </ReportParameter>


    <ReportParameter Name="EndDate">


      <DataType>DateTime</DataType>


      <DefaultValue>


        <Values>


          <Value>=DateAdd("d", +1, Today())</Value>


        </Values>


      </DefaultValue>


      <Prompt>End Date</Prompt>


    </ReportParameter>


  </ReportParameters>


  <Width>6.75in</Width>


  <Page>


    <LeftMargin>1in</LeftMargin>


    <RightMargin>1in</RightMargin>


    <TopMargin>1in</TopMargin>


    <BottomMargin>1in</BottomMargin>


    <Style /></Style>


  </Page>


  <EmbeddedImages>


    <EmbeddedImage Name="CA">


      <MIMEType>image/png</MIMEType>


      <ImageData>iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3dJREFUeNpMk1toXFUYhb9zzj4zyZnJfWySJm3iVGoNClpjLE0dW7xiLYpKBZWigrQPLa0PapAIgiD6oD73QYgW0SpSib2olBqtEbRKo6VNvNQ2o5Nkppk0mczMmXPZZ7stKP4b9sve61/rX6zfuPudvXwxfYruXJX7R85QsRQd9Yl02nIecJS1IZ8wWrJxmStI7+TX96SPLHQk8paM+LeEMvRtGESRIlIq0ZdoeeEGp/XpXE+y63BfgtOr4izGDIIgfFLK6Lyh1MHI4DVTsXylgVDwT0eRiG0ebOx4ecXq9ttH70wxdp1DTgYENYkII/yYjaeiNYlK+KLly1tLSetBO6Js7YinaPpgXKQ3r3vfHOgZ/CbTSravkYSnqA8UAYrLtkG6GPDMRI3dP9TYNummo9/maJrKnxBGscLVxWB70nEGcpluzPkqKdejYptIK0bVg0fGijz2s0sqNPCFgassHp1j35f5wgFRqVXpNK2nyjFFPCxR0+MYpiRWL6gr++z5aI7MuUXKNsybYIcmvmGSTCaclbJ1q3h4aPi55OXSRr9/FV6bZl2tJZeWGZ36lMzIt6y9CCf7M3R1r0CkUpgtV+F0dZCdWcJ+9dmMuGnrtjsscPh/SWipNJPlLDU1w6V4I8f7d0C9g2WaDLQ3YIg8USy+XtTKZdcSNrVqiKFPUZ3j94VTpDrXkx4a5tKunVx7ZozP194LjW1Ymu3EUpl2Q3JNnVMvbBFXheo0x356HVM7bjgemTX7WNl2PUH+LAumzXu37cRrSOFIH1OZuGWXP+MxmrGmhSbFjpL4ahZRp9jU8AbpxnX4YUDZq/F2/xNMdd1IS7WMFJpeQCA1SNnMiKZDOiMBST1jpuctwsijKdFMxVtGGIrzTV2M924i6S7jabAy


DUpmki0/HtKpjTg8sP0voXQSAxVgfHgU0/ephZLE0G6sSDsZRcSDKqElCCxbgwT3nf6Eh75/l48Xq7uqW/Z+phsoXBlSmp5G7B9BvvkKKQ2QgU8kJZ7ekcCO07lU4PFfjnDzH+McK+Rfmgvlfsdd0kpNU+gFRCUdguf3YGuHoyDAElfsoXfhAhu0mRuz31FZnMkeLJWG513vQLwurt8VonDxQrYyX/zVGbwFs7cLY3GZ2YkJTP1BTk76d40Oz5uBmzseqa8WpDysBc/qlP9XfwswANbKlRcY1dZ4AAAAAElFTkSuQmCC</ImageData>


    </EmbeddedImage>


  </EmbeddedImages>


  <rd:ReportID>01b3288f-d5b8-42f9-9cd7-8daed56e3e51</rd:ReportID>


  <rd:ReportUnitType>Inch</rd:ReportUnitType>


</Report>