Recent content by kieso

Thank you both for your comments! Having been on the other side of an SAP implementation (as an Audit Director who would have had to explain it to the audit committee if the implementation corrupted some SOX key control), I'm certainly very conscious of the need to make sure implementations get...

Hello gang I'd really like to transition out of Internal Audit and into SAP or Oracle ERP installations, but I'm not quite sure how an audit guy like me (Director of Internal Audit, CIA, CPA, CISA (though very little IT audit experience)) gets into that. Here's my questions 1. When I...

An associate at work got back to me with another solution, and it looks like it works perfect. A utility that seems to fit the bill http://www.asap-utilities.com/ Thanks for your help folks

Each of the 440 excel files is named after the division to which it refers. there is very little similarity between one file's name and anothers

Over the past year we've created 440 reviews - each review is documented in a seperate excel file. Each review covers 20 to 25 different tests, Column A is in all cases the test name (sorted test#1, test#2, test#3, etc). Ultimately I want to get all the rows together (about 11,000 rows) so I can...

Hmmm.... Maybe I'm crocked in the head too, but I think your program is doing what you want it too max(moveout_date)>max(apply_date) MD 3/02/2003 > AD 01/09/2003 TRUE MD 12/02/2002 > AD 01/09/2003 FALSE Seems okay to me, unless it's in DDMMYY format in which case the first one...

More thoughts What if I go into the mainframe, and create another file in which each item number is represented by a record instead of each customer. If I put that figure in a group heading, can I total it in broader group headings?? Rodger

I'm sure I'm missing something obvious, by I'm a little tired this morning, so help me out ok? I have a database of order items we didn't ship. Each one has number of items ordered, not shipped, and the remaining inventory at the end of the night. From these figures I've created a running total...

You know what, C.G., I was actually going to e-mail you directly and admit to not having a stinking clue about Sub-reports. Truth is I've never tried one before. I like the idea, though. If I understand them, I can take one report and stick it right onto another. I've read some posts about how...

CR 7.0 Alright, now I know I'm not the brightest porch on the block when it comes to ODBC and SQL stuff, but gosh-darn-it, I spent the whole weekend going through online SQL tutorials, and the &*^%$#% repot still doesn't work. I think I get to ask my pain in the butt Crystal/SQL question now...

Credit where it's due, right... I knocked around the Tek-Tips sight and found a really awesome FAQ FAQ220-822 It points to a couple of SQL tutorials. I've been playing with the first turorial for 20 minutes, and I think I already have the answer to my question. Kudo's to Simanek's really...

Credit where it's due, right... I knocked around the Tek-Tips sight and found a forum on ANSI SQL where I found a really awesome Fax faq220-822 It points to a couple of SQL tutorials. I've been playing with the first turorial for 20 minutes, and I think I already have the answer to my very...

Sorry. Neglected to add that I'm using Crystal 7.0 since the reports are being used by a rather antiquated Crystal viewer called UPS logistics. That viewer isn't the problem though, since these issues occur before it's ever uploaded there Thanks again Rodger

Well, I must concede to being rather dim when it comes to SQL, but I can't figure this stuff out at all. I went into Crystal and added RSSTOPBUN1 and linked RSSTOPBUN1.LOCATIONID to STOP.LOCATIONID, and brought RSSTOPBUN1.P5TCON01 into my report. For some reason, none of that stuff appears in...

<<<<< VERY NEW TO SQL >>>> There you go. Fair warning of my utter ignorance here. I'm working in Crystal reports and I can't get it to join two fields. The one in the AS400 and the one in Oracle are both 15 character strings with the first six characters being numbers, and the rest being...