Connect to shared CR Report

[Hillary]

Someone was kind enough to share a Crystal Report with me. Her database name is CSL_SALINE_DA and ours is CSL_WCSD_DA. Is there anyway to update the Crystal Report or do I actually have to rewrite the report?

I'm on CR 9.0

Attached is the SQL

SELECT "DA_SchoolStudent"."LastName", "DA_City"."Description", "DA_SchoolStudent"."BirthDate", "DA_StudentPhone"."BasicNumber", "DA_Address"."ZipCode", "DA_HomeRoom"."HomeRoomNumber", "DA_Address"."AddressLine1", "DA_State"."Description", "DA_SchoolStudent"."Gender", "DA_SchoolStudent"."Number", "DA_Grade"."Description", "DA_SchoolStudent"."FirstName", "DA_EthnicCategory"."Description", "DA_SchoolStudent"."D#EffectiveActive"
FROM ((((((("CSL_SALINE_DA"."dbo"."DA_SchoolStudent" "DA_SchoolStudent" INNER JOIN "CSL_SALINE_DA"."dbo"."DA_SchoolStudent_I_Phones" "DA_SchoolStudent_I_Phones" ON ("DA_SchoolStudent"."SchoolStudentID"="DA_SchoolStudent_I_Phones"."SchoolStudentID") AND ("DA_SchoolStudent"."QUID"="DA_SchoolStudent_I_Phones"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_HomeRoom" "DA_HomeRoom" ON ("DA_SchoolStudent"."HomeRoom#HomeRoomID"="DA_HomeRoom"."HomeRoomID") AND ("DA_SchoolStudent"."QUID"="DA_HomeRoom"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_Address" "DA_Address" ON ("DA_SchoolStudent"."PhysicalAddress#AddressID"="DA_Address"."AddressID") AND ("DA_SchoolStudent"."QUID"="DA_Address"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_Grade" "DA_Grade" ON ("DA_SchoolStudent"."Grade#GradeID"="DA_Grade"."GradeID") AND ("DA_SchoolStudent"."QUID"="DA_Grade"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_EthnicCategory" "DA_EthnicCategory" ON ("DA_SchoolStudent"."EthnicCategory#EthnicCategoryID"="DA_EthnicCategory"."EthnicCategoryID") AND ("DA_SchoolStudent"."QUID"="DA_EthnicCategory"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_City" "DA_City" ON ("DA_Address"."City#CityID"="DA_City"."CityID") AND ("DA_Address"."QUID"="DA_City"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_State" "DA_State" ON ("DA_Address"."State#StateID"="DA_State"."StateID") AND ("DA_Address"."QUID"="DA_State"."QUID")) INNER JOIN "CSL_SALINE_DA"."dbo"."DA_StudentPhone" "DA_StudentPhone" ON ("DA_SchoolStudent_I_Phones"."StudentPhoneID"="DA_StudentPhone"."StudentPhoneID") AND ("DA_SchoolStudent_I_Phones"."QUID"="DA_StudentPhone"."QUID")
WHERE ("DA_SchoolStudent"."D#EffectiveActive"=1 OR "DA_SchoolStudent"."D#EffectiveActive"=0)
ORDER BY "DA_HomeRoom"."HomeRoomNumber", "DA_SchoolStudent"."LastName"

Thank you,

Hillary

 

[GJParker]

As long as the structure is teh same in both db's i.e. table names fields etc.. you should be able to use 'set datasource location' from the database menu.

Craete a connection to your database and select update.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Hillary]

When I tried this before, I didn't realize this needed to be done one table at a time. Thanks, it works now : )

Hillary