CR Server XI Multi-DB authentication credentials

[dellguy]

I've created a report that pulls data from DB "a" and also uses a subreport that matches data from DB "b". It works great while running it from the desktop tool (CR Developer). When I upload it to CR Server, I can only specify one DB and set of credentials to run it from within the CMC. When it runs, it fails due to lack of credentials for the subreport.

Any ideas on resolving this one ?

 

[dellguy]

Sorry if anyone spent anytime thinking about this one. This was a total brain meltdown on my part. Each database that you access in the report has a separate source section in the CMC under Process/Database/Data Source(s).

For the life of me I can not explain why I didn't see it before. SORRY !!!