Hi Sze,
Based on my understanding, you are facing the problem to get the data from
the client SQL Server after you publish the report to the server. If I have
misunderstood you, please feel free to let me know.
A simple way to solve this issue is to modify the data connection string in
the config file if you saved it there before. Just try to comment out the
original one and add a new connection string based on the SQL Server domain
and name of the client server. You may get the report to work again.
--
Sincerely,
Zhi-Qiang Ni
Microsoft Online Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================