Error adding Stored Procedure to map in Crystal Reports

Asked

Viewed 36 times

0

When adding an SP with data type parameters date, adding the following error information is displayed.

Variables in the AS

ALTER PROCEDURE [dbo].[spExtractoTSL]
    ,@DataInicial DATETIME = 0
    ,@DataFinal DATETIME = 0

inserir a descrição da imagem aqui

sql crystal-reports

  • I think the variables of the type DateTime cannot have integer values. Try giving a minimum date, for example '1900-01-01'.

  • Good morning friend, Take a look if it suits you? insert link description here

  • @acamiloMoz, managed to solve the problem?

  • I haven’t been able to!

No answers

Browser other questions tagged sql crystal-reports

You are not signed in. Login or sign up in order to post.