EnvironmentDomino Server
Windows XP
Ip : 10.10.20.29
Server name: document/Hovon
Admin Id
User name: admin
Password: password
Crystal Report Server R11
Windows Server 2003 SP 1
Server name: sharepoint
Ip : 10.10.20.17
Machine Admin
User name : Administrator
Password: password
Crystal Report Server R9
Windows Server 2003 SP 1
Server name: arcseve
Ip : 10.10.20.32
Machine Admin
User name: Administrator
Password: password
I follow the steps and the report cannot be previewed correctly, what wrong will my steps?
-
Install Crystal Report Server R9 or R11
-
Install Notes Client
-
Install NotesSQL 3.02 (ODBC Driver for Notes Database)
-
Copy admin.id of Domino Server to Crystal Report Server lotus notes directory
-
Set up NotesSQL Authorization List Manager
-
notes.ini directory set to louts notes client notes client directory
-
notes user name set to admin.id
-
-
Configure ODBC Connection to Domino Server in Crystal Report Server
Remark: NotesSQL Options: has tried to the case Add User of admin/Hovon
- Copy the report format to Crystal Report Server
Crystal Report Server 9- C:\Program Files\Crystal Decisions\Report Application Server 9\Reports
Crystal Report Server 11- C\Business Objects\ Business Objects Enterprise 11\Web Content
- Set the virtual directory in IIS
Crystal Report Server 9
Name: crystal
Path: C:\Program Files\Crystal Decisions\Report Application Server 9\Reports
Crystal Report Server 11
Name: crystal
Path: C\Business Objects\ Business Objects Enterprise 11\Web Content
-
Open the report format by Crystal Report Designer and preview the data, it works fine
-
Install the ActiveX Viewer at client
-
In Domino Application, add a button to prevent the report. It should launch a viewer to prevent the report, however it becomes to lanuch the attachment instead.
The code for the button:
var report = new String();
//search report by Item ID
if (document.forms[0].TRIIDF.value!=“” & document.forms[0].TRIIDT.value!=“”){
report = “http://10.10.20.32/crystal/DiscrepancyReport.rpt?apsuser=Administrator&apspassword=password&apsauthtype=secEnterprise&user-ESLPDCM.=admin/Hovon&password-ESLPDCM.=password&sf={_Report_Queue_By_IPROD_.IPROD}in’“+document.forms[0].TRIIDF.value+”‘to’“+document.forms[0].TRIIDT.value+”'and+Length({_Report_Queue_By_IPROD_.IPROD})<=”+document.forms[0].TRIIDT.value.length+“+and+Length({Report_Queue_By_IPROD.IPROD})>=”+document.forms[0].TRIIDF.value.length;
}
//alert(report)
window.open( report, “CR_Report”, “resizable” ).focus();