Search results for query: *

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

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

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'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?

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

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

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

Crystal 10 I know about Group Sort but I can’t quite figure this out. I need to calculate the number of items within a price range. If I create a summary sum({table.price}, item) and I want to count the number of items within these price ranges: $1 – 99 $100 – 499 $500 – 999 $1000 and over...

In my database, I have Prospects, Actions, Tasks, and Managers. One fundraising action for a prospect may have many tasks assigned, each task to a different manager. I need to determine how many actions are 'joint' (e.g., one action is a visit to a prospect and two managers go on the visit)...

Crystal 10, Oracle 10. I have a database of potential donors at different stages of cultivation-A,B,C,D,E. There are multiple cultivation rows per donor each with a date. For example, if someone moves from stage A dated 1/1/06 to stage B dated 9/1/06, that is a current month move, How can I...

This is the query I'm working on: SELECT ID, MAX(AMOUNT) FROM GIFTS GROUP BY ID This gives me the correct amount but I also need the year associated with the largest amount for each ID. The query below which includes the year will give me only the maximum per ID per year. Is there a way...

Crystal 10, Oracle 10. I need to determine get largest gift for each donor: maximum({TABLE.PAID_AMT},{TABLE.COREID}). But I need to count multiple transactions from that came in on the same day from a single donor as a single gift (they split the money between two or more funds). How can I...