N Maiores Grupos de Erros

Microsoft.SystemCenter.CM.AEM.Views.Internal.DataWarehouse.Report.TopNErrorGroups (Report)

Esse relatório mostra os N maiores grupos de erros com base em sua contagem de falhas durante o intervalo especificado.
Knowledge Base article:

Resumo

Como esse relatório opera?
O relatório 'N Maiores Grupos de Erros' exibe:
Um gráfico mostrando os N Maiores Grupos de Erros com base na contagem de falhas.
Em seguida, uma tabela que mostra
a contagem total de falhas,
a contagem de falhas média por grupo de erros e a
contagem diária média de falhas por grupo de erros.
No final, há uma tabela detalhando os N Maiores Grupos de Erros com base na contagem de falhas durante o intervalo de tempo especificado:
Número de Série
Nome do Aplicativo
Versão do Aplicativo
Identificação do Grupo de Erros
Tipo de partição
Tipo de Evento
Contagem de falhas
Contagem de falhas média diária
Resposta da Microsoft
Element properties:

Accessibility	Public
Visible	True
Report Localization:

*R.Description*	Esse relatório mostra os N maiores grupos de erros com base em sua contagem de falhas durante o intervalo especificado.
*R.DescriptionTitle*	Clique no sinal de mais para ver uma descrição completa desse relatório
*R.GeneratedTimeLabel*	Horário do Relatório
*R.Graph.XAxisLabel*	Número de Série
*R.Graph.YAxisLabel*	Contagem de falhas
*R.GraphTableLabel*	Tabela de Resumo do Relatório de N Maiores Grupos de Erros
*R.GraphTitleLabel*	Gráfico dos N Maiores Grupos de Erros
*R.NLabel*	N
*R.PageFormat*	Página {0} de {1}
*R.StartEndTimeFormat*	De {0} até {1}
*R.StartEndTimeLabel*	Duração do Relatório
*R.TableHeaderLine1*	N Maiores Grupos de Erros
*R.TableSubHeaderLine1*	N Maiores Grupos de Erros com base na Contagem de Falhas durante o intervalo especificado.
*R.TimeZoneFormat*	Todas as datas e horas são indicadas em {0}
*R.Title*	Relatório dos N Maiores Grupos de Erros de Monitoramento de Clientes
*RT.Column.ApplicationNameLabel*	Nome do Aplicativo
*RT.Column.ApplicationVersionLabel*	Versão do Aplicativo
*RT.Column.AverageCrashCountPerErrorGroupLabel*	Contagem Média de Falhas por Grupo de Erros
*RT.Column.AverageDailyCrashCountLabel*	Contagem de Falhas Média Diária
*RT.Column.AverageDailyCrashCountPerErrorGroupLabel*	Contagem Média Diária de Falhas por Grupo de Erros
*RT.Column.BucketTypeLabel*	Tipo de partição
*RT.Column.CrashCountLabel*	Contagem de falhas
*RT.Column.ErrorGroupIdLabel*	Identificação do Grupo de Erros
*RT.Column.EventTypeLabel*	Tipo de Evento
*RT.Column.MicrosoftResponseLabel*	Resposta da Microsoft
*RT.Column.SerialNumberLabel*	Nº de Série
*RT.Column.TotalCrashCountLabel*	Contagem Total de Falhas
Source Code:

<Report ID="Microsoft.SystemCenter.CM.AEM.Views.Internal.DataWarehouse.Report.TopNErrorGroups" Accessibility="Public" Target="AEMLib!Microsoft.SystemCenter.CM.AEM.CrashListener" Visible="true">

  <Dependencies>

    <DataWarehouseDataSet>Microsoft.SystemCenter.CM.AEM.Views.Internal.DataWarehouse.AemDataSet</DataWarehouseDataSet>

    <ReportParameterControl>Reporting!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker</ReportParameterControl>

    <ReportParameterControl>Reporting!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown</ReportParameterControl>

  </Dependencies>

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="6">

    <Controls>

      <Control rowSpan="4" columnSpan="2" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>

          <ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>

          <ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>

          <ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">

            <Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown">

        <ReportParameters>

          <ReportParameter name="N">

            <Prompt>Microsoft.SystemCenter.ClientMonitoring.Views.Internal!Microsoft.SystemCenter.ClientMonitoring.Views.Internal.Report.TopNErrorGroups.ParameterPrompt.N</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <Definition>

    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

      <DataSources>

        <DataSource Name="DataWarehouseMain">

          <DataSourceReference>Data Warehouse Main</DataSourceReference>

          <rd:DataSourceID>721cf2a6-03f9-4b0f-b0c6-8bd35d84b599</rd:DataSourceID>

        </DataSource>

      </DataSources>

      <ReportParameters>

        <ReportParameter Name="LT_Report">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Report_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

          <Hidden>true</Hidden>

        </ReportParameter>

        <ReportParameter Name="LT_Table">

          <DataType>String</DataType>

          <DefaultValue>

            <DataSetReference>

              <DataSetName>LT_Table_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

            </DataSetReference>

          </DefaultValue>

          <ValidValues>

            <DataSetReference>

              <DataSetName>LT_Table_Query</DataSetName>

              <ValueField>ValueXml</ValueField>

              <LabelField>ValueName</LabelField>

            </DataSetReference>

          </ValidValues>

          <Hidden>true</Hidden>

        </ReportParameter>

        <ReportParameter Name="StartDate_BaseType">

          <DataType>String</DataType>

          <Prompt>[Start Date Base]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_BaseValue">

          <DataType>DateTime</DataType>

          <Prompt>[From]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_OffsetType">

          <DataType>String</DataType>

          <Prompt>[Start Date Offset Type]</Prompt>

        </ReportParameter>

        <ReportParameter Name="StartDate_OffsetValue">

          <DataType>Integer</DataType>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Start Date Offset]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_BaseType">

          <DataType>String</DataType>

          <Prompt>[End Date Base]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_BaseValue">

          <DataType>DateTime</DataType>

          <Prompt>[To]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_OffsetType">

          <DataType>String</DataType>

          <Prompt>[End Date Offset Type]</Prompt>

        </ReportParameter>

        <ReportParameter Name="EndDate_OffsetValue">

          <DataType>Integer</DataType>

          <AllowBlank>true</AllowBlank>

          <Prompt>[End Date Offset]</Prompt>

        </ReportParameter>

        <ReportParameter Name="TimeZone">

          <DataType>String</DataType>

          <Prompt>[Time Zone]</Prompt>

        </ReportParameter>

        <ReportParameter Name="TimeZoneName">

          <DataType>String</DataType>

          <Nullable>true</Nullable>

          <AllowBlank>true</AllowBlank>

          <Prompt>[Time Zone Name]</Prompt>

        </ReportParameter>

        <ReportParameter Name="N">

          <DataType>Integer</DataType>

          <DefaultValue>

            <Values>

              <Value>10</Value>

            </Values>

          </DefaultValue>

          <Prompt>[Top 'N' Error Groups]</Prompt>

        </ReportParameter>

      </ReportParameters>

      <rd:DrawGrid>true</rd:DrawGrid>

      <InteractiveWidth>8.5in</InteractiveWidth>

      <rd:SnapToGrid>true</rd:SnapToGrid>

      <Body><Script>

        <ReportItems>

          <Chart Name="TopNErrorGroupsChart">

            <Legend>

              <Style></Style>

                <BorderStyle>

                  <Default>Solid</Default>

                </BorderStyle>

                <FontFamily>Tahoma</FontFamily>

                <FontSize>8pt</FontSize>

                <BorderColor>

                  <Default>DarkGray</Default>

                </BorderColor>

                <BackgroundColor>White</BackgroundColor>

                <BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>

                <BackgroundGradientType>TopBottom</BackgroundGradientType>

              </Style>

              <Position>BottomRight</Position>

              <Layout>Table</Layout>

            </Legend>

            <Subtype>Plain</Subtype>

            <Title>

              <Caption>=Code.GetLocTable("LT_Report").GetString("R.GraphTitleLabel", "[Top N Error Groups Graph]")</Caption>

              <Style></Style>

                <FontFamily>Tahoma</FontFamily>

                <FontWeight>700</FontWeight>

                <FontSize>8pt</FontSize>

              </Style>

            </Title>

            <Height>3.1in</Height>

            <CategoryAxis>

              <Axis>

                <Title>

                  <Caption>=Code.GetLocTable("LT_Report").GetString("R.Graph.XAxisLabel", "[Serial Number]")</Caption>

                  <Style></Style>

                    <FontFamily>Tahoma</FontFamily>

                    <FontWeight>600</FontWeight>

                    <FontSize>8pt</FontSize>

                  </Style>

                </Title>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                </Style>

                <MajorGridLines>

                  <ShowGridLines>true</ShowGridLines>

                  <Style></Style>

                    <BorderStyle>

                      <Default>Solid</Default>

                    </BorderStyle>

                  </Style>

                </MajorGridLines>

                <MinorGridLines>

                  <Style></Style>

                    <BorderStyle>

                      <Default>Solid</Default>

                    </BorderStyle>

                  </Style>

                </MinorGridLines>

                <MajorTickMarks>Outside</MajorTickMarks>

                <Min>1</Min>

                <Margin>true</Margin>

                <Visible>true</Visible>

              </Axis>

            </CategoryAxis>

            <PointWidth>0</PointWidth>

            <Left>0.15in</Left>

            <DataElementOutput>NoOutput</DataElementOutput>

            <ThreeDProperties/>

            <DataSetName>ErrorGroupQuery</DataSetName>

            <SeriesGroupings>

              <SeriesGrouping>

                <StaticSeries>

                  <StaticMember>

                    <Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.CrashCount", "[Crash Count]")</Label>

                  </StaticMember>

                </StaticSeries>

              </SeriesGrouping>

            </SeriesGroupings>

            <Top>2.45in</Top>

            <PlotArea>

              <Style></Style>

                <BorderStyle>

                  <Default>Solid</Default>

                </BorderStyle>

                <BackgroundColor>White</BackgroundColor>

                <BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>

                <BackgroundGradientType>TopBottom</BackgroundGradientType>

              </Style>

            </PlotArea>

            <ValueAxis>

              <Axis>

                <Title>

                  <Caption>=Code.GetLocTable("LT_Report").GetString("R.Graph.YAxisLabel", "[Crash Count]")</Caption>

                  <Style></Style>

                    <FontFamily>Tahoma</FontFamily>

                    <FontWeight>600</FontWeight>

                    <FontSize>8pt</FontSize>

                  </Style>

                </Title>

                <Style></Style>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                </Style>

                <MajorGridLines>

                  <ShowGridLines>true</ShowGridLines>

                  <Style></Style>

                    <BorderStyle>

                      <Default>Solid</Default>

                    </BorderStyle>

                  </Style>

                </MajorGridLines>

                <MinorGridLines>

                  <Style></Style>

                    <BorderStyle>

                      <Default>Solid</Default>

                    </BorderStyle>

                  </Style>

                </MinorGridLines>

                <MajorTickMarks>Outside</MajorTickMarks>

                <Min>0</Min>

                <Margin>true</Margin>

                <Visible>true</Visible>

                <Scalar>true</Scalar>

              </Axis>

            </ValueAxis>

            <ZIndex>7</ZIndex>

            <Type>Bar</Type>

            <Width>8.225in</Width>

            <CategoryGroupings>

              <CategoryGrouping>

                <DynamicCategories>

                  <Grouping Name="serialNumberGroup">

                    <GroupExpressions>

                      <GroupExpression>=Fields!SerialNumber.Value</GroupExpression>

                    </GroupExpressions>

                  </Grouping>

                  <Label>=Fields!SerialNumber.Value.ToString()</Label>

                </DynamicCategories>

              </CategoryGrouping>

            </CategoryGroupings>

            <Palette>SemiTransparent</Palette>

            <ChartData>

              <ChartSeries>

                <DataPoints>

                  <DataPoint>

                    <DataValues>

                      <DataValue>

                        <Value>=Sum(Fields!CrashCount.Value)</Value>

                      </DataValue>

                    </DataValues>

                    <DataLabel>

                      <Style></Style>

                        <FontFamily>Tahoma</FontFamily>

                        <FontWeight>600</FontWeight>

                        <FontSize>8pt</FontSize>

                      </Style>

                      <Visible>true</Visible>

                    </DataLabel>

                    <Style></Style>

                      <BackgroundColor>CornflowerBlue</BackgroundColor>

                      <BackgroundGradientEndColor>Blue</BackgroundGradientEndColor>

                      <BackgroundGradientType>TopBottom</BackgroundGradientType>

                    </Style>

                    <Marker>

                      <Size>6pt</Size>

                    </Marker>

                    <DataElementOutput>NoOutput</DataElementOutput>

                  </DataPoint>

                </DataPoints>

              </ChartSeries>

            </ChartData>

            <Style></Style>

              <BackgroundColor>White</BackgroundColor>

            </Style>

          </Chart>

          <List Name="list1">

            <DataElementOutput>Output</DataElementOutput>

            <Left>0.15in</Left>

            <ReportItems>

              <Image Name="image1">

                <Sizing>AutoSize</Sizing>

                <Left>0.05in</Left>

                <MIMEType>image/png</MIMEType>

                <Top>0.05in</Top>

                <ZIndex>3</ZIndex>

                <Width>0.25in</Width>

                <Source>External</Source>

                <Style></Style>

                  <PaddingLeft>4pt</PaddingLeft>

                  <BorderColor>

                    <Default>DarkGray</Default>

                  </BorderColor>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <Height>0.4in</Height>

                <Value>../reports_icon.png</Value>

              </Image>

              <Table Name="ErrorGroupsTable">

                <DataElementOutput>Output</DataElementOutput>

                <DetailDataElementName>ErrorGroup</DetailDataElementName>

                <DataSetName>ErrorGroupQuery</DataSetName>

                <Top>0.45in</Top>

                <ZIndex>2</ZIndex>

                <Details>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox11">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>8</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>SerialNumber</DataElementName>

                              <Value>=Code.FormatNumber("G", Fields!SerialNumber.Value)</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox14">

                              <rd:DefaultName>textbox14</rd:DefaultName>

                              <ZIndex>7</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <DataElementName>ApplicationName</DataElementName>

                              <Value>=Fields!ApplicationName.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox47">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>6</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>ApplicationVersion</DataElementName>

                              <Value>=Fields!ApplicationVersion.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox3">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>5</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>ErrorGroupId</DataElementName>

                              <Value>=Fields!ErrorGroupId.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox48">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>4</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>BucketType</DataElementName>

                              <Value>=Fields!BucketType.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox49">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>3</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>EventType</DataElementName>

                              <Value>=Fields!EventType.Value</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox50">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>2</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>CrashCount</DataElementName>

                              <Value>=Code.FormatNumber("G", Fields!CrashCount.Value)</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox51">

                              <DataElementOutput>Output</DataElementOutput>

                              <ZIndex>1</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <PaddingLeft>2pt</PaddingLeft>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <Format>#.00</Format>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <DataElementStyle>ElementNormal</DataElementStyle>

                              <CanGrow>true</CanGrow>

                              <DataElementName>AverageDailyCrashCount</DataElementName>

                              <Value>=Code.FormatNumber("N2", Fields!AverageDailyCrashCount.Value )</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.5in</Height>

                    </TableRow>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ColSpan>8</ColSpan>

                          <ReportItems>

                            <Rectangle Name="rectangle2">

                              <DataElementOutput>Output</DataElementOutput>

                              <ReportItems>

                                <Textbox Name="textbox15">

                                  <DataElementOutput>NoOutput</DataElementOutput>

                                  <ZIndex>1</ZIndex>

                                  <Style></Style>

                                    <PaddingLeft>2pt</PaddingLeft>

                                    <PaddingBottom>2pt</PaddingBottom>

                                    <FontFamily>Tahoma</FontFamily>

                                    <FontSize>8pt</FontSize>

                                    <PaddingRight>2pt</PaddingRight>

                                    <PaddingTop>2pt</PaddingTop>

                                  </Style>

                                  <CanGrow>true</CanGrow>

                                  <Height>0.2in</Height>

                                  <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.MicrosoftResponseLabel", "[Microsoft Response Column Label]") &amp; ":"</Value>

                                </Textbox>

                                <Textbox Name="textbox17">

                                  <Left>0.01042in</Left>

                                  <DataElementOutput>Output</DataElementOutput>

                                  <Top>0.2in</Top>

                                  <Action>

                                    <Hyperlink>=Fields!MicrosoftResponse.Value</Hyperlink>

                                  </Action>

                                  <Style></Style>

                                    <PaddingLeft>2pt</PaddingLeft>

                                    <PaddingBottom>2pt</PaddingBottom>

                                    <FontFamily>Tahoma</FontFamily>

                                    <FontSize>8pt</FontSize>

                                    <Color>Blue</Color>

                                    <PaddingRight>2pt</PaddingRight>

                                    <PaddingTop>2pt</PaddingTop>

                                  </Style>

                                  <DataElementStyle>ElementNormal</DataElementStyle>

                                  <CanGrow>true</CanGrow>

                                  <DataElementName>Url</DataElementName>

                                  <Value>=Fields!MicrosoftResponse.Value</Value>

                                </Textbox>

                              </ReportItems>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <BorderWidth>

                                  <Default>0.5pt</Default>

                                </BorderWidth>

                                <BorderColor>

                                  <Default>DarkGray</Default>

                                </BorderColor>

                              </Style>

                              <DataElementName>MicrosoftResponse</DataElementName>

                            </Rectangle>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.40625in</Height>

                    </TableRow>

                  </TableRows>

                  <Sorting>

                    <SortBy>

                      <SortExpression>=Fields!SerialNumber.Value</SortExpression>

                      <Direction>Ascending</Direction>

                    </SortBy>

                  </Sorting>

                </Details>

                <DetailDataCollectionName>ErrorGroups</DetailDataCollectionName>

                <Header>

                  <TableRows>

                    <TableRow>

                      <TableCells>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox55">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>16</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!SerialNumber.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.SerialNumberLabel", "[Serial Number Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox4">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <rd:DefaultName>textbox4</rd:DefaultName>

                              <ZIndex>15</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!ApplicationName.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ApplicationNameLabel", "[Application Name Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox56">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>14</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!ApplicationVersion.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ApplicationVersionLabel", "[Application Version Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox13">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>13</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!ErrorGroupId.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ErrorGroupIdLabel", "[Error Group Id Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox57">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>12</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!BucketType.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.BucketTypeLabel", "[Bucket Type Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox58">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>11</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!EventType.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.EventTypeLabel", "[Event Type Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox59">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>10</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!CrashCount.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.CrashCountLabel", "[Crash Count Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                        <TableCell>

                          <ReportItems>

                            <Textbox Name="textbox60">

                              <DataElementOutput>NoOutput</DataElementOutput>

                              <ZIndex>9</ZIndex>

                              <Style></Style>

                                <BorderStyle>

                                  <Default>Solid</Default>

                                </BorderStyle>

                                <TextAlign>Center</TextAlign>

                                <PaddingLeft>2pt</PaddingLeft>

                                <PaddingBottom>2pt</PaddingBottom>

                                <FontFamily>Tahoma</FontFamily>

                                <FontSize>8pt</FontSize>

                                <VerticalAlign>Middle</VerticalAlign>

                                <BorderColor>

                                  <Default>DimGray</Default>

                                </BorderColor>

                                <BackgroundColor>Gray</BackgroundColor>

                                <Color>White</Color>

                                <PaddingRight>2pt</PaddingRight>

                                <PaddingTop>2pt</PaddingTop>

                              </Style>

                              <CanGrow>true</CanGrow>

                              <UserSort>

                                <SortExpression>=Fields!AverageDailyCrashCount.Value</SortExpression>

                              </UserSort>

                              <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AverageDailyCrashCountLabel", "[Average Daily Crash Count Column Label]")</Value>

                            </Textbox>

                          </ReportItems>

                        </TableCell>

                      </TableCells>

                      <Height>0.25in</Height>

                    </TableRow>

                  </TableRows>

                  <RepeatOnNewPage>true</RepeatOnNewPage>

                </Header>

                <TableColumns>

                  <TableColumn>

                    <Width>0.55in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>2.7in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>1in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>0.8in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>0.8in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>0.8in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>0.8in</Width>

                  </TableColumn>

                  <TableColumn>

                    <Width>0.8in</Width>

                  </TableColumn>

                </TableColumns>

                <DataElementName>ErrorGroupsTable</DataElementName>

                <Height>1.15625in</Height>

              </Table>

              <Textbox Name="textbox36">

                <Left>0.35in</Left>

                <DataElementOutput>Output</DataElementOutput>

                <Top>0.05in</Top>

                <ZIndex>1</ZIndex>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontWeight>700</FontWeight>

                  <VerticalAlign>Bottom</VerticalAlign>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <DataElementStyle>AttributeNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <DataElementName>Name</DataElementName>

                <Height>0.2in</Height>

                <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TableHeaderLine1", "[Top N Error Groups Data Table Header]"))</Value>

              </Textbox>

              <Textbox Name="textbox72">

                <Left>0.35in</Left>

                <DataElementOutput>Output</DataElementOutput>

                <Top>0.25in</Top>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <DataElementStyle>AttributeNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <DataElementName>Path</DataElementName>

                <Height>0.2in</Height>

                <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TableSubHeaderLine1", "[Top N Error Groups Data Table Sub-Header]"))</Value>

              </Textbox>

            </ReportItems>

            <DataSetName>ErrorGroupQuery</DataSetName>

            <Top>6.45in</Top>

            <ZIndex>6</ZIndex>

            <Width>8.25in</Width>

            <Grouping Name="Object">

              <GroupExpressions>

                <GroupExpression>=""</GroupExpression>

              </GroupExpressions>

            </Grouping>

            <DataElementName>TopNErrorGroupsDetail</DataElementName>

            <DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>

          </List>

          <Rectangle Name="RptSpacerHeader">

            <Left>0.15in</Left>

            <Top>1.5in</Top>

            <ZIndex>5</ZIndex>

            <Width>8.05in</Width>

            <Style></Style>

              <BorderStyle>

                <Bottom>Solid</Bottom>

              </BorderStyle>

              <BorderColor>

                <Default>DarkGray</Default>

              </BorderColor>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.05in</Height>

          </Rectangle>

          <Rectangle Name="RptHeader">

            <Left>0.15in</Left>

            <ReportItems>

              <Textbox Name="reportDescriptionTitle">

                <DataElementOutput>NoOutput</DataElementOutput>

                <Top>0.3in</Top>

                <ZIndex>1</ZIndex>

                <Width>8in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <VerticalAlign>Middle</VerticalAlign>

                  <Color>DimGray</Color>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Click on plus sign to see a full description for this report]")</Value>

              </Textbox>

              <Textbox Name="reportTitle">

                <Left>0.2in</Left>

                <DataElementOutput>Output</DataElementOutput>

                <Top>0.05in</Top>

                <Width>7.8in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontWeight>700</FontWeight>

                  <FontSize>11pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <DataElementStyle>ElementNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <DataElementName>Title</DataElementName>

                <Height>0.25in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.Title", "[Top N Error Groups]")</Value>

              </Textbox>

            </ReportItems>

            <Top>0.75in</Top>

            <ZIndex>4</ZIndex>

            <Width>8.05in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.55in</Height>

          </Rectangle>

          <Rectangle Name="RptExtdHeader">

            <Left>0.15in</Left>

            <ReportItems>

              <Textbox Name="reportDescription">

                <Left>0.2in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <Width>7.8in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.Description", "[The Top N Error Groups Report gives an overview of non-availability of error groups in a chosen timeframe.]")</Value>

              </Textbox>

            </ReportItems>

            <Top>1.3in</Top>

            <ZIndex>3</ZIndex>

            <Visibility>

              <ToggleItem>reportDescriptionTitle</ToggleItem>

              <Hidden>true</Hidden>

            </Visibility>

            <Width>8.05in</Width>

            <Style></Style>

              <BackgroundColor>Gainsboro</BackgroundColor>

            </Style>

            <Height>0.2in</Height>

          </Rectangle>

          <Image Name="banner_image">

            <Sizing>AutoSize</Sizing>

            <Left>0.15in</Left>

            <MIMEType/>

            <Top>0.1in</Top>

            <ZIndex>2</ZIndex>

            <Width>8.05in</Width>

            <Source>External</Source>

            <Style/>

            <Height>0.64583in</Height>

            <Value>../banner_portrait.jpg</Value>

          </Image>

          <Rectangle Name="RptParamHeader">

            <Left>0.15in</Left>

            <ReportItems>

              <Textbox Name="textbox10">

                <Left>1.85in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.45in</Top>

                <ZIndex>9</ZIndex>

                <Width>0.1in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>:</Value>

              </Textbox>

              <Textbox Name="textbox6">

                <Left>1.95in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.45in</Top>

                <ZIndex>8</ZIndex>

                <Width>6.05in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.FormatNumber("G", Parameters!N.Value)</Value>

              </Textbox>

              <Textbox Name="textbox9">

                <Left>0.25in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.45in</Top>

                <ZIndex>7</ZIndex>

                <Width>1.6in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.NLabel", "[N Label]")</Value>

              </Textbox>

              <Textbox Name="textbox28">

                <Left>1.95in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.25in</Top>

                <ZIndex>6</ZIndex>

                <Width>6.05in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.FormatString(

Code.GetLocTable("LT_Report").GetString("R.StartEndTimeFormat", "{0} - {1}"),

Code.FormatDateTime("g", Code.GetReportStartDate()),

Code.FormatDateTime("g", Code.GetReportEndDate())

)</Value>

              </Textbox>

              <Image Name="parameterBottomImage">

                <Sizing>AutoSize</Sizing>

                <MIMEType/>

                <Top>0.7in</Top>

                <ZIndex>5</ZIndex>

                <Source>External</Source>

                <Style/>

                <Value>../gradient_portrait.gif</Value>

              </Image>

              <Textbox Name="ReportGeneratedTime">

                <Left>1.95in</Left>

                <DataElementOutput>Output</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <ZIndex>4</ZIndex>

                <Width>6.05in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <DataElementStyle>ElementNormal</DataElementStyle>

                <CanGrow>true</CanGrow>

                <DataElementName>Created</DataElementName>

                <Height>0.2in</Height>

                <Value>=Code.FormatDateTime("g", Code.ToReportDate(DateTime.UtcNow))</Value>

              </Textbox>

              <Textbox Name="textbox7">

                <Left>1.85in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.25in</Top>

                <ZIndex>3</ZIndex>

                <Width>0.1in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>:</Value>

              </Textbox>

              <Textbox Name="textbox2">

                <Left>1.85in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <ZIndex>2</ZIndex>

                <Width>0.1in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>:</Value>

              </Textbox>

              <Textbox Name="textbox1">

                <Left>0.25in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.05in</Top>

                <ZIndex>1</ZIndex>

                <Width>1.6in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.GeneratedTimeLabel", "[Report Generated Time Label]")</Value>

              </Textbox>

              <Textbox Name="textbox26">

                <Left>0.25in</Left>

                <DataElementOutput>NoOutput</DataElementOutput>

                <CanShrink>true</CanShrink>

                <Top>0.25in</Top>

                <Width>1.6in</Width>

                <Style></Style>

                  <PaddingLeft>2pt</PaddingLeft>

                  <PaddingBottom>2pt</PaddingBottom>

                  <FontFamily>Tahoma</FontFamily>

                  <FontSize>8pt</FontSize>

                  <PaddingRight>2pt</PaddingRight>

                  <PaddingTop>2pt</PaddingTop>

                </Style>

                <CanGrow>true</CanGrow>

                <Height>0.2in</Height>

                <Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndTimeLabel", "[Report Start/End Time Label]")</Value>

              </Textbox>

            </ReportItems>

            <Top>1.55in</Top>

            <ZIndex>1</ZIndex>

            <Width>8.05in</Width>

            <Height>0.75in</Height>

          </Rectangle>

          <Table Name="table2">

            <Left>2.5in</Left>

            <DataElementOutput>Output</DataElementOutput>

            <DetailDataElementName>TopNErrorGroupsSummary</DetailDataElementName>

            <DataSetName>ErrorGroupSummaryQuery</DataSetName>

            <Top>5.7in</Top>

            <Width>3.59999in</Width>

            <Details>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox16">

                          <DataElementOutput>Output</DataElementOutput>

                          <ZIndex>2</ZIndex>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DarkGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gainsboro</BackgroundColor>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <DataElementStyle>ElementNormal</DataElementStyle>

                          <CanGrow>true</CanGrow>

                          <DataElementName>TotalCrashes</DataElementName>

                          <Value>=Code.FormatNumber("G", Fields!TotalCrashes.Value )</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox21">

                          <DataElementOutput>Output</DataElementOutput>

                          <ZIndex>1</ZIndex>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DarkGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gainsboro</BackgroundColor>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <DataElementStyle>ElementNormal</DataElementStyle>

                          <CanGrow>true</CanGrow>

                          <DataElementName>AverageCrashCountPerErrorGroup</DataElementName>

                          <Value>=Code.FormatNumber("N2", Fields!AverageCrashCountPerErrorGroup.Value )</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox23">

                          <DataElementOutput>Output</DataElementOutput>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DarkGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gainsboro</BackgroundColor>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <DataElementStyle>ElementNormal</DataElementStyle>

                          <CanGrow>true</CanGrow>

                          <DataElementName>AverageDailyCrashCountPerErrorGroup</DataElementName>

                          <Value>=Code.FormatNumber("N2", Fields!AverageDailyCrashCountPerErrorGroup.Value )</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

            </Details>

            <DetailDataCollectionName>TopNErrorGroupsSummaryInfo</DetailDataCollectionName>

            <Style></Style>

              <BorderColor>

                <Default>DarkGray</Default>

              </BorderColor>

            </Style>

            <Header>

              <TableRows>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ColSpan>3</ColSpan>

                      <ReportItems>

                        <Textbox Name="textbox5">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <ZIndex>6</ZIndex>

                          <Style></Style>

                            <TextAlign>Center</TextAlign>

                            <PaddingLeft>2pt</PaddingLeft>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontWeight>700</FontWeight>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Code.GetLocTable("LT_Report").GetString("R.GraphTableLabel", "[Graph Table Label]")</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.25in</Height>

                </TableRow>

                <TableRow>

                  <TableCells>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox8">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <ZIndex>5</ZIndex>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gray</BackgroundColor>

                            <Color>White</Color>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.TotalCrashCountLabel", "[Total Crash Count Column Label]")</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox12">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <ZIndex>4</ZIndex>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gray</BackgroundColor>

                            <Color>White</Color>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AverageCrashCountPerErrorGroupLabel", "[Average Crash Count Per Error Group Column Label]")</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                    <TableCell>

                      <ReportItems>

                        <Textbox Name="textbox22">

                          <DataElementOutput>NoOutput</DataElementOutput>

                          <ZIndex>3</ZIndex>

                          <Style></Style>

                            <BorderStyle>

                              <Default>Solid</Default>

                            </BorderStyle>

                            <PaddingLeft>2pt</PaddingLeft>

                            <BorderWidth>

                              <Default>0.5pt</Default>

                            </BorderWidth>

                            <PaddingBottom>2pt</PaddingBottom>

                            <FontFamily>Tahoma</FontFamily>

                            <FontSize>8pt</FontSize>

                            <BorderColor>

                              <Default>DimGray</Default>

                            </BorderColor>

                            <BackgroundColor>Gray</BackgroundColor>

                            <Color>White</Color>

                            <PaddingRight>2pt</PaddingRight>

                            <PaddingTop>2pt</PaddingTop>

                          </Style>

                          <CanGrow>true</CanGrow>

                          <Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AverageDailyCrashCountPerErrorGroupLabel", "[Average Daily Crash Count Per Error Group Column Label]")</Value>

                        </Textbox>

                      </ReportItems>

                    </TableCell>

                  </TableCells>

                  <Height>0.2in</Height>

                </TableRow>

              </TableRows>

            </Header>

            <TableColumns>

              <TableColumn>

                <Width>1.10769in</Width>

              </TableColumn>

              <TableColumn>

                <Width>1.24615in</Width>

              </TableColumn>

              <TableColumn>

                <Width>1.24615in</Width>

              </TableColumn>

            </TableColumns>

            <DataElementName>TopNErrorGroupsSummaryTable</DataElementName>

            <Height>0.65in</Height>

          </Table>

        </ReportItems>

        <Height>8.15in</Height>

      </Script></Body>

      <rd:ReportID>15e5f438-771c-4949-ba59-7d4ecb0fe849</rd:ReportID>

      <DataSets>

        <DataSet Name="LT_Report_Query">

          <Query>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>ReportDisplayStringGet</CommandText>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

                <Value>=Code.GetCallingManagementGroupId()</Value>

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>Microsoft.SystemCenter.ClientMonitoring.Views.Internal</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.SystemCenter.CM.AEM.Views.Internal.DataWarehouse.Report.TopNErrorGroups</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

                <Value>=Code.GetReportLocLanguageCode()</Value>

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>R.%</Value>

              </QueryParameter>

            </QueryParameters>

            <DataSourceName>DataWarehouseMain</DataSourceName>

          </Query>

          <Fields>

            <Field Name="ValueXml">

              <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="LT_Table_Query">

          <Query>

            <CommandType>StoredProcedure</CommandType>

            <CommandText>ReportDisplayStringGet</CommandText>

            <QueryParameters>

              <QueryParameter Name="@ManagementGroupGuid">

                <Value>=Code.GetCallingManagementGroupId()</Value>

              </QueryParameter>

              <QueryParameter Name="@ManagementPackSystemName">

                <Value>Microsoft.SystemCenter.ClientMonitoring.Views.Internal</Value>

              </QueryParameter>

              <QueryParameter Name="@ReportSystemName">

                <Value>Microsoft.SystemCenter.CM.AEM.Views.Internal.DataWarehouse.Report.TopNErrorGroups</Value>

              </QueryParameter>

              <QueryParameter Name="@LanguageCode">

                <Value>=Code.GetReportLocLanguageCode()</Value>

              </QueryParameter>

              <QueryParameter Name="@Scope">

                <Value>RT.%</Value>

              </QueryParameter>

            </QueryParameters>

            <DataSourceName>DataWarehouseMain</DataSourceName>

          </Query>

          <Fields>

            <Field Name="ValueXml">

              <DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>

            </Field>

            <Field Name="ValueName">

              <Value>="LT"</Value>

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="ErrorGroupQuery">

          <Query>

            <CommandText>IF (@N &lt;= 0) 

BEGIN

  SET @N = 1

END



DECLARE @StartDailyDate DateTime, @EndDailyDate DateTime

EXEC dbo.AemGetDailyAggregationDate @StartDate, @StartDailyDate out

EXEC dbo.AemGetDailyAggregationDate @EndDate, @EndDailyDate out



CREATE TABLE #TempTopNErrorGroups(

  SerialNumber int identity(1, 1),

  ApplicationName nvarchar(256),

  ApplicationVersion nvarchar(256),

  BucketType nvarchar(10),

  EventType nvarchar(256),

  CrashCount int,

  AverageDailyCrashCount float,

  MicrosoftResponse nvarchar(256),

  ErrorGroupId nvarchar(40)

)



INSERT INTO #TempTopNErrorGroups(

    ApplicationName, 

    ApplicationVersion, 

    BucketType, 

    EventType, 

    CrashCount, 

    AverageDailyCrashCount, 

    ErrorGroupId, 

    MicrosoftResponse

) 

  SELECT 

      UPPER(SUBSTRING(tbApp.ApplicationName, 1, 1)) + LOWER(SUBSTRING(tbApp.ApplicationName, 2, LEN(tbApp.ApplicationName))) AS ApplicationName

    , LOWER(tbApp.ApplicationVersion) AS ApplicationVersion

    , tbErr.BucketType AS BucketType

    , tbErr.Parameter0 AS EventType

    , tbTemp.CrashCount AS CrashCount

    , tbTemp.AverageDailyCrashCount AS AverageDailyCrashCount

    , UPPER(ISNULL(

        CONVERT(nvarchar(40), tbErr.BucketId),

        CONVERT(nvarchar(40), tbErr.ErrorGroupManagedEntityId))) AS ErrorGroupId

    , tbErr.MicrosoftResponseUrl AS MicrosoftResponse

  FROM [dbo].[AemErrorGroup] tbErr

    JOIN (

      SELECT TOP (@N) 

          vErrDaily.ErrorGroupRowId AS ErrorGroupRowId

        , SUM(vErrDaily.CrashCount) AS CrashCount

        , SUM(vErrDaily.CrashCount) * 1.0 / ABS(DATEDIFF(DAY, @StartDailyDate, @EndDailyDate)) AS AverageDailyCrashCount

      FROM [CM].[vCMAemErrorGroupDaily] vErrDaily

      WHERE DATEDIFF(DAY, @StartDailyDate, vErrDaily.[DateTime]) &gt; = 0 AND

          DATEDIFF(DAY, vErrDaily.[DateTime], @EndDailyDate) &gt; 0

      GROUP BY vErrDaily.ErrorGroupRowId

      ORDER BY CrashCount DESC

    ) tbTemp ON tbErr.ErrorGroupRowId = tbTemp.ErrorGroupRowId

    JOIN [dbo].[AemApplication] tbApp ON tbErr.ApplicationRowId = tbApp.ApplicationRowId

  ORDER BY ApplicationName ASC, ApplicationVersion DESC



UPDATE #TempTopNErrorGroups

SET EventType = ''

WHERE UPPER(BucketType) != 'GENERIC'



SELECT SerialNumber, ErrorGroupId, ApplicationName, ApplicationVersion, BucketType, EventType, CrashCount, AverageDailyCrashCount, MicrosoftResponse

FROM #TempTopNErrorGroups



DROP TABLE #TempTopNErrorGroups</CommandText>

            <QueryParameters>

              <QueryParameter Name="@N">

                <Value>=Parameters!N.Value</Value>

              </QueryParameter>

              <QueryParameter Name="@StartDate">

                <Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>

              </QueryParameter>

              <QueryParameter Name="@EndDate">

                <Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>

              </QueryParameter>

            </QueryParameters>

            <DataSourceName>DataWarehouseMain</DataSourceName>

          </Query>

          <Fields>

            <Field Name="ApplicationName">

              <DataField>ApplicationName</DataField>

            </Field>

            <Field Name="ApplicationVersion">

              <DataField>ApplicationVersion</DataField>

            </Field>

            <Field Name="ErrorGroupId">

              <DataField>ErrorGroupId</DataField>

            </Field>

            <Field Name="BucketType">

              <DataField>BucketType</DataField>

            </Field>

            <Field Name="EventType">

              <DataField>EventType</DataField>

            </Field>

            <Field Name="CrashCount">

              <DataField>CrashCount</DataField>

            </Field>

            <Field Name="AverageDailyCrashCount">

              <DataField>AverageDailyCrashCount</DataField>

            </Field>

            <Field Name="MicrosoftResponse">

              <DataField>MicrosoftResponse</DataField>

            </Field>

            <Field Name="SerialNumber">

              <DataField>SerialNumber</DataField>

            </Field>

          </Fields>

        </DataSet>

        <DataSet Name="ErrorGroupSummaryQuery">

          <Query>

            <CommandText>IF (@N &lt;= 0) 

          BEGIN

                    SET @N = 1

          END



          DECLARE @StartDailyDate DateTime, @EndDailyDate DateTime

          EXEC dbo.AemGetDailyAggregationDate @StartDate, @StartDailyDate out

          EXEC dbo.AemGetDailyAggregationDate @EndDate, @EndDailyDate out



          SELECT SUM(CrashCount) AS TotalCrashes

          , SUM(CrashCount) * 1.0 / COUNT(*) AS AverageCrashCountPerErrorGroup

          , SUM(AverageDailyCrashCount) * 1.0 / COUNT(*) AS AverageDailyCrashCountPerErrorGroup

          FROM

          (

          SELECT TOP (@N) vErrDaily.ErrorGroupRowId AS ErrorGroupRowId,

          SUM(vErrDaily.CrashCount) AS CrashCount,

          SUM(vErrDaily.CrashCount) * 1.0 / ABS(DATEDIFF(DAY, @StartDailyDate, @EndDailyDate)) AS AverageDailyCrashCount

          FROM [CM].[vCMAemErrorGroupDaily] vErrDaily

          WHERE DATEDIFF(DAY, @StartDailyDate, vErrDaily.[DateTime]) &gt; = 0 AND

                  DATEDIFF(DAY, vErrDaily.[DateTime], @EndDailyDate) &gt; 0

        GROUP BY vErrDaily.ErrorGroupRowId

        ORDER BY CrashCount DESC

) tbTemp</CommandText>

            <QueryParameters>

              <QueryParameter Name="@N">

                <Value>=Parameters!N.Value</Value>

              </QueryParameter>

              <QueryParameter Name="@StartDate">

                <Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>

              </QueryParameter>

              <QueryParameter Name="@EndDate">

                <Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>

              </QueryParameter>

            </QueryParameters>

            <DataSourceName>DataWarehouseMain</DataSourceName>

          </Query>

          <Fields>

            <Field Name="TotalCrashes">

              <DataField>TotalCrashes</DataField>

            </Field>

            <Field Name="AverageCrashCountPerErrorGroup">

              <DataField>AverageCrashCountPerErrorGroup</DataField>

            </Field>

            <Field Name="AverageDailyCrashCountPerErrorGroup">

              <DataField>AverageDailyCrashCountPerErrorGroup</DataField>

            </Field>

          </Fields>

        </DataSet>

      </DataSets>

      <CodeModules>

        <CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>

      </CodeModules>

      <Code><Script>

    Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"



    Const TimeZoneParameterName As String = "TimeZone"

    Const SD_BaseTypeParameterName As String = "StartDate_BaseType"

    Const SD_BaseValueParameterName As String = "StartDate_BaseValue"

    Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"

    Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"

    Const ED_BaseTypeParameterName As String = "EndDate_BaseType"

    Const ED_BaseValueParameterName As String = "EndDate_BaseValue"

    Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"

    Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"

    Const IsRelativeTimeSupported As Boolean = False

    Const TimeTypeParameterName As String = "TimeType"

    Const TimeWeekMapParameterName As String = "TimeWeekMap"



    Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)

    Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

    Dim ReportStartDate As DateTime

    Dim ReportEndDate As DateTime

    Dim ReportTime As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime

    Dim ReportCulture As System.Globalization.CultureInfo

    Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor



    Protected Overrides Sub OnInit()

    LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()

    ReportTimeZone = Nothing

    ReportStartDate = DateTime.MinValue

    ReportEndDate = DateTime.MinValue

    ReportTime = Nothing

    ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))

    ParameterProcessor = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor(ReportCulture)

    End Sub



    Public Function GetCallingManagementGroupId() As String

    Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId

    End Function



    Public Function GetReportLocLanguageCode() As String

    Return ReportCulture.ThreeLetterWindowsLanguageName

    End Function



    Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable

    Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable



    If Not LocTables.TryGetValue(Name, LocTable) Then

    LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)

    LocTables.Add(Name, LocTable)

    End If



    Return LocTable

    End Function



    Public Function GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation

    If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)

    Return ReportTimeZone

    End Function



    Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime

    return GetReportTimeZone.ToUniversalTime(DateValue)

    End Function



    Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime

    return GetReportTimeZone.ToLocalTime(DateValue)

    End Function



    Public Function GetReportStartDate() As DateTime

    If (ReportStartDate = DateTime.MinValue) Then

    If (IsRelativeTimeSupported) Then

    ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)

    Else

    ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)

    End if

    End If

    return ReportStartDate

    End Function



    Public Function GetReportEndDate() As DateTime

    If (ReportEndDate = DateTime.MinValue) Then

    If (IsRelativeTimeSupported) Then

    ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)

    If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)

    Else

    ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)

    End if

    End If

    return ReportEndDate

    End Function



    Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime

    If IsNothing(ReportTime) Then ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))

    return ReportTime

    End Function



    Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean

    return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)

    End Function



    Public Function FormatDateTime(Format As String, Value As DateTime) As String

    return Value.ToString(Format, ReportCulture)

    End Function



    Public Function FormatNumber(Format As String, Value As Decimal) As String

    return Value.ToString(Format, ReportCulture)

    End Function



    Public Function FormatString(Format As String, ParamArray Values() as  Object) As String

    return String.Format(ReportCulture, Format, Values)

    End Function



    Public Function NullFormatString(Format As String, Value as  String) As String

    return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(ReportCulture, Format, Value))

    End Function



    Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String

    Dim result As String



    If IsBusinessHours(Value) Then



    Dim firstDay As DayOfWeek

    Dim days As System.Collections.Generic.List(Of String)



    firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek

    days = new System.Collections.Generic.List(Of String)()



    For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday

    Dim day As DayOfWeek

    day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)



    If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))

    Next loopDay



    result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))



    Else

    result = String.Empty

    End if



    return result

    End Function



    Public Function BuildXmlValueList(ByVal ValueList() As Object) As String

    Return Microsoft.EnterpriseManagement.Reporting.MultiValueParameter.ToXml("Data", "Value", ValueList)

    End Function

  </Script></Code>

      <Width>8.5in</Width>

      <DataElementStyle>ElementNormal</DataElementStyle>

      <InteractiveHeight>11in</InteractiveHeight>

      <Language>en-US</Language>

      <PageFooter>

        <ReportItems>

          <Textbox Name="textbox62">

            <Left>6.5in</Left>

            <Top>0.1in</Top>

            <ZIndex>1</ZIndex>

            <Width>1.7in</Width>

            <Style></Style>

              <TextAlign>Right</TextAlign>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingBottom>2pt</PaddingBottom>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

              <Color>DimGray</Color>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

            </Style>

            <CanGrow>true</CanGrow>

            <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "[{0}/{1}]"), Globals!PageNumber, Globals!TotalPages)</Value>

          </Textbox>

          <Textbox Name="textbox63">

            <Left>0.15in</Left>

            <Top>0.1in</Top>

            <Width>6.25in</Width>

            <Style></Style>

              <PaddingLeft>2pt</PaddingLeft>

              <PaddingBottom>2pt</PaddingBottom>

              <FontFamily>Tahoma</FontFamily>

              <FontSize>8pt</FontSize>

              <Color>DimGray</Color>

              <PaddingRight>2pt</PaddingRight>

              <PaddingTop>2pt</PaddingTop>

            </Style>

            <CanGrow>true</CanGrow>

            <Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "[{0}]"), Parameters!TimeZoneName.Value)</Value>

          </Textbox>

        </ReportItems>

        <Height>0.2875in</Height>

        <PrintOnLastPage>true</PrintOnLastPage>

        <PrintOnFirstPage>true</PrintOnFirstPage>

      </PageFooter>

    </Report>

  </Definition>

  <ReportStrings>

    <ReportString ID="R.Title"/>

    <ReportString ID="R.DescriptionTitle"/>

    <ReportString ID="R.Description"/>

    <ReportString ID="R.GeneratedTimeLabel"/>

    <ReportString ID="R.StartEndTimeLabel"/>

    <ReportString ID="R.StartEndTimeFormat"/>

    <ReportString ID="R.NLabel"/>

    <ReportString ID="R.GraphTitleLabel"/>

    <ReportString ID="R.Graph.XAxisLabel"/>

    <ReportString ID="R.Graph.YAxisLabel"/>

    <ReportString ID="R.GraphTableLabel"/>

    <ReportString ID="RT.Column.TotalCrashCountLabel"/>

    <ReportString ID="RT.Column.AverageCrashCountPerErrorGroupLabel"/>

    <ReportString ID="RT.Column.AverageDailyCrashCountPerErrorGroupLabel"/>

    <ReportString ID="R.TableHeaderLine1"/>

    <ReportString ID="R.TableSubHeaderLine1"/>

    <ReportString ID="RT.Column.SerialNumberLabel"/>

    <ReportString ID="RT.Column.ApplicationNameLabel"/>

    <ReportString ID="RT.Column.ApplicationVersionLabel"/>

    <ReportString ID="RT.Column.BucketTypeLabel"/>

    <ReportString ID="RT.Column.EventTypeLabel"/>

    <ReportString ID="RT.Column.CrashCountLabel"/>

    <ReportString ID="RT.Column.AverageDailyCrashCountLabel"/>

    <ReportString ID="RT.Column.ErrorGroupIdLabel"/>

    <ReportString ID="RT.Column.MicrosoftResponseLabel"/>

    <ReportString ID="R.PageFormat"/>

    <ReportString ID="R.TimeZoneFormat"/>

  </ReportStrings>

</Report>