Hi All,
I have attached 2 images. 1.jpg and 2.jpg. I.jpg contains 2 countreis swiss and UK. UK data comes from one server and swiss data comes from another server. Both are different servers, but the query used for both the countries is same. I have created 2 connection string for both database servers. Last week it was working fine. I can see data for both countries but when i refreshed the report yesterday i couldn't see data for UK but data is available in the tables. I tried seperaely for UK database, i can see the values, but i don't understand why it not showing in 1.jpg
Thanks,
Raghu.
