R&RSQL v 12.1.001 - Oracle problem

[timjacob2001]

I have a report that we have been using successfully for some time now, reading from an Oracle database. Last week, it only displayed transactions from customers #4931 and up. This week, it^s only displaying from #4949 and up, some 21000 records. It would appear that somehow there is a limitation that makes the results change as more data is entered.____If I copy the exact SQL statement generated in R&R^s "Show SQL" window, and paste it into PL/SQL, a utility for working with Oracle, PL/SQL displays all the transactoins from #1 on, some 81000 records, so it doesn^t seem to be Oracle that^s the problem.____Can anyone give me a clue as to what to look for?____Many thanks,__Tim____

[timjacob2001]

Found out a bit more. I can get everything by querying for a specific date range as long as I don^t query for too much. I can get the earlier numbered customers by specifically querying for a portion of the whole. ____It would appear that R&R SQL has a limit on the amount of data it can process.

[kfleming]

Does the report have any local sort or filter? If it does you will see a records processed window when you run the report.____To the best of my knowledge there is nothing in R&R that would cause a limit on the data that would be returned from a SELECT statement unless you specifically select Database Limit Result.____Kathleen__R&R Support

[timjacob2001]

Strange. It has "Entire Result Set" selected. If I change it to "Maximum Row" and enter 999999999 as the number, it displays a WHOLE LOT more, but still not everything.____It does have a sort and filter, but only shows records processed when I have it set to "Maximum Row".____The entire table has only 85644 records, and it appears to only display 21832.

[timjacob2001]

Here^s another wrinkle: It does appear to read and select all 85000+ records, but all but the last 21832 show as blanks for character & date fields, zeros for numeric fields. So I^m getting some 63000+ blank lines.

[timjacob2001]

I remade the report and that took care of it.