I have to use a SQL command in order to write a crystal report and join 2 tables. The reason for this is that I need to link 2 fields but remove a few letters at the beginning or one to get them to link
FROM "mdb_rpt"."dbo"."gci_requests" "gci_requests"
LEFT OUTER JOIN "mdb_rpt"."dbo"."gci_act_log" "gci_act_log" ON ('cr:' + cast("gci_requests"."id" as nvarchar(15))) = "gci_act_log"."call_req_id"
I have a select statement at the beginning that pulls all my fields from each table. The SQL statement works fine although it is so slow when I am refreshing it. Is there anything I can do to speed this up, either modify my statement or a setting with in Crystal?
Help please......Lorri
FROM "mdb_rpt"."dbo"."gci_requests" "gci_requests"
LEFT OUTER JOIN "mdb_rpt"."dbo"."gci_act_log" "gci_act_log" ON ('cr:' + cast("gci_requests"."id" as nvarchar(15))) = "gci_act_log"."call_req_id"
I have a select statement at the beginning that pulls all my fields from each table. The SQL statement works fine although it is so slow when I am refreshing it. Is there anything I can do to speed this up, either modify my statement or a setting with in Crystal?
Help please......Lorri