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 |
|
aRTx
Starting Member
2 Posts |
 Posted - 2010-12-01 : 15:46:06
|
| Hi there,Right now I'm in big trouble, I have create a simple application that use Report (rdlc). It works in my computer good but it doesn't work at the client(s) computer properly.At the clients it doesn't show the data from SQL SERVER DATABASE!download(Visual Studio project):[url]http://rapidshare.com/files/434336166/ApplicationDataReport.zip[/url] |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-01 : 16:25:23
|
| Can it connect to the server?Try using the profiler to see what it's doing.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
aRTx
Starting Member
2 Posts |
Posted - 2010-12-01 : 16:45:51
|
quote:
Originally posted by nigelrivett
Can it connect to the server?Try using the profiler to see what it's doing.
Yes, it is Connected.And it shows only the Labels and the header of tables but not fields. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-02 : 01:22:41
|
| are you using the same database on both client side and your production side? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-02 : 04:15:34
|
| Does it run off stored procedures or are the queries embedded.Change it to run off stored procedures then you will know independently what is being returned and can log the call and parameters passed.In the meantime use the profiler to see what is being executed.If it uses dates make sure that they are not locale dependent - i.e. it's not looking for 12 jan rather than 1st dec.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
My report doesn't show data!