Search results for query: *

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...

Hey, synapsevampire Thanks for the suggestion, but how do I do that? Do you mean to say that I should build this SQL trim expression right into the SQL code of my crystal report?

Okay! I'm getting closer, I'm sure of it! I've skimmed the AS400 of just the prior days orders, and I'm going to have our dispatcher only run this report for the current day. It's a bit of cheating, I know, but at least it gets some results. Now I have a new problem - Crystal won't link the...

I have an HS400 table and a Oracle table Crystal can see them both, but the dates are quite different The Oracle database shows the date that the product was delivered, and always assumes midnight in it's date/time field 9/24/2002 12:00:00AM The same delivery on the HS400 shows the date that...

These records are all lost sales (ordered, but not shipped). We want a reason code for each one. (out of stock, loaded on the wrong truck, avoided returns, on truck but not delivered, etc.) This handwritten list is the sales manager’s assessment of all those that were incorrectly ordered. (ex...

I have a Crystal report that lists several thousand records, and HAND WRITTEN list that provides required details on about a dozen of these records. I need to get this hand written information onto a table, into crystal, and linked to the appropriate records. All I have now is the guy I’ve...