Pourquoi ?

Vous vous êtes sûrement posé la question de savoir quels sont les états qui 'tournent' sur un serveur Reporting Services.

Par exemple, quels sont ceux qui sont lancés fréquemment, avec quels paramètres etc..

Comment faire ?

SSRS installe en faits deux bases de données pour sa propre gestion :

• ReportServer pour le catalogue et les statistiques comme nous allons le voir
• ReportServerTempDB pour les données temporaires telles le cache

Voici les tables de ReportServer :

Celle qui nous intéresse est Catalog :

Ce catalogue contient tous les objets d'un serveur de rapport :

• Sources de données partagées
• Rapports
• Dossiers
• Images

L'autre table (en fait une vue) fondamentale étant :

Il n'y a plus qu'à faire un rapport basé sur ces données (j'adore les programmes récursifs qui utilisent leurs propres méta-données…)

Voici un des data sets :

Les autres sont basés sur le même modèle :

….

Comme d'habitude, il nous faut quelques paramètres :

Le rapport en exécution :

La demande de paramètres :

Le début de la visualisation :

On voit ici que 137 demandes de diplôme ont été faites…que peu de problèmes de performances se posent(j'y veille !)…que le classement du challenge est celui qui consomme le plus de temps (c'est une matrice…)….etc.

Si vous lancez ce rapport, vous verrez que je visualise aussi les paramètres de chaque lancement, permettant de connaitre le type de demande des utilisateurs..

Le code source complet :

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

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

<DataSources>

<DataSource Name="ReportServer">

<ConnectionProperties>

<DataProvider>SQL</DataProvider>

<ConnectString>data source=(local);initial catalog=ReportServer</ConnectString>

<IntegratedSecurity>true</IntegratedSecurity>

</ConnectionProperties>

<rd:DataSourceID>07989f94-bcfe-43c9-ad0f-58864cfd6c39</rd:DataSourceID>

</DataSource>

</DataSources>

<DataSets>

<DataSet Name="dsDureesTotales">

<Fields>

<Field Name="ItemID">

<DataField>ItemID</DataField>

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

</Field>

<Field Name="Path">

<DataField>Path</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

<Field Name="Description">

<DataField>Description</DataField>

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

</Field>

<Field Name="CreationDate">

<DataField>CreationDate</DataField>

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

</Field>

<Field Name="ModifiedDate">

<DataField>ModifiedDate</DataField>

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

</Field>

<Field Name="DureeTotale">

<DataField>DureeTotale</DataField>

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

</Field>

<Field Name="NbeLancements">

<DataField>NbeLancements</DataField>

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

</Field>

<Field Name="DureeMoyenne">

<DataField>DureeMoyenne</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate, CONVERT(datetime,

SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart))) AS DureeTotale, COUNT(*) AS NbeLancements,

CONVERT(datetime, SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart)) / COUNT(*)) AS DureeMoyenne

FROM Catalog INNER JOIN

ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE (ExecutionLog.TimeStart &gt;= @DateDebut) AND (ExecutionLog.TimeStart &lt;= @DateFin) AND (CONVERT(varchar(200), Catalog.ItemID) LIKE @NoEtat)

GROUP BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate

ORDER BY CONVERT(datetime, SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart))) DESC</CommandText>

<QueryParameters>

<QueryParameter Name="@DateDebut">

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

</QueryParameter>

<QueryParameter Name="@DateFin">

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

</QueryParameter>

<QueryParameter Name="@NoEtat">

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

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

<DataSet Name="dsDureesMoyennes">

<Fields>

<Field Name="ItemID">

<DataField>ItemID</DataField>

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

</Field>

<Field Name="Path">

<DataField>Path</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

<Field Name="Description">

<DataField>Description</DataField>

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

</Field>

<Field Name="CreationDate">

<DataField>CreationDate</DataField>

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

</Field>

<Field Name="ModifiedDate">

<DataField>ModifiedDate</DataField>

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

</Field>

<Field Name="DureeTotale">

<DataField>DureeTotale</DataField>

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

</Field>

<Field Name="NbeLancements">

<DataField>NbeLancements</DataField>

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

</Field>

<Field Name="DureeMoyenne">

<DataField>DureeMoyenne</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate, CONVERT(datetime,

SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart))) AS DureeTotale, COUNT(*) AS NbeLancements,

CONVERT(datetime, SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart)) / COUNT(*)) AS DureeMoyenne

FROM Catalog INNER JOIN

ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE (ExecutionLog.TimeStart &gt;= @DateDebut) AND (ExecutionLog.TimeStart &lt;= @DateFin) AND (CONVERT(varchar(200), Catalog.ItemID) LIKE @NoEtat)

GROUP BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate

ORDER BY CONVERT(datetime, SUM(CONVERT(float, ExecutionLog.TimeEnd) - CONVERT(float, ExecutionLog.TimeStart)) / COUNT(*)) DESC</CommandText>

<QueryParameters>

<QueryParameter Name="@DateDebut">

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

</QueryParameter>

<QueryParameter Name="@DateFin">

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

</QueryParameter>

<QueryParameter Name="@NoEtat">

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

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

<DataSet Name="dsLignesTotales">

<Fields>

<Field Name="ItemID">

<DataField>ItemID</DataField>

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

</Field>

<Field Name="Path">

<DataField>Path</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

<Field Name="Description">

<DataField>Description</DataField>

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

</Field>

<Field Name="CreationDate">

<DataField>CreationDate</DataField>

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

</Field>

<Field Name="ModifiedDate">

<DataField>ModifiedDate</DataField>

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

</Field>

<Field Name="NbeLignesTotal">

<DataField>NbeLignesTotal</DataField>

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

</Field>

<Field Name="NbeLancements">

<DataField>NbeLancements</DataField>

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

</Field>

<Field Name="NbeLignesMoyennes">

<DataField>NbeLignesMoyennes</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate, SUM(ExecutionLog.[RowCount])

AS NbeLignesTotal, COUNT(*) AS NbeLancements, SUM(ExecutionLog.[RowCount]) / COUNT(*) AS NbeLignesMoyennes

FROM Catalog INNER JOIN

ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE (ExecutionLog.TimeStart &gt;= @DateDebut) AND (ExecutionLog.TimeStart &lt;= @DateFin) AND (CONVERT(varchar(200), Catalog.ItemID) LIKE @NoEtat)

GROUP BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate

ORDER BY SUM(ExecutionLog.[RowCount]) DESC</CommandText>

<QueryParameters>

<QueryParameter Name="@DateDebut">

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

</QueryParameter>

<QueryParameter Name="@DateFin">

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

</QueryParameter>

<QueryParameter Name="@NoEtat">

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

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

<DataSet Name="dsLignesMoyennes">

<Fields>

<Field Name="ItemID">

<DataField>ItemID</DataField>

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

</Field>

<Field Name="Path">

<DataField>Path</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

<Field Name="Description">

<DataField>Description</DataField>

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

</Field>

<Field Name="CreationDate">

<DataField>CreationDate</DataField>

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

</Field>

<Field Name="ModifiedDate">

<DataField>ModifiedDate</DataField>

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

</Field>

<Field Name="NbeLignesTotal">

<DataField>NbeLignesTotal</DataField>

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

</Field>

<Field Name="NbeLancements">

<DataField>NbeLancements</DataField>

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

</Field>

<Field Name="NbeLignesMoyennes">

<DataField>NbeLignesMoyennes</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate, SUM(ExecutionLog.[RowCount])

AS NbeLignesTotal, COUNT(*) AS NbeLancements, SUM(ExecutionLog.[RowCount]) / COUNT(*) AS NbeLignesMoyennes

FROM Catalog INNER JOIN

ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE (ExecutionLog.TimeStart &gt;= @DateDebut) AND (ExecutionLog.TimeStart &lt;= @DateFin) AND (CONVERT(varchar(200), Catalog.ItemID) LIKE @NoEtat)

GROUP BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate

ORDER BY SUM(ExecutionLog.[RowCount]) / COUNT(*) DESC</CommandText>

<QueryParameters>

<QueryParameter Name="@DateDebut">

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

</QueryParameter>

<QueryParameter Name="@DateFin">

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

</QueryParameter>

<QueryParameter Name="@NoEtat">

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

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

<DataSet Name="dsElementCatalogue">

<Fields>

<Field Name="NoEtat">

<DataField>NoEtat</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT CONVERT(varchar(200), ItemID) AS NoEtat, Name

FROM Catalog

WHERE (Type = 2) OR

(Type = 4)

UNION

SELECT '%', ' __Tous les états'

ORDER BY Name</CommandText>

</Query>

</DataSet>

<DataSet Name="dsParametres">

<Fields>

<Field Name="NoEtat">

<DataField>NoEtat</DataField>

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

</Field>

<Field Name="Path">

<DataField>Path</DataField>

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

</Field>

<Field Name="Name">

<DataField>Name</DataField>

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

</Field>

<Field Name="Description">

<DataField>Description</DataField>

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

</Field>

<Field Name="CreationDate">

<DataField>CreationDate</DataField>

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

</Field>

<Field Name="ModifiedDate">

<DataField>ModifiedDate</DataField>

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

</Field>

<Field Name="Parametres">

<DataField>Parametres</DataField>

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

</Field>

<Field Name="NbeLancements">

<DataField>NbeLancements</DataField>

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

</Field>

</Fields>

<Query>

<DataSourceName>ReportServer</DataSourceName>

<CommandText>SELECT CONVERT(varchar(200), Catalog.ItemID) AS NoEtat, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate,

CONVERT(varchar(1000), ExecutionLog.Parameters) AS Parametres, COUNT(*) AS NbeLancements

FROM Catalog INNER JOIN

ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID

WHERE (ExecutionLog.TimeStart &gt;= @DateDebut) AND (ExecutionLog.TimeStart &lt;= @DateFin) AND (CONVERT(varchar(200), Catalog.ItemID) LIKE @NoEtat)

GROUP BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, Catalog.CreationDate, Catalog.ModifiedDate, CONVERT(varchar(1000),

ExecutionLog.Parameters)

ORDER BY Catalog.ItemID, Catalog.Path, Catalog.Name, Catalog.Description, CONVERT(varchar(1000), ExecutionLog.Parameters)</CommandText>

<QueryParameters>

<QueryParameter Name="@DateDebut">

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

</QueryParameter>

<QueryParameter Name="@DateFin">

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

</QueryParameter>

<QueryParameter Name="@NoEtat">

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

</QueryParameter>

</QueryParameters>

</Query>

</DataSet>

</DataSets>

<Body>

<ReportItems>

<Tablix Name="lstDureesMoyennes">

<TablixBody>

<TablixColumns>

<TablixColumn>

<Width>12.23076in</Width>

</TablixColumn>

</TablixColumns>

<TablixRows>

<TablixRow>

<Height>1.24203in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Rectangle Name="lstDureesMoyennes_Contents">

<ReportItems>

<Tablix Name="tblDureesMoyennes">

<TablixBody>

<TablixColumns>

<TablixColumn>

<Width>0.98425in</Width>

</TablixColumn>

<TablixColumn>

<Width>1.37795in</Width>

</TablixColumn>

<TablixColumn>

<Width>1.1811in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.73872in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.7283in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.7283in</Width>

</TablixColumn>

</TablixColumns>

<TablixRows>

<TablixRow>

<Height>0.24997in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="textbox7">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Durée Moyenne</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>17</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox12">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Nbe Lancements</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<ZIndex>16</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox13">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Durée Totale</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>15</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox16">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Chemin</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>14</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox18">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Nom</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>13</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox19">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Description</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>12</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.24997in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="textbox20">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style>

<Format>HH:mm:ss</Format>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Center</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<ZIndex>5</ZIndex>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox21">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style />

</TextRun>

</TextRuns>

<Style>

<TextAlign>Center</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<ZIndex>4</ZIndex>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox22">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style>

<Format>HH:mm:ss</Format>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Center</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<ZIndex>3</ZIndex>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox23">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>2</ZIndex>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox24">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>1</ZIndex>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox25">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

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

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<Style>

<BackgroundColor>=iif(RowNumber("dsDureesMoyennes") mod 2 =0,"PowderBlue","White")</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

<TablixRow>

<Height>0.24997in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="textbox26">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>11</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox27">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>10</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox28">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>9</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox29">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>8</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox30">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>7</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox31">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value />

<Style />

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<ZIndex>6</ZIndex>

<Style>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

</TablixRows>

</TablixBody>

<TablixColumnHierarchy>

<TablixMembers>

<TablixMember />

<TablixMember />

<TablixMember />

<TablixMember />

<TablixMember />

<TablixMember />

</TablixMembers>

</TablixColumnHierarchy>

<TablixRowHierarchy>

<TablixMembers>

<TablixMember>

<KeepWithGroup>After</KeepWithGroup>

<KeepTogether>true</KeepTogether>

</TablixMember>

<TablixMember>

<Group Name="tblDureesMoyennes_Details_Group">

<DataElementName>Detail</DataElementName>

</Group>

<TablixMembers>

<TablixMember>

<Visibility>

<Hidden>=iif(rownumber("dsDureesMoyennes") &lt;= Parameters!NbeDureesMoyennes.Value ,false,true)</Hidden>

</Visibility>

</TablixMember>

</TablixMembers>

<DataElementName>Detail_Collection</DataElementName>

<DataElementOutput>Output</DataElementOutput>

<KeepTogether>true</KeepTogether>

</TablixMember>

<TablixMember>

<KeepWithGroup>Before</KeepWithGroup>

<KeepTogether>true</KeepTogether>

</TablixMember>

</TablixMembers>

</TablixRowHierarchy>

<DataSetName>dsDureesMoyennes</DataSetName>

<Top>1.25cm</Top>

<Left>0.25cm</Left>

<Height>1.90476cm</Height>

<Width>29.81613cm</Width>

<Style />

</Tablix>

<Textbox Name="textbox33">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Par durée moyenne décroissante :</Value>

<Style>

<Color>White</Color>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<Top>0.25cm</Top>

<Height>0.63492cm</Height>

<Width>6cm</Width>

<ZIndex>1</ZIndex>

<Style>

<Border>

<Style>Solid</Style>

</Border>

<BackgroundColor>RoyalBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</ReportItems>

<KeepTogether>true</KeepTogether>

<Style />

</Rectangle>

</CellContents>

</TablixCell>

</TablixCells>

</TablixRow>

</TablixRows>

</TablixBody>

<TablixColumnHierarchy>

<TablixMembers>

<TablixMember />

</TablixMembers>

</TablixColumnHierarchy>

<TablixRowHierarchy>

<TablixMembers>

<TablixMember>

<Group Name="lstDureesMoyennes_Details_Group">

<GroupExpressions>

<GroupExpression>=2</GroupExpression>

</GroupExpressions>

</Group>

<Visibility>

<Hidden>= iif( Parameters!NbeDureesMoyennes.Value = 0,true,false)</Hidden>

</Visibility>

<DataElementOutput>Output</DataElementOutput>

<KeepTogether>true</KeepTogether>

</TablixMember>

</TablixMembers>

</TablixRowHierarchy>

<DataSetName>dsDureesMoyennes</DataSetName>

<Top>4.25cm</Top>

<Height>3.15476cm</Height>

<Width>31.06613cm</Width>

<DataElementOutput>NoOutput</DataElementOutput>

<Style />

</Tablix>

<Tablix Name="lstDureesTotales">

<TablixBody>

<TablixColumns>

<TablixColumn>

<Width>11.93549in</Width>

</TablixColumn>

</TablixColumns>

<TablixRows>

<TablixRow>

<Height>1.37795in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Rectangle Name="lstDureesTotales_Contents">

<ReportItems>

<Tablix Name="tblDureesTotales">

<TablixBody>

<TablixColumns>

<TablixColumn>

<Width>0.98425in</Width>

</TablixColumn>

<TablixColumn>

<Width>1.37795in</Width>

</TablixColumn>

<TablixColumn>

<Width>1.1811in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.73872in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.7283in</Width>

</TablixColumn>

<TablixColumn>

<Width>2.7283in</Width>

</TablixColumn>

</TablixColumns>

<TablixRows>

<TablixRow>

<Height>0.24997in</Height>

<TablixCells>

<TablixCell>

<CellContents>

<Textbox Name="textbox6">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Durée Totale</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox6</rd:DefaultName>

<ZIndex>17</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox15">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Nbe Lancements</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style>

<TextAlign>Right</TextAlign>

</Style>

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox15</rd:DefaultName>

<ZIndex>16</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox5">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Durée Moyenne</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox5</rd:DefaultName>

<ZIndex>15</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox2">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Chemin</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox2</rd:DefaultName>

<ZIndex>14</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox3">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Nom</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

<rd:DefaultName>textbox3</rd:DefaultName>

<ZIndex>13</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

<PaddingBottom>2pt</PaddingBottom>

</Style>

</Textbox>

</CellContents>

</TablixCell>

<TablixCell>

<CellContents>

<Textbox Name="textbox4">

<CanGrow>true</CanGrow>

<KeepTogether>true</KeepTogether>

<Paragraphs>

<Paragraph>

<TextRuns>

<TextRun>

<Value>Description</Value>

<Style>

<FontWeight>Bold</FontWeight>

</Style>

</TextRun>

</TextRuns>

<Style />

</Paragraph>

</Paragraphs>

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

<ZIndex>12</ZIndex>

<Style>

<BackgroundColor>PowderBlue</BackgroundColor>

<PaddingLeft>2pt</PaddingLeft>