Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. princessinthetower

    replace function

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

    consecutive years

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

    oracle 8 server

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

    wide printer driver

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

    wide printer driver

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

    sql expressions

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

    SQL pass through

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

    weighted average in crosstab

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

    weighted average in crosstab

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

    weighted average in crosstab

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

    SQL Command

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

    SQL Command

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

    SQL Command

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

    SQL Command

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

    record selection and left outer join

    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?
  16. princessinthetower

    Suppressing columns in export

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

    Complex record selection

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

    formatting output

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

    formatting output

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

    number format question

    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.

Part and Inventory Search

Back
Top