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 |
|
Nav522
Starting Member
27 Posts |
 Posted - 2010-04-20 : 16:30:27
|
| Hello Folks, I have a stored procedure which has the Frequency as a parameter. And my question is i cannot see the fields startdate and enddate because the report doesnt have data. Is there any way that i can populate the dates even the report doesnt have data.Thanks a lot. |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2010-04-20 : 16:47:24
|
| You'll need to add date records to the database which the report is pulling the data fromSome days you're the dog, and some days you're the fire hydrant. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-21 : 01:20:52
|
| what values you want to set start and enddate to?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Nav522
Starting Member
27 Posts |
Posted - 2010-04-21 : 09:04:40
|
| Hi vishakh Thanks for getting back. Well i want to set them to previous month start date and previous month enddate. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-04-21 : 09:10:57
|
| Add this as part of the select statement,dateadd(month,datediff(month,0,getdate())-1,0) as start_date,dateadd(month,datediff(month,0,getdate()),-1) as end_dateMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-21 : 23:22:14
|
| put the above query in dataset and assign the default value of date parameters to fields of above dataset in parameters tab.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Coudnt Display StartDate and Enddate