I can get the report to properly share data with the application since I am using XML. I pick the tables and columns using ADO and it works.
BUT, when I have it in a reportviewer ,it keeps asking me to log on. I don't have this problem when going after Acces files, but only asks me for login server, id, pw, etc... when I am using a report from my data in the application itself (in XML format).
Obviously that data doesn need a password, what do I do?