Has anyone run into the problem of the login failing when running more than one sub report? The main report and the first sub report work off the same sql view. The second sub report works of a different sql view but from the same database and the main report. All views use the same connect string using trusted connections. The report only fails when I assign the reportsource of the viewer when it contains the second sub report. I remove that sub report and the report runs again. I have tested the sub report and both work fine when run by themselves. I searched both Crytals and Microsoft sites on this without any luck. Any ideas?
Thanks in advance.
Thanks in advance.