If when attempting this you receive an error stating ” The Data Explorer will appear as pictured below. In the window that appears, enter your Remedy account username and password and click Next. Resources for IT Professionals. Fields Cells i, 2.
|Date Added:||2 July 2011|
|File Size:||67.12 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Try this and tell me what you get: Try changing the qualification s to make sure. Office Office Exchange Server.
Integrating Crystal Reports x with Remedy
I can see all the column headers, but all the fields are emtpy. Sign in to vote. Creating and Configuring a Report 4. What to do if No Data Appears. Thursday, April 19, 7: The Standard Report Creation Wizard appears.
This is my current script. Not an IT pro? Fields Cells i, 2. This document explains the configurations necessary to report on Remedy data inside Crystal Reports version Database support is elsewhere. In this dialog box, we suggest clicking on “Add to Favorites” so that ar system odbc data source don’t need to continue repeating these steps each time you want to connect to the Remedy database.
After qualifying your search and customizing the other tabs as you desire, click the Adta button to create your report. Go to the Fields tab and select which fields you would like to report on and click the Next button.
Marked as answer by GeorgeD16 Friday, April 30, 2: Open sSqlSelect, adoConnect ar system odbc data source Find out if the connection worked. Remove From My Forums. If you have entered your login information correctly, you will now be connected to the Remedy database and will see the image below.
Try searchig by your product full name for the correct vendor as ARS is produced under various vendors for different products and all are called AR System. The Data Explorer will appear as pictured below.
I debugged the adoRecSet variable and I confirmed that there is no values in the table. Integrating Crystal Reports From our experience it’s a lot easier to see exactly what you are doing in the Design tab.
ODBC Driver 7.1
Configure the Data Source setup tool for your specific purposes. You may customize the “Grouping” and “Template” tabs as you desire to create the type of report you want. ar system odbc data source
Helpdesk from sysstem list of available Data Sources and click on the “right” arrow in between the “Data Sources” and the “Selected Tables. Configuring the Database Connection 3.