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...
Hi Paula,
That looks like it should work and I don't think you need to specify the access path to the Physical File (PF) but, I am not familiar with "Rally Attachmate" so I cannot say for sure. You did correct by adding the 2 tables and creating the join between them on MMBR# to ID...
Thanks for the clarification lameid, I saw your post as I was composing my reply below.
Hi Paula,
You can use the "Design View", I just posted the SQL since I cannot "upload" the picture in the "Design View" to this forum. If you create the 2 tables, then get...
Hi PaulaJ,
Sorry for the late post - haven't been to this site in a while. I work with MS Access and an AS/400 daily. Below is an SQL statement that should help you to solve your problem with just one "update" query.
Info:
AS400Table = name of AS/400 table
AccessTable_After = name...
Still no luck, I can't see any of the AS/400 tables. I can link to another SQL Server with no problem but not to the AS/400. When I try to browse the tables, I cannot even see a job on the AS/400 that is the SQL server trying to access the tables.
What AS/400 server jobs need to be running to...
Has anyone had any luck with this? I cannot even see the tables in the Enterprise manager, could someone possible give an example of how they set up their linked server.
Thanks in advance!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.