Search results for query: *

I'm trying to handle variations on the suffix Esq. in my database--Esq, Esq., ESQ, ESQ., Esquire. Are nested replaces the way to go or is there another function that deals with multiple conditions? I don't currently have any influence on getting the data cleaned up and consistent as quickly as...

Oracle 9, Crystal 9 I need to count the number of consecutive years (years is a text field) for donations per person with 2005 as the anchor date so. 2005 $100 2004 $50 2003 $50 2002 $0 then the count = 3 consecutive years 2005 $100 2004 $50 2003 $0 2002 $50 then the count = 2 consecutive...

I'm using Crystal Reports 9 with service packs 4 & 5 hotfixes up to date, Oracle 9. ODBC Data Sources lists Oracle in OraHome92 as the driver for db connections. When I set location in a Crystal Report, selecting the Oracle Server connection, the connection window header reads 'Oracle 8...

Crystal 9, Oracle 9 I have HP 3500 CP installed as a printer driver to accommodate wide design of some export formats. The limit to this 'printer' is 108 inches, not 108 ft as some posts here have indicated. I may soon be reaching this limit. Is there another driver that allows for a wider...

Crystal Reports 9, Oracle 9 In order to make use of server-side grouping, is it necessary to have all the report groups based on a SQL expression? I have a group @sortname. It is a concatenation of name.sortname + name.id since there can be duplicate sortnames in the table. Since a SQL...

I am using Crystal 9.2 on Oracle 9. I've read the FAQ 767-3825 with interest in getting better performance because the 'Accessing Database' stage is long. This is not being passed as SQL from record selection: ( if {?Exclude 1M} = 'Y' then {@Capacity>1M} = false else if {?Exclude 1M} =...

I'm using Crystal 9. When I include a weighted average summary in a crosstab, if the result is zero I get a blank that cannot be formatted as zero or '-'. I've accounted for nulls in my formulas of the fields needed for the average 'if isnull({table.field}) then 0' and I've set the report...

Oracle 9, Crystal 9 I'm trying to use SQL commands for the first time. I've created the command, saved it to the repository, placed it on a report and linked it successfully to a table. I can browse the fields of the command and see data but when I run the report, it is reading records 1 of 1...

Crystal 9, Oracle9 I have an individual table linked to a child table {individual.individualid} left outer join to {child.childid}. How can I select individuals who are parents of children over the age of 10 AND individuals without children?

In an export format intended for Excel I would like to conditionally suppress certain columns based on parameters. This is easy enough to do but is there a way not only to eliminate the fields but also the resulting blank columns in the export particularly if several adjoining columns are...

I am on Crystal 9, Oracle 9. Here is my table of gifts and donors. A donor can make gifts to multiple funds. Gift Donor Fund 1001 000120 Buildings 1002 000130 Research 1003 000140 Music 1004 000150 Scholarship 1005 000120 Research 1006 000130 Music 1007 000150...

I realized that sqlplus is not intended to handle elaborate formatting but I'd like to achieve the following if possible: a list of lookup table values with page break after each table. It should look like this based on select statements like: select table.field1, table.field2 from...

Crystal 9, Oracle I would like 1,200,000 to appear as 1.2 million but can't find the solution in the number formatting options except for selecting decimal point as the thousands separator symbol.

Sorry, I thought I was starting a new thread. Here it is: In Crystal 9, I've inserted a running total that resets to zero on page 2. I want to have a final total on the report footer and don't actually care to see the actual increments although I can't seem to suppress or hide the incremental...

I want to report on rows in several tables that have been updated within a specified date range. Except for each table having an update date, the tables are unrelated. How can I select address, job, and other tables that may have an ID in common but don't necessarily?

I want to produce an export to Excel that looks like this: Accounting Paul, Sam, Pete Marketing Sally, John, Mary, Karen instead of this: Accounting Paul Accounting Sam Accounting Pete Marketing Sally Marketing John Marketing Mary Marketing Karen To get values all in one row...

In Crystal 9 is there any way to tell if fields used in linking are actually indexed in the Oracle db? There is a colored arrow legend in Database Expert that explains the colors for different types of indexes but I don't see any of these colored arrows next to fields in the links screen. Does...

I run Shields Up scan regularly to check for vulnerable ports. It's been totally secure until today. It warned that port 1030 was open. ZoneAlarm Help does not really help you determine what to do about this. How can I tell what is using port 1030. I can't think of anything that has changed...

Is it possible to do record selection based on a summary field? I think this was not possible in early versions of Crystal and wonder if there is some workaround. An example: select all customers whose total purchases > $10,000 last year.

I am designing website of several pages. Certain text, images, and hyperlinks must appear on each page in the same location relative to one another as they are on the home page. I know the background image can be stored in the CSS. Can the overall 'template' of the home page be stored in the...