"Ana" <nospam@yahoo.com> wrote in message
news:OTOf7IIuFHA.2880@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I've a dialog form which interacts with a stored procedure to select a
> range of dates. A command moves the data to a report, in theory, but it's
> not working.
>
> SELECT dbo.CLAIMS.CLAIM_ID, dbo.CLAIMS.NAME,
>
> dbo.CLAIMS.DATE_IN,
>
> dbo.CLAIMS.SALESMAN_ID
>
> FROM dbo.CLAIMS
>
> WHERE (dbo.CLAIMS.CLAIM_ID = @Salesman) AND
>
> (CAST(dbo.CLAIMS,DATE_IN AS datetime) BETWEEN @D_Start AND @D_End)
>
> The dates are stored in yyyymmdd format for which -> CAST.
>
> The report is blank (no info and no errors), however, when using the Query
> Analyzer, the script works fine. Of course, replacing the variables (@)
> with fixed data.
>
> What am I doing wrong?
>
> TIA
>
> Ana
>
>

On Wed, 14 Sep 2005 17:25:55 -0700, Raman Iyer [MS] wrote:

>[forwarding to the relational server newsgroup]
>
>"Ana" <nospam@yahoo.com> wrote in message
>news:OTOf7IIuFHA.2880@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> I've a dialog form which interacts with a stored procedure to select a
>> range of dates. A command moves the data to a report, in theory, but it's
>> not working.
>>
>> SELECT dbo.CLAIMS.CLAIM_ID, dbo.CLAIMS.NAME,
>>
>> dbo.CLAIMS.DATE_IN,
>>
>> dbo.CLAIMS.SALESMAN_ID
>>
>> FROM dbo.CLAIMS
>>
>> WHERE (dbo.CLAIMS.CLAIM_ID = @Salesman) AND
>>
>> (CAST(dbo.CLAIMS,DATE_IN AS datetime) BETWEEN @D_Start AND @D_End)

>> The dates are stored in yyyymmdd format for which -> CAST.

>> The report is blank (no info and no errors), however, when using the Query
>> Analyzer, the script works fine. Of course, replacing the variables (@)
>> with fixed data.