Crystal Reports and Clarion

1

Does anyone has positive experience with connecting CrystalReports on two SQL server databases.
Clarion needs to connect to traffic , yearly data in first database , and linked table is in another SQL server database.
I already have experience with CrystalReports and ODBC connectors through CrystalClear class.
Any guide or example ?

Thanks

2

I would do this on the server. Write a view or stored procedure on SQL server database 1 that joins the data from both databases however is required. Then use Crystal to access that view/store proc.
Keeps the double connection complexity out of Crystal’s side of things.

2 Likes
3

Yep. That way you can also verify the data on it’s own, massage it as needed before moving it in to Crystal

4

Elegant solution for new project . In our case , there are hundreds Crystal reports . We thought , in report call to after " SetAllTablesLogOnInfo " cheaply redirect one table to "SetTableLogOnInfo(‘LinkedTable’,clip(GLO:server),clip(GLO:database),clip(GLO:user),clip(GLO:PASSWORD2),true) ".
There is old one OCX topic
?CrystalControl{‘ReportFileName’}=vsu3.getexepath() & ‘test00.rpt’
! ne valja ?CrystalControl{‘PrintFileName’}=vsu3.getexepath() & ‘test00.rpt’
?CrystalControl{‘WindowState’}=2
?CrystalControl{‘WindowControls’}=true
?CrystalControl{‘WindowControlBox’}=true
?CrystalControl{‘WindowAllowDrillDown’}=true
?CrystalControl{‘WindowShowRefreshBtn’}=true
?CrystalControl{‘WindowShowSearchBtn’}=true
?CrystalControl{‘WindowShowPrintSetupBtn’}=true
?CrystalControl{‘WindowShowGroupTree’}=true
?CrystalControl{‘ProgressDialog’}=True
?CrystalControl{‘Destination’}=0 !0=window
?CrystalControl{‘DiscardSavedData’}=1
?CrystalControl{‘CopiestoPrinter’}=1 !Copies
X#=?CrystalControl{‘PrintReport’}

It works with flat tables , but don’t have full set of properties ( SQL Server and ODBC) .
May be someone has whole list ?