Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-22 : 18:00:33
|
| I've got a daily report that 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-23 : 00:20:06
|
| Are you providing any fileter conditions for your dataset/table? Have you tried displaying the entered parameter values in report to see what values are passed to stored procedure? |
 |
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-23 : 19:14:53
|
| make sure that there is no function sleected in the values, lots of times when you drag and drop fields from the sql rs , it attaches First! ahead of the field name and that will only shopw you teh first entry. make sure that only field names are listed in the text box or label i.e. report item on teh report itself. |
|
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2008-04-24 : 16:03:51
|
| The parameters work now. In the Data view, under dataset I now have the stored proc and in the command type: I have selected StoredProcedure.Then in report properties it picked up the date parameters.thx all,john |
|
|
|
|
|
|
Date parameters don't work