olá! Tenho uma consulta no mysql que faz uma contagem da quantidade de inscrições. Mais no relatório está contando todos os itens da cosulta sem aplicar o filtro. Exemplo:
SELECT
d.department,
COUNT(d.cod_department) AS total_professionals
FROM department d
INNER JOIN professionals p ON d.cod_department = p.cod_department
where d.cod_business = 1
GROUP BY d.department
ORDER BY d.department;
run in mysql it returns:
cod_business department total_professionals
1 department 1 32
1 department 2 10
1 department 3 15
no relatório substituindo a clausula where pelos filtros, é gerado o seguinte:
cod_business department total_professionals
1 department 1 50
1 department 2 70
1 department 3 20
the report returns the company departments '1', but makes the count in all businesses.
the filter is not being applied in the count.
1 Answer, 1 is accepted
Thank you for your interest in Telerik Reporting. The official language used for our correspondence with clients is English, so we would appreciate if you continue this discussion in English.
On your question, please test using the Query Builder and test the SQL query. If you need to parameterize the query, the SQL parameters can be mapped to report parameters with the settings from the SqlDatasource Wizard article.
Verify you are using the latest Telerik Reporting Q3 2015 v9.2.15.930 and check what queries are executed over the database when running the SqlDataSource Wizard preview.
Regards,
Stef
Telerik