﻿<?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, Fornecedor_da_Formação, Origem_fonte, 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 Fornecedor_da_Formação, Origem_fonte, 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="Fornecedor_da_Formação">
        <DataField>Fornecedor_da_Formação</DataField>
        <rd:TypeName>System.String</rd:TypeName>
      </Field>
      <Field Name="Origem_fonte">
        <DataField>Origem_fonte</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>