SetLogin and SetConnection
I am confused about the differences between SetLogin and SetConnection.
How come I don't have to use SetLogin on the primary report but I do on the sub reports? Do I have to use SetLogin on the sub reports if I used SetConnection on the primary report? If I do need to use SetLogin on sub reports, can I do that setting useIntegratedSecurity to true?
Can a report have more than 1 datasource and if so, can one use integrated security while the other does not?
And how do you set connection without specifying the server or database name? If you just want to use the ones specified in the report?