Search results for query: *

Is it possible to create a formula that displays the last date from a field that contains several dates? I have a sales database that contains several users, contacts, and dates of their appointments. I would like to create a formula in which I can view just the very last date they contacted...

Hello all! I am a beginning Crystal user and am having trouble creating a formula to do the following: * I have a string field ({Rep}), that contains a user ID number and their name. The ID number is always constant, but may contain a different beginning variable. This will be either a...

Is this possible? Can I take my existing CR 8.5 reports and publish them to my CE 9.0 server??

This error occured literally "out of the blue". Here is the enviroment: Software: GM 5.7.2404 Windows 2000 Server SQL 7.0 SP3 Hardware: Quad Xeon 2 GB RAM 60 GB HD Users: 350 Users We have begun to receive the following SQL error at logon: General SQL error. Native SQL error...

Taken from RedHat's web site: "The X Configuration Tool will backup your system's original video configuration file to /etc/X11/XF86Config.backup in case you need it to switch back." OK, how do you "switch back"?? The documentation tells you this done, and the file exists...

Gurus: First of all, I'm a newbie when it comes to Linux. I've read and been on the sidelines for a while and finally took the plunge - only problem is, I fear I'm drowning in documentation overload and cannot find an answer...which leads me here... I have a couple of questions that I hope...

Here is my scenario, I have a parameter field which requests a user ID, which is proper name, like 'Smith'. The report contains 5 "key" fields which could contain this proper name. The goal is to generate a report which uses the parameter field to query against all of the key...

How does one create a report that uses a date range to display data. I have to create a Birthday report which has a date parameter. Here is an example: 2/12/2003 - 3/12/2003 (the dates are arbitrary...they could be anything). The data fields in the table are strange, here are the table/field...

I have a report that requires a formula that I cannot figure out. Here are the details. I have a field that contains any number of "numbers", theoretically, 1 to infinity. What I would like to do is create forumla that will display the HIGHEST number and the information tied to that...

Guru's: I have a difficult problem that I cannot seem to find the correct terminology for. Hopefully you can help. I am creating a report that draws from two seperate fields from a SQL database. Both of these fields are simple text. Here are the fields and the layout in the DETAILS...

Is there anyway to the following. I have source for my data, two different tables. One table contains the Users ID, let's call this {TABLE1.USERID}, next I have Login time which I would like to report against as well {TABLE2.LOGIN}. My goal, which is 1/2 way completed, is to create a report...

I have an aggregate forumla that sums and does some other mathmatical manipulation to create an end desired result. The data is taken from the details area, which suppressed, the answer being shown in the group #1 footer. An example of the output would be: Joe $100,000 Jim $ 65,000...

How would I go about creating a forumla to calculate sales figures based on the current quarter given the current date? (i.e., today). Here is what I would like to create: Name Current Quarter Mike $7,000,000 Josh $5,000,000 Joe $1,000,000 Lester $500,000 The dollar figures...

I hope I can get can again call on your alls wisdom and experience... I have a parameter field named "RepName" which I use to bring up a drop down list of sales reps. This selection criteria allows the user of the report to narrow down the report to that one rep (duh!). Anyway, I...

Situation: SQL 7.0 DB Data Table: {OPMRG} Fields: OPID, RECID, COMPANY, STATUS Construct of DB: OPID RECID COMPANY STATUS -------------------------------------------- 9AXF OC ABC Co. <NULL> 8ZWB OC XYZ Inc. <NULL> 8ZWB OI 200...

Does anyone know why one CANNOT sum a {@formula} field? I have a numeric formula, which is simply a subtraction of two other formulas. E.g., {@Total_time_in_seconds} is equal to {@LoginSeconds} - {@LogoutSeconds}. The summation features, i.e., sum, grand total, running total are all gray'd...

To All Crystal Experts: Need some help please! The following formula I have is based on a forum post, which is pretty close to what I require, however, I just cannot seem to get it quite right. I did make some minor changes from the original post to suit my needs. Any help would be much...

How would I go about converting a SQL 7.0 string field that contains a date and time string? The field is called {USERLOG.LOGIN}, an example of the data looks like this: 20020315 13:04 What I would like to do change this to (eventually): 03/15/2002 1:04 PM How can this be done? I am a...

Can this even be done? Please read below... I have data in a field that must be extracted out and only a portion of it used. Unfortunately, this field is the only field that contains the data needed. Here is an example: The field name, for example, is {CONTACT.REFERENCE}. When displayed in...

I have these two columns of string variables, client and prospect (see below), I would like to get a sum of each column: C............P.... ------------------- SC................ SC................ SC................ NSC............... NSC............... ............HPP... ............LPP...