Recent content by wiegelman

Great idea regarding stripping the report down and I agree it will be very time consuming. Thanks, Tom

Thanks rosemaryl & SmithyJD, Report works just fine in CR V8 but bombs in CR V10 on the same PC rosemaryl - totally different report for a different department. SmithyJD - using iSeries Access ODBC driver that came with OS/400 V5R2. Not sure if the c/a was an upgrade or an uninstall then...

Hi rosematyl, I also found that KB article but it does not solve the issue - it relates to another error message "Details: S1C00:[IBM}{iSeries Access ODBC Driver}Driver not capable. (Version 5 Release 2)", not the one I am getting "Invalid Argument provided." BO support replied a minute ago...

Sounds like a plan. I will send the report to you via email after removing anything that I feel may contain confidential and/or otherwise privacy related information. I agree that it is best to share this in Tek-Tips, I am just very security conscious and do not want to run into any privacy...

Hi again rosemaryl :-) I am getting the same error message "Failed to open rowset." as well as a second message box with another error "Invalid Argument provided.". What is your version of CR? Converting V8 to V10 What is the database? OS/400 V5R2 (DB/2) What ODBC driver? iSeries Access ODBC...

Dear rosemaryl, :-) Thanks for your reply - I do understand your point completely. Since I see your email address is included in your post, I could forward the report for you to check out - that is, if you want to check it out. You will not be able to refresh the data but should be able to...

Hi rosemaryl, Thanks for your reply, although, I do not agree with you 100% regarding it is a DB design issue. Granted, if I were the designer of the DB, I probably would have done it differently. We are able to "pull up" a customer record to "view" on the screen and are able to see those who...

Hi, We had the same error when we did two things: 1. renamed our database and 2. upgraded from Crystal 8.5 to Crystal 10 Tom solve the problem, I created a new ODBC connection and re-pointed the tables. This worked for us. Good luck. Tom

Thanks for your input mpdinosaur - that may work but I do agree it will be slow, especially since the report already has 3 other embedded sub-reports. A work-around, which really does not solve the problem, is to create another table on our database that contains a field to hold the Total...

In reply to my "Aug 26, 2004" post above... Have I stumped the Crystal Reports experts out there? :-) Maybe there is no way to calcualte the balance due and display only those where it is greater than zero... If anyone has any ideas on this, please let me know. The vendor who supplied the...

Hi synapsevampire, Thanks for your reply. I changed the running total to a summary, summing the data instead of using the running total. Unfortunately, I am getting the same message "This formula cannot be used because it must be evaluated later". Below is the scenario: The report...

Hi Ido, That was a good suggestion but will not work because the balance is calculated later in the report. The error message I get when I use a summary formula (@AmountDue)>0 in the Group selection area is: "This formula cannot be used because it must be evaluated later." I have a feeling that...

Hi, First, the givens: Crystal version = various (8.0, 8.5, 9.0) Database/connectivity used = ODBC to AS/400 Example data: Total Amount Due is created from a running total field so its value will either be zero (0) or some number > 0 Expected output: Reports where Amount Due is greater than...

PaulaJ, Glad to be of assistance. :-) BTW, thanks for the info. on the ISO Date Default for the AS/400. I use and administer it but I do not program in RPG at all! Have a great day.

Cool! So, I took down the link to the Access file since you will not need it. Did you try Is Not Null as the criteria? I cannot re-create what you have on your system and I have not worked with dates in that format, we use YYYYMMDD without the dash seperators which allows the field on the...