Have you thought of using a stored proc. In the proc it should be simple to reference the other database...or you could have a synonym created in one database that references a table in another database, and then you can use the synonym as if it were a local table to the database.

just some thoughts,
HTH

it's just setting data sources and some value that can be used to retrieve the data in a subreport to the main report...or it's a synonym and use that to join the 2 tables together to retrieve the data.

it's all basically the same, as you need to get data out of one database based on a value from the other, and then display it.

HTH

since the data in rpt2 is at midnight, create a formula to translate your apptstart to midnight of the same day...
something like:
cdate(year({table.apptstart}), month({table.apptstart}), day({table.apptstart}))

cdate may be the wrong command, but it will be something close...

now link the report to the subreport using the formula, which should work now since the dates are the same.

HTH

Below is the SQL Query that I've got so far. It gives me 193 records and the total I need is 1859. So this is still only giving me data in MPCCPS that is in Limesurveydev, when I need all data in MPCCPS.

jdbc:mysql://limesurveydev/limesurveydev
SELECT `Michele_View`.`99946X10X1391`, `Michele_View`.`99946X10X1293`, `Michele_View`.`token`
FROM   `limesurveydev`.`Michele_View` `Michele_View`
EXTERNAL JOIN Michele_View.99946X10X1293={?MPCCPS: Command_1.OwnerId} AND Michele_View.token={?MPCCPS: Command_1.DateLink}


MPCCPS
SELECT "uvPatientDemographics"."PatientReferenceSource", "uvPatientDemographics"."FacilityName", "uvPatientDemographics"."PatientFullName", "uvPatientDemographics"."PatientId", "Appointments"."ApptKind", "Appointments"."ApptStart", DATEADD(dd, 0, DATEDIFF(dd, 0, "Appointments"."ApptStart")) as "DateLink", "Appointments"."Status", "ApptType"."Name", "Appointments"."OwnerId"
FROM   (("mpc"."dbo"."PatientProfile" "PatientProfile" INNER JOIN "mpc"."dbo"."Appointments" "Appointments" ON "PatientProfile"."PatientProfileId"="Appointments"."OwnerId") INNER JOIN "mpc"."dbo"."uvPatientDemographics" "uvPatientDemographics" ON "PatientProfile"."PatientProfileId"="uvPatientDemographics"."PatientProfileId") INNER JOIN "mpc"."dbo"."ApptType" "ApptType" ON "Appointments"."ApptTypeId"="ApptType"."ApptTypeId"
WHERE "Appointments"."ApptStart">={ts '2012-07-16 10:30:01'} AND "Appointments"."ApptKind"=1 AND "uvPatientDemographics"."PatientReferenceSource"='Hope'
ORDER BY "uvPatientDemographics"."PatientFullName"
EXTERNAL JOIN Command_1.OwnerId={?jdbc:mysql://limesurveydev/limesurveydev: Michele_View.99946X10X1293} AND Command_1.DateLink={?jdbc:mysql://limesurveydev/limesurveydev: Michele_View.token}

Finally got the above to work... such a simple fix it was... but now I'm trying to join in another database and my errors are "incorrect syntax" near the "Where" statements are.

SELECT DB='MPC', "uvPatientDemographics"."PatientReferenceSource", "uvPatientDemographics"."FacilityName", "uvPatientDemographics"."PatientFullName", "uvPatientDemographics"."PatientBirthDate", "uvPatientDemographics"."PatientId", "Appointments"."ApptKind", "Appointments"."ApptStart", DATEADD(dd, 0, DATEDIFF(dd, 0, "Appointments"."ApptStart")) as "DateLink", "Appointments"."Status", "ApptType"."Name", "Appointments"."OwnerId"

FROM ((("mpc"."dbo"."PatientProfile" "PatientProfile" INNER JOIN "mpc"."dbo"."Appointments" "Appointments" ON "PatientProfile"."PatientProfileId"="Appointments"."OwnerId") INNER JOIN "mpc"."dbo"."uvPatientDemographics" "uvPatientDemographics" ON "PatientProfile"."PatientProfileId"="uvPatientDemographics"."PatientProfileId") INNER JOIN "mpc"."dbo"."ApptType" "ApptType" ON "Appointments"."ApptTypeId"="ApptType"."ApptTypeId"

WHERE "Appointments"."ApptStart">={ts '2012-07-16 10:30:01'} AND "Appointments"."ApptKind"=1 AND "uvPatientDemographics"."PatientReferenceSource"='Hope'


UNION

SELECT DB='MBC', "uvPatientDemographics"."PatientReferenceSource", "uvPatientDemographics"."FacilityName", "uvPatientDemographics"."PatientFullName", "uvPatientDemographics"."PatientBirthDate", "uvPatientDemographics"."PatientId", "Appointments"."ApptKind", "Appointments"."ApptStart", DATEADD(dd, 0, DATEDIFF(dd, 0, "Appointments"."ApptStart")) as "DateLink", "Appointments"."Status", "ApptType"."Name", "Appointments"."OwnerId"

FROM ((("cpssql"."mbc"."dbo""PatientProfile" "PatientProfile" INNER JOIN "mbc"."dbo"."Appointments" "Appointments" ON "PatientProfile"."PatientProfileId"="Appointments"."OwnerId") INNER JOIN "cpssql""mbc"."dbo"."uvPatientDemographics" "uvPatientDemographics" ON "PatientProfile"."PatientProfileId"="uvPatientDemographics"."PatientProfileId")
INNER JOIN "cpssql""mbc"."dbo"."ApptType" "ApptType" ON "Appointments"."ApptTypeId"="ApptType"."ApptTypeId"

WHERE "Appointments"."ApptStart">={ts '2012-07-16 10:30:01'} AND "Appointments"."ApptKind"=1 AND "uvPatientDemographics"."PatientReferenceSource"='Hope'

ORDER BY "uvPatientDemographics"."PatientFullName"

The problem with DB1 and DB2 is that the patientID's are not the same, however for the limesurveydev and DB1 they are the same. So DB2 has to be pulled over by patient name and birthdate... all need to euql Patient Reference Source "Hope" and all appointments after 6/30/2012.

Ideas?????