CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    4

    Erro with add Stored Procedure in Crystal

    Good Morning.

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

    [IMG]http://i51.tinypic.com/zmz8cm.jpg" />

    the stored is:

    Code:
    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.

  2. #2
    Join Date
    Apr 2011
    Posts
    4

    Re: Erro with add Stored Procedure in Crystal

    the image:


  3. #3
    Join Date
    Apr 2011
    Posts
    4

    Re: Erro with add Stored Procedure in Crystal

    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/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured