This is not something the Reports module supports natively, but it is a feature that is high on the roadmap for the next major release (there is currently one in the pipeline that should be out soon, this feature will be in the one after that). However, you might be able to "hack" around that limitation by using some SQL tricks, for example, you may be able the use the "USE" command to change to that database like so:

USE Intranet
GO
SELECT .... FROM Staff....
GO

That might allow you to access the other database, but I can't guarantee it. As I said, the "version 5.0" release (not the one currently in the pipeline but the next release) is planned to have a feature called the Data Source Framework, which will allow you to select from many built-in and third-party provided Data Sources such as other databases on the current SQL Server, other SQL Servers, Oracle Servers, MySQL, XML, etc.

---

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

That is the only way to do this in the current version, assuming it works.

---

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer