Forum Discussion

rabin_ranabhat's avatar
rabin_ranabhat
Occasional Contributor
12 years ago

Establishing connection between Crystal Reports and ALMComplete

Hi, I am trying to create a custom Crystal Report from scratch. When I click on the Blank Report, the  Database Expert prompts to create a new connection. When I click the ODBC(RDO), the next s...
  • ben_jean-louis's avatar
    ben_jean-louis
    12 years ago


     



    Hello Rabin,



    If you are still experiencing this issue, we would love to help. Please submit a ticket using the Help Center link found with in the system.





    Thanks,



    Ben Jean-Louis



     


rabin_ranabhat's avatar
rabin_ranabhat
Occasional Contributor
11 years ago


Sorry, I forgot to include the preceding steps before you try to create a connection from Crystal Reports. Here are the steps.

1.1) Open Windows Explorer on the server hosting Crystal Reports.



1.2) Navigate to C:\Windows\SYSWow64 directory, locate odbcad32.exe, right-click on the file and select Run as Administrator.



1.3) Navigate to the System DSN tab in the ODBC Data Source Administrator and select the Add... button.



1.4) Enter agSPEnt in the Name field, specify the server where your SoftwarePlanner DB is located in the Server field and click Next.



1.5) Select the option to use SQL Server authentication, enter psUSer in the Login ID field and the user's password in the Password field and click Next.



1.6) Select the Change the default database to: option, use the drop down to select the SoftwarePlanner database and click Next.



1.7) Click Finish and then the Test Data Source... button to ensure a successful connection to the database then OK 3 times to exit the program.