Search results for query: *

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.

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

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

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.

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

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

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.

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

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.

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?

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

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

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

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.

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

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

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

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

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

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