Recent content by NoseDive

It's OK, I have passed this onto our software supplier, who will do it for us. But thanks anyway.

Thanks - I forgot to mention that we are at security level 40. It would appear that this version has now been restricted to iseries News Pro VIP members only. I don't suppose anybody has downloaded this and would be kind enough to share it with me? Thanks.

Does anybody know how I can retrieve a list of files used in a query definition (other than by printing the query definition). I need to find out which queries run over a certain library/file. As we have a lot of queries in a lot of libraries I cannot go through each one individually. I have...

If you're talking iseries RPG program testing (which I assume you are) you should learn to use the interactive debugger. For RPGLE programs use the command STRDBG, for RPG & CL use STRISDB. The programs are very similar (Except that one is in glorious technicolour and, frustratingly, the...

Thanks for the reply. We are using CR version 10 - that's probably why none of my reports work. I'll have to get onto our Kronos guy and see if there's anything we can do about it (other than buying CR version 9!) Cheers, ND

Has anybody tried to run user-defined Crystal Reports from within Kronos Workforce T&A system? I have created a few reports, some with parameters/groups/totals/selections and some without. Every report I try to run comes up with the following message in the resulting PDF: Error while...

Thanks for the advice Fred. If I set up the ODBC as you suggest it is fine. The problem is that we are trying to set up a data source to use as a general reporting data source over our live AS/400 libraries (about 10 of them)so we have set up a default library list on a Client Access Express...

Hmmm... interesting. I found out why no data is appearing in the report. My ODBC data source is pointing at AS/400 data and the filename exists in several libraries. Despite the fact that I am pointing to a file in a specified library, via Crystal's database expert, the report is actually...

Hi, I'm running Crystal Reports 10 and AS/400 (OS400 v5r1) and am using Client Access ODBC to report on AS/400 DB2 files. I have no problems with most files but in some cases I can see and connect to a file in database manager, but not see any data when I insert the fields from that file into...