Recent content by princessinthetower

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?