I currently create reports using multiple ODBC connectors to several different databases & types (MSSQL, postgre, DB2, MySQL). This has worked OK so far but I'd like to get to a point to where I don't have to have 18-20 different table nodes & names w/ 1 - 30 items in each node.
Is there a way to open multiple connections to different data bases through the Crystal Reports query tool? In PHP it's as simple as doing something like this:
$server="192.168.xxx.xxx";
$user="user";
$pass="password";
$conn=mssql_connect($server,$user,$pass);
I'd like to know if it's possible to do something like that in Crystal.
Thanks!
Is there a way to open multiple connections to different data bases through the Crystal Reports query tool? In PHP it's as simple as doing something like this:
$server="192.168.xxx.xxx";
$user="user";
$pass="password";
$conn=mssql_connect($server,$user,$pass);
I'd like to know if it's possible to do something like that in Crystal.
Thanks!