Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports w/Goldmine

Status
Not open for further replies.

Donia

Technical User
Jun 30, 2005
2
US
I need help creating my reports by pulling data from Goldmine. It's been about 2-3 years since I've worked in the Crystal Reports environment. I'm designing a report that will have a field for info needed between a date range. Can someone help me. Thanks!
 
First of all you have to create an ODBC connection to the GoldMine database. Are you using dBase or SQL.

Secondly you will need to create parameter for a start date and an end date that will allow you to enter these dates when you run the report.


Jason Wienert
Brisbane, Australia
GoldMine, Avaya, ACCPAC CRM
 
Thanks for responding. I have an ODBC connection and I'm using SQL. Do I have to do a formula? or is there a simpler way. The reports I need to run will have data based on a date range. Each month I run it, I want to be asked to input the range. Am I on the right track?
 
Create a parameter field, make it a date range parameter. Then write a record selectio formula:

{YourDateField} in {?DateRangeParm}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top