﻿<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <DataSet Name="">
    <Query>
      <DataSourceReference>SCORE</DataSourceReference>
      <DataSetParameters>
        <DataSetParameter Name="@Tipo_de_Formação">
          <ReadOnly>false</ReadOnly>
          <Nullable>false</Nullable>
          <OmitFromQuery>false</OmitFromQuery>
          <rd:DbType>Object</rd:DbType>
        </DataSetParameter>
        <DataSetParameter Name="@Fornecedor_da_Formação">
          <ReadOnly>false</ReadOnly>
          <Nullable>false</Nullable>
          <OmitFromQuery>false</OmitFromQuery>
          <rd:DbType>Object</rd:DbType>
        </DataSetParameter>
        <DataSetParameter Name="@data_in">
          <ReadOnly>false</ReadOnly>
          <Nullable>false</Nullable>
          <OmitFromQuery>false</OmitFromQuery>
          <rd:DbType>Object</rd:DbType>
        </DataSetParameter>
        <DataSetParameter Name="@data_out">
          <ReadOnly>false</ReadOnly>
          <Nullable>false</Nullable>
          <OmitFromQuery>false</OmitFromQuery>
          <rd:DbType>Object</rd:DbType>
        </DataSetParameter>
      </DataSetParameters>
      <CommandText>SELECT        AVG(CAST(Peso AS float)) AS Média, COUNT(Peso) AS Num_Respostas, Ano, Fornecedor_da_Formação, Categoria_SCORE, ID_de_Pergunta_SCORE
FROM            dbo.View_SCORE_Transacao
WHERE        (Peso IS NOT NULL)
AND Tipo_de_Formação in (@Tipo_de_Formação)
AND Fornecedor_da_Formação in (@Fornecedor_da_Formação)
AND Data_de_Envio &gt;= (@data_in) AND Data_de_Envio &lt;= (@data_out)
GROUP BY Ano, Fornecedor_da_Formação, Categoria_SCORE, ID_de_Pergunta_SCORE</CommandText>
    </Query>
    <Fields>
      <Field Name="Média">
        <DataField>Média</DataField>
        <rd:TypeName>System.Double</rd:TypeName>
      </Field>
      <Field Name="Num_Respostas">
        <DataField>Num_Respostas</DataField>
        <rd:TypeName>System.Int32</rd:TypeName>
      </Field>
      <Field Name="Ano">
        <DataField>Ano</DataField>
        <rd:TypeName>System.Int32</rd:TypeName>
      </Field>
      <Field Name="Fornecedor_da_Formação">
        <DataField>Fornecedor_da_Formação</DataField>
        <rd:TypeName>System.String</rd:TypeName>
      </Field>
      <Field Name="Categoria_SCORE">
        <DataField>Categoria_SCORE</DataField>
        <rd:TypeName>System.String</rd:TypeName>
      </Field>
      <Field Name="ID_de_Pergunta_SCORE">
        <DataField>ID_de_Pergunta_SCORE</DataField>
        <rd:TypeName>System.String</rd:TypeName>
      </Field>
    </Fields>
  </DataSet>
</SharedDataSet>