User Defined Field Setup Crystal Reports 8.5

How does one create a user defined field in Crystal Reports 8.5. I needed a field in IQMS to enter employee information so I created a user defined setup with a pull down menu, but I have to now add the field to the table that is being used in Crystal Reports but I don't know how.

Iona5 pointsBadges:

Crystal Formula – Maximum of a Running Total/Count?

Hi Everyone, I have a Crystal Report with the usual group headers/footers & detail section. On my detail section I have a 'running total' it is a count function and it counts the number of lines based on a Unique Reference Number But my problem is that I want to get the Maximum of this count. So,...

Paullyie10 pointsBadges:

runtime error “server has not yet been opened”

Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.

Bliever20 pointsBadges:

Crystal Reports VII, viewing data while using select expert

Sorry if this duplicated, I thought I posted this but I can't find it anywhere here goes I created a report with crystal 7 and I using the select expert  for a particular field/table. When I use the expert the drop drown menu does show me every thing in the table. Is there a limit to how many...

Joefk30 pointsBadges:

can I use accdb with Crystal report 8.0?

can I use accdb with Crystal report 8.0? Please help.

Anis20055 pointsBadges:

Crystal Reports grouping by date

Hi, I'm trying to group single dates (eg. 1 Jan 09, 9 Jan 09, 11 Jan 09, etc) by weekly interval (e.g. 1-7 Jan 09, 8-14 Jan 09, etc). Any suggestions please?

M13art50 pointsBadges:

Crystal 8 & SQL problem

I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

Virtualfrankdotcom20 pointsBadges:

Select printer from CRViewer in VB 6.0 and Crystal Reports 8.0

i use Rpt.PrinterSetup Me.hWnd this, to set up printer setup. it prints blank page

Madhura1210 pointsBadges:

Refresh/Run SQL

We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

CrazyCoder5 pointsBadges:

More than one level nesting in crystal reports

Hi, **************** Using: Crystal reports XI release 2 Database - DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen B ->...

Svijaykanth50 pointsBadges:

Crystal Reports Formula

I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential - IL - Waukegan...I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there is one name...

Ckoof5 pointsBadges:

Formula setup on the crystal report

I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?

2682235 pointsBadges:

view data from ODBC to Crystal Reports

i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:

Sryn5 pointsBadges:

VB 6, SQL Server 2000 & Crystal Reports

i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.

RAYNISH35 pointsBadges:

I use crystal report version 1o

I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is the field i need to display...

Alberto6335 pointsBadges:

Crystal reports, change recurrance pattern

Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my...

Dap02205 pointsBadges:

Crystal report xi parameters

I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report but...

Ssdan5 pointsBadges:

Inserting Subreport Problem

When I insert my third subreport into my main report I get a message "Performing this action will cause all open subreports to be closed" Why can't I insert my remaining sub report?

45apple5 pointsBadges:

Crystal reports formula – equal or less than 60 days

Hi I am using crystal report XI I am trying to set -up a formula to retrieve all records where the Expiration EndDate <= 60 Days to Current date. Thanks.

Monk200830 pointsBadges:

Crystal Reports in vb.net

iam getting error while making connetion to sql server by OLEDB provider. The error is Sql server does not exit or access is denied ,sqlstate 08001

Shaz255 pointsBadges: