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

Users will look at this report, sort it in a variety of ways, and further manipulate the data. Previously, export to Excel extended allowed me to make each column the same 1/4 inch length and the fields would expand as needed. I'm told that Crystal 10 does not support Excel extended. With...

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

The parameter is FiscalYear. The summaries I need are total gifts and average gift, among others. There is a left outer join from the Name ID table to the gift summary table. Some IDs have multiple gift summaries for different fiscal years. Some have no gift summary. I can't do an overall...

Thanks for the response. This is the first time I tried SQL Expressions and found that you can't pass a parameter to a SQL Expression. UNfortunately I need to do that.

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

I think I will have to include the table in the command, just confused about why everything I read says these can be combined on a report when that's not exactly the case. My first choice is to use views, but right now I have insufficient privileges to create them. Thanks for the response

Follow up. The report works only if I use the command as the driving table. Then 'Show SQL Query' displays the command with no reference to the other table. If I reverse the direction of the links, 'Show SQL Query' displays the select statement for the table not the command and the report...

It is a left outer join. I tried linking the table itself and there are multiple matches. When I link the command based on that same table, there is only one and the report stops responding.

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'm sorry to confuse you. I am getting the correct results from my query; I just used 'lookuptable' as a generic example. I will have 30 or more tables. Instead of select table.field1, table.field2 from lookuptable; I should have said select code, value from Countries; select code, value...

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.