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

    sql command

    I did say Oracle. It's an Oracle Server connection The ID field is linked to just one table and that table linked to others. The ID field is indexed in all tables. The records are read faster when I access the other linked tables without the SQL command.
  2. atthevilla

    sql command

    Crystal 10, Oracle 10. I have a SQL Command that I want to use as a source for my Crystal report. It has only one field--ID. When used alone, it runs quickly. When I link other tables to it, it reads records only a few per minute. If I Show SQL Query, I notice that there are 2 separate...
  3. atthevilla

    views vs commands

    Oracle 10g, Crystal 10. I designed 2 reports, one using a view and another using a command. The command is much slower in reading records (10 minutes vs 4 minutes) even though it has the same syntax as the view. One advantage of a command is the ability to allow parameter input so I want to...
  4. atthevilla

    Record Selection puzzle

    Yes, I'm reporting on a materialized view and it's padded all the VARCHAR2 values in this field out to 65. I think I need to take this up with the IT Dept. Sigh.
  5. atthevilla

    Record Selection puzzle

    Yes the field in question is padded but I found the reason for the inconsistency with different fields. For example, {BIO.CONSTITUENT_VALUE} = "Alumni" selects the correct number of records without trimming. The field that succeeds in record selection is a CHAR field, the one that fails is a...
  6. atthevilla

    Record Selection puzzle

    Crystal 10, Oracle 10g. My record selection is producing 0 records: {ADDRESS.REGION} = "New York City" 0 records selected When I change the record selection to this, I get correct results: trim({ADDRESS.REGION}) = "New York City" 36,738 records selected Or to this: {ADDRESS.REGION}...
  7. atthevilla

    Unhandled Exeception Error Occurred

    Try right clicking on the report icon and selecting 'Restore Previous Versions.' This worked for me at one time when I had a similar problem setting the location. You may be able to capture an earlier good version before the report became corrupted.
  8. atthevilla

    threshold date

    Oracle 10g, Crystal 10. For fundraising, I would like to capture the date when a donor has reached a threshold of $10,000 within a fiscal year. There may be multiple gifts from this same donor: 06/01/2008 $5,000 07/01/2008 $4,000 10/01/2008 $1,000 12/01/2008 $2,000 The pertinent date here is...
  9. atthevilla

    export to odbc

    I found the solution. I had another group below ID in the report that I eliminated and the distinct records now export. The Select Distinct option has never worked in the way I would expect but removing that other group does the trick. Thank you.
  10. atthevilla

    export to odbc

    I'm on Crystal 10, Oracle 10g. My Crystal report has duplicates due to one to many links. I eliminate these through a group based on ID and any exports to XLS, text, etc are OK. But my export to ODBC results in a table with duplicate IDs. How can I get an ODBC export with each row a different ID?
  11. atthevilla

    wider width of report needed

    Yes, I couldn't get the 3500 driver from Windows Update but the HP Designjet 4500 was available and did the trick. Thank you.
  12. atthevilla

    wider width of report needed

    I need a wide report area for exports with many columns. I know that this is determined by the printer setup. Previously with XP I set up a virtual printer that allowed wide printing. I'm now on Vista and my previous printer set up is gone and I can't see all my columns. What driver can I...
  13. atthevilla

    export leading zeroes to excel

    Crystal 10, Oracle 10g. I remember there being an issue with an earlier version of Crystal reports in exporting fields with leading zeroes to Excel. If IDs or zip codes began with zeroes, these would export to Excel without the zeroes unless the zip code had a hyphen. My fix was to create a...
  14. atthevilla

    corrupted rpt

    Yes. If I create a new report I am able to export and get the correct result. My question is about preventing corruption of existing and future reports.
  15. atthevilla

    corrupted rpt

    Crystal 10, Oracle 10g. I've been running into some trouble with a report of some complexity that seems to have become corrupt. The preview looks fine but the export to excel shows IDs repeating and filling into cells below that should be blank. I got a 'crw32 has encountered a problem and...
  16. atthevilla

    sql commands

    Crystal Reports 10, Oracle 10g. I'm trying out the practicality of SQL commands because requesting custom views from our IT dept sometimes takes way too long. So far the SQL commands work and do what I want but are slower than comparable views. Are there any settings that I need to be aware of...
  17. atthevilla

    anonymous translation

    Crystal 10 Oracle 10. Looking for ideas. I need to create a translation table of constituent IDs and anonymous dummy record IDs that will allow me to combine the constituent donations into the anonymous record donations and show the total as one anonymous donor in a Crystal report grouped by...
  18. atthevilla

    footer above detail

    Yes variables were necessary and the results need to be placed in the report footer. Group totals not possible in this instance. Thank you.
  19. atthevilla

    footer above detail

    I'm using Crystal 10 on Oracle. I have a report with the results of a series of variables in the report footer as a summary. I would like to display record detail (by parameter option) but below not above the footer. To achieve this, I saved the report as a subreport and placed it in the...
  20. atthevilla

    count by summary range

    I see. Hope I didn't offend you too much.

Part and Inventory Search

Back
Top