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 |
|
Joshrinn
Posting Yak Master
118 Posts |
 Posted - 2012-05-03 : 13:12:01
|
| Im having an issue.There are two feeds which is suppose to populate a DB table every month.Feed 1 generates data every month but feed 2 doesn't get data every month as a result of which there is no value on that table. The last time feed 2 had received data and populated the corresponding table was on jan 2012. The problem now is if the table is not populated value wil b Null values in the tables. But instead of that if no value is received I should use the previous month"s value received by feed two as a result of which there will not be huge variance as oppose to putting NULL values. How can I use last moths data if feed 2 doesn't populate the tables. The expression saved here is =IIF(IsNothing(Fields!End_Det.Value),0,Round(Fields!End_Det.Value))Can something be done if there is no value present than go to the previous month and if there is no value in the previous month then go prior to another previous month?Please help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
About Reporting Services