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!

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

Search results for query: *

  1. sharvey90

    Crystal v.9

    Right. I understand that. What I'm saying is that w/in the same Crystal session it prompts me each time to enter the db/server password. Any idea how to ensure it doesn't prompt from report to report?
  2. sharvey90

    Crystal v.9

    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...
  3. sharvey90

    Multi-expression formula

    NEVERMIND, I got it. If {CONTACT2.UGSTVALUE} = '0.0' then "Not Yet Renewed" else (If (isnull({CONTACT2.UGSTVALUE})) then "Not Yet Renewed" else "Renewed")
  4. sharvey90

    Multi-expression formula

    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...
  5. sharvey90

    Record Selection

    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...
  6. sharvey90

    GM & Crystal: Function to start at a certain position

    The only thing that was physically input into the reference field was "Product A". The "(oc: John Smith) is being picked up from whomever was listed as the "contact" in the "contact" field.
  7. sharvey90

    GM & Crystal: Function to start at a certain position

    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...
  8. sharvey90

    SQL query in GM

    I played around w/the query and was able to figure it out. Sharon
  9. sharvey90

    SQL query in GM

    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...
  10. sharvey90

    Prompting for date

    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...
  11. sharvey90

    Grouping and page breaks

    I just noticed something. When I uncheck the "Keep together" box, it only groups the last two users together. Each of the others begin on a new page even if the entire page isn't utilized.
  12. sharvey90

    Grouping and page breaks

    I did have "Keep Group Together" checked. When I uncheck, it prints on the same page. When I had it checked, it did not - which is what I want. My problem is that it's inserting a blank page (w/the group header) before each "user" section.
  13. sharvey90

    Grouping and page breaks

    I did have "Keep Group Together" checked. When I uncheck, it prints on the same page. When I had it checked, it did not - which is what I want. My problem is that it's inserting a blank page (w/the group header) before each "user" section.
  14. sharvey90

    Grouping and page breaks

    I've tried this earlier, and while it does work, it puts several "blank pages" into the report. Any ideas on why it's doing this?
  15. sharvey90

    Grouping and page breaks

    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...
  16. sharvey90

    Displaying &quot;name&quot; instead of code that pulls from database

    In response to Kchaudhry: Once I create the formula where do I put it on the report? Do I replace my current field object [rectype] with the formula I created? In response to rosemaryl: I'm very new to Crystal, how do I create a case statement and where would I (or do I) put this on the report?
  17. sharvey90

    Displaying &quot;name&quot; instead of code that pulls from database

    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...
  18. sharvey90

    Summarizing Group Section (GoldMine user)

    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...

Part and Inventory Search

Back
Top