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

let me add one other thing to this. On both the workstations and the designer, if the report does run and you select several users, you cannot export it on the first try. Crystal crashes (crw32.exe). It is not so much as the multiple users as the amount of data. I can have the same issue with 2...

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

well nevermind me. I just needed the teddy bear treatment. I figured it out

Let me add to this: In playing around, I have found that there is a form that the login calls up default.csp. In that page there is a response.redirect command (it looks like jscript) to point the user to the guest.csp. I need to somehow tell it that to not redirect my user to guest.csp but to...

I have also tried: If (Sum({@Calls}, {CONTHIST.USERID}) / sum ({@call hit}, {CONTHIST.USERID})) = 0 then 0 else (Sum ({@Calls}, {CONTHIST.USERID}) / sum ({@call hit}, {CONTHIST.USERID})) no dice. How frustrating

I figured out some of my problem. I had to change my formula for the division: (Sum ({@Calls}, {CONTHIST.USERID}) / sum ({@call hit}, {CONTHIST.USERID})) works just fine with the exception of if one of the values is 0 so I added this line to my formula: If sum({@call hit})=0 then totext...

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

I should add that the reason why I am doing this in a cross tab is that I need to export it to Excel and it is much easier to format. I am open to laying around with the layout

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

Where would I place this? The fields that are displayed are sum's of a field and a fomula. so if my formula is: if {cal.rectype}[1]="S" and {cal.ref} startswith "Static Guarding" then 1 else 0 and then I do a sum of that formula and place it in the group {cal.userid}, where does your formula...

what can I say? except doh! I'm having one of those days today. The DNS servers where these data servers are located keep failing and disconnecting Crystal. I have had to rewrite one of the reports and make new ODBC connections. thanks for the help wait! I remember what my hangup was. This...

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

I just figured it out on my little own and if you're curious, you were right. I guess that I needed the teddy bear treatment thanks a bunch for the help

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

The fields that I want the 0's to display are summaries of formula fields. There is nothing complex about the formulas - very simple stuff like: if {conthist.rectype} startswith "C" then 1 else 0 My problem with the 0's is appearing on the subreports (this summary report pulls from many...

I have been thinking about this one for a while and I was wondering if I did a TopN sort and set it on a formula that looks at creation date and record type of A (for appt) -descending and have it show N as 2. Then I was thinking of somehow creating 2 formulas to display first appt and then the...