SQL Server Performance

Date parameters don't work

Discussion in 'SQL Server Reporting Services' started by latingntlman, Apr 22, 2008.

  1. latingntlman New Member

    I've got a daily report that's linked to a stored proc with two date parms (begindate / enddate), when I run the query in the stored proc in sql, I get data for three days (2008-04-17 00:00:00; 2008-04-18 00:00:00; and 2008-04-21 00:00:00), but when I run the report in RS, it only shows one date (4/21/2008). Although I uncheck NULL for both date parms and enter a beginning and ending date and run it, it only returns data for date 4/21/2008.
    Does anyone have any idea of what I may be doing wrong?
    thx,
    John
  2. Luis Martin Moderator

    I'm not RS expert.
    Could be some date configuration between WS and server?

Share This Page