Thanks a lot for your valuable inputs Ken. Don't you think Merge will also take care of intermittent internet at subscriber and it also has conflict resolution.

Thanks so much for the reply Russel. I am thinking this is not a unique situation which i have encountered. The solution that you have provided will work in my...

Thanks for the reply Russel. I thought of that. We dont use the default date for sure but there are chances that we might use 0 for config values. Is...

We have take a different route to do this. With the new change, all we do is pick the data from sql server. No more expressions on ssrs side. Thanks...

Graham-

Thanks a lot for taking your time to provide a valuable input. I dont have any experience as DBA and my goal is get into BI and work more on...

Thanks a lot George for your valuable input.