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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2006-04-11 : 14:39:08
|
| Hi, everybody!I know ac97 does not provide direct binding of an ado rs to a report. I want to do it manually.I have a form with a textbox and a button. On the button click event, I passed the text box value to sql server and got a ado rs back. My question is, am I able to pass the rs into the report, and in report's open event wire up field by field like thisme!txtName.ControlSource = rs.fields("CustName")...Or do the data mapping in my form?After all, is it possible to code this way? Any sample? If I use DAO, does it make a difference?Thanks! |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-04-13 : 09:24:47
|
| According to a reply I got from a Microsoft MVP on another forum, this is not possible.In ac97, it seems the only way to run t-sql is through pass-through query/DAO route. |
 |
|
|
|
|
|
bind ado.rs to report in ac97