Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Problem to connect Stored Procedure with Crystal Post Reply Post New Topic
Author Message
JohnyMoraes
Newbie
Newbie


Joined: 17 Mar 2011
Online Status: Offline
Posts: 6
Quote JohnyMoraes Replybullet Topic: Problem to connect Stored Procedure with Crystal
    Posted: 06 Apr 2011 at 4:01am
Good Morning.

When i try to add one Stored Procedure in Crystal Reports, show me the error about parameters:



the stored is:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ChequesDevolvidos`(vDataInicio date, vDataFim date)

BEGIN
        
        SELECT SEMANA_CADASTRADOS,
                QTD_CADASTRADOS,
                SOMA_CADASTRADOS,
                SEMANA_DEVOLVIDOS,
                QTD_DEVOLVIDOS,
                SOMA_DEVOLVIDOS
        FROM
          (
          SELECT WEEK(CHEQUE_DTCADASTRO) as 'SEMANA_CADASTRADOS',
                  COUNT(*) as 'QTD_CADASTRADOS',
                  SUM(CHEQUE_VALOR) as 'SOMA_CADASTRADOS'
          FROM cheques
          WHERE CHEQUE_DTCADASTRO BETWEEN vDataInicio AND vDataFim
          GROUP BY WEEK(CHEQUE_DTCADASTRO)
          )c left join
          (
          SELECT WEEK(CHEQUE_DTDEVOLUCAO) as 'SEMANA_DEVOLVIDOS',
                  COUNT(*) as 'QTD_DEVOLVIDOS',
                  SUM(CHEQUE_VALOR) as 'SOMA_DEVOLVIDOS'
          FROM cheques
          WHERE CHEQUE_DTDEVOLUCAO BETWEEN vDataInicio AND vDataFim
          GROUP BY WEEK(CHEQUE_DTDEVOLUCAO)
          )a
          on c.SEMANA_CADASTRADOS = a.SEMANA_DEVOLVIDOS;          
END;



Someone know how i find a solution for this ?
I use Crystal Reports 8.5 and MySql.
IP IP Logged
JohnyMoraes
Newbie
Newbie


Joined: 17 Mar 2011
Online Status: Offline
Posts: 6
Quote JohnyMoraes Replybullet Posted: 06 Apr 2011 at 9:17am
I solve this problem!
I instal the driver Mysql odbc 5.1.8 and fixed the problem.
If someone need, the driver is in :http://dev.mysql.com/downloads/connector/odbc/
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.