Search results for query: *

Crystal Reports v.9 Goldmine/HEAT After installing Crystal v.9 I've noticed that each time I access various reports w/in one Crystal session I'm prompted to input the login credentials to the db. Is it possible to set this once from w/in Crystal so that it doesn't prompt me each time I access a...

Crystal 8.5 Goldmine 6.0 I'm trying to say the following w/my formula, If fieldname (CONTACT2.UGSTVALUE) is equal to "0.00" OR If fieldname (CONTACT2.UGSTVALUE) is empty then "Not Yet Renewed" else "Renewed" I have the following, IF (isnull({CONTACT2.UGSTVALUE})) then "Not Yet Renewed" else...

GM 6.0 Crystal 8.5 I need to know how I would phrase the following for my record selection formula, {CONTACT2.USTOPSRVDT} is not empty This is what I have but I don't think Crystal is recognizign "IS NULL" {CONTACT2.USTOPSRVDT} = '' OR {CONTACT2.USTOPSRVDT} <= ' ' OR {CONTACT2.USTOPSRVDT} IS...

GM ver. 6.0 Crystal 8.5 My report has the "Reference" field from an Activity (Sale) and I need it to only return the data that a person would actually input NOT the customer contact information. For example, a rep. completes a sale. When running the report it displays the "reference" field as...

I'm running a SQL query in GM and I'm stuck. My current query looks for all "additional contacts" where the company is "RIA" select contact1.key1, contact1.company, contact1.contact, contact1.address1, contact1.city, contact1.state, contact1.zip, contsupp.contact from contsupp JOIN contact1 on...

Crystal 8.5 GoldMine 6.0 I've designed a report that is a "weekly activity report" for sales reps. Currently my report has the record selection "Last full Week", however, I need to have the ability to run this either weekly or monthly. When launching the report, I want it to prompt the user...

Crystal 8.5 Goldmine 6.0 I've designed an 'activity report' that lists the "activity" of a particular person. In my report I have one group and one detail section. My report looks a little something like this: Group Header #1: [Group #1 Name] Column headings: USERID Activity Date...

Crystal 8.5 Goldmine database I'm creating an activity report that lists the activities (pulling from CONTHIST.RECTYPE) in the Detail section. The problem is that GM doesn't present the activity name, but rather picks up a 1-2 character "code" for the activity instead. GM Tech Support sent me...

In my report, I have a group and a detail section (that I need). The group breaks the report out by "user". The detail section shows data such as activities and each activity has it's own code (for example, "A"=Appt., "CO"=Outgoing call, "CI"=Incoming call, etc.) I want to get a total of each...