Search results for query: *

Hello, I sure hope that I am going to explain this well enough for everyone to follow along. I have been working on a report for a considerable amount of time. It is designed in Crystal 8.5 developer and the datasource is GoldMine 5.5 SQL 2000 SP3a. This report is a summary style report that...

Hello, I have written a report using CR 8.5 developer. It is suppose to log into a GoldMine database on a Windows 2003 standard server. The GoldMine backend is SQL 2000. I have setup a file .dsn for the report. It is not a complicated report either. I have 3 parameters on the report. 1 is a...

Hello, I need to write a report that groups all pending sales by 30 / 60 / 90 days from my print date. The sales force has been instructed when they forecast their sale to mark the field sales date - either 30 / 60 / 90 from the forecast date. We are using CR 8.5 developer and GoldMine 5.5 SQL...

alrighty - what the hey am I doing wrong here? CR 8.5 developer / GoldMine 5.5 SQL 2K My report has 1 group - conthist.userid. Then I have a handful of formulas. I'll give am example of my problem: Formula #1 counts # calls made within a date range: if {conthist.rectype} startswith "C"...

sorry about the confusing title. Did know what else to call it. I am writing a webpage using asp. I am trying to tie part of the webpage into another server that uses it's own login. I have my webpage divided by geographical regions. The theory goes that the end user selects their region and...

Hello, I have CE 8.0 standard that I got bundled with Crystal 8.5 developer. I have written a website that includes a login page. Ideally, I want to have the person login there and then go directly to their report folder in the repository. Of course I know that if I upgrade my standard to pro...

hello, I am writing a report (Cr 8.5 developer, GoldMine, SQL (MS2000)That is need to display summaries on a weekly basis. So I put in a group footer (based off of userid) a cross tab that only has 1 column for the date ({conthist.ondate}) and I have it counting history activities such as...

Hello, New Report, new dilemma, same database (GoldMine 5.5 MSSQL 2K - Crystal 8.5 Developer) This time I need to display all records/accounts that have pending sales. One of the field I need to display is how many days left until the sale date ({cal.ondate}) So I need a formula that takes...

Hello, I'm writing a financial summary style report that displays salespeoples activity/closing ratios (Crystal 8.5 developer, GoldMine 5.5 MSSQL backend) This is my formula problem right now: (sum({@hpw won}) * Average ({CONTACT2.USOBILLRAT}, {CONTHIST.USERID})) * 52 This formula is...

Hello, I need to write a summary style report that exports into Excel. This report tracks # calls made, # appts. I also need the report to show the #hits of calls made. Which we will have a field filled out when they get a "hit" (whatever that is). We are using GoldMine w/ SQL backend and I am...

Hello, I am writing a report using crystal developer 8.5 that goes into GoldMine (SQL backend) and first finds all of the pending sales in a given date range (which I can setup a parameter and then search by cal.rectype startswith "S")then I need to go into the history table and list the very...

I am writing a report in Crystal 8.5 developer that is suppose to display the company/contact based off of lastest activity entered and the user that did it. an example of what I need: area: Need To assign SalesRep: Joe ABC company Fred Jone 10/1/2003 an example of what I...

Hello I have a report that give numerical summaries of sales reps activities and pipelines. This reports is accessing a GoldMine SQL backend. The main report uses the history table and counts things like calls, appts, sales. The subreports (there are 5) that use date parameters that count...

Hi, What would make Crystal gpf when you export a report or when you try to browse the higher number page of the report? I am using a file dsn thru a sonic wall VPN. Everything is fine until I try to export or browse the results. I use the same crystal install to run other reports thru a...

Hello, I've been asked to create a report that counts forecasted sales within a date range. My only challenge with that is I will need to pull data from 2 different database tables to get my answer. that first table is conthist (yes, it's goldmine) and my second table is cal right now that...

Hello, I am writing this report that needs to count how many records have not been touched in "x" amount of days. I have posted this dilemma about a month ago but I had some emergencies to tend to and I am now ready to finish this thing. This is my enviroment: GoldMine 5.5, MSSQL 2K, Crystal...

Hello, I need to write a report that will show how many (numerical) records have not had a history entry on it in 180 and over 365 days. Basically, it is a slacker tattle tale report. The database is in GoldMine MSSQL 2K in the table conthist. How would I go about looking at these records to...

Hello, I have a client that would like to import contacts, email address and all email (filed and not filed) from GoldMine into their new Exchange 2003 server. I can easily get that information into and xml file. I was wondering if Exchange 2003 can handle that format for an import? TIA for...

Hi, I have installed Enterprise on my newly reformatted server. Crystal is the only thing asides from Windows, Legato (tape backup) and network assoc. AV. This server is running IIS5. When I first installed Enterprise, I was able to open the launchpad. Well the wind shifted and I can no longer...

hello, I need to get this website up and running yesterday and the pamphlet that came with the software is a bit light for my tastes. Where can I get more detailed info such as... if the crystal APS is accidentally deleted and a new one is created - how do I modify the login? I am getting...