Search results for query: *

The columns that are being tested for matches are all integers. So SOUNDEX is dismissed for that reason (I tried it on characters and worked like a charm). Any thoughts on how this can be done for numbers? Thanks. Numina.

My colleague is still looking for other options. This was his response: "Thanks! These are good options. I think these functions are part of the "Oracle Text" database "cartridge" of add-on functions. To use them the "Oracle Text cartridge" software has to...

My colleague posted a question about fuzzy logic (quoted message below). I am not familiar with the subject, so I would like to refer to the experts on Tek-Tips. “I am looking for a method of determining fuzzy matches, and hoping you have a suggestion for me. I am not referring to fuzzy...

Using the next function I will only have access to the record directly following the current record, whereas I need access to all records following the current record (for comparison). I thought this is possible because during the second pass, all rows are retrieved and can be accessed if I use...

Here are the formulas with @Set Arrays placed in 'Details a' and @Calculate Months in 'Details b': //@Set Arrays WhilePrintingRecords; Global StringVar Array Actions; Global dateVar Array Dates; redim Actions[6]; redim Dates[6]; // Store Actions into Actions Array if RecordNumber < 6 then...

For the last formula I need on my report, this a rather long question. The task is to convert a program into Crystal. The code stores the result of a query into multiple arrays, then does some calculations on the values stored in them and prints the results. To make the question simpler, I'll...

Just found out about another way of achieving this. You can use the following formula in the Section Expert Suppression option: RecordNumber > 7 numina

Does anyone know how to display only the first, say, 7 records on a report? Thanks! numina

Did 'verify database'. I got three pop up windows with the same message: &quot;Database is up to date&quot;. The view is still not coming up (Even after restarting CR). Is it a good idea to log this issue with PeopleSoft since I am using Crystal Reports for PeopleSoft. Numina

I'm not sure I understand. How do I verify my DB for CR? Could you please elaborate. Thanks. Numina

The database works. Maybe this has something to do with it, but I created the view using the Application Designer in PeopleSoft. But then it should work since I am able to query the view via sqlplus. Numina

I have been trying to figure out this problem for days. I have created a view in my database and tested it using plain sql. The view does come up in Brio Reports using the same user ID. The problem is I can't see it in my Crystal Report. I refreshed, logged out, even rebooted my machine, and...