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 |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2008-08-06 : 22:11:41
|
| Maybe someone in this forum could help me. Thankshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107969 |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-08-07 : 01:34:01
|
| OK, so after 3 days of pain I have the solution. Lets start with the problem. I had two report parameters in the report that worked. When I added the two new parameters for server and database name they became paramters 3 and 4 in the list. They have to be 1 and 2. doh! So in the end all that was needed was to:1. Create the report with a shared data source or static string that works and test report.2. Add two report parameters called server and database (important, if you have other parameters these need to be 1 and 2 in the list and make sure allow blank checkbox is off)3. Change connection to: ="data source=" & Parameters!Server.Value & ";initial catalog=" & Parameters!Database.Value4. Deploy and test report.5. I found this method to have limited value as it does not seem to accept a default in report parameters so the report cannot run until a valid server and database name has been entered manually? |
 |
|
|
|
|
|
Data Source Expression not working?