Search results for query: *

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

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

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

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

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

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

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

I have a report that lists each one of our sales from the prior day (5,000 to 20,000 order line items). I want a report that only shows the 50 records having the largest sales dollar amounts. How do I do that?

I keep getting the following error when I try to add a condition to my count function The summary/Running Total field could not be created A Group Condition is not allowed here current count works fine count ({LOCATION.DESCRIPTION},{@within window new}) example of new count that won't work...

I want to create a report in Crystal, and give it to my Inventory Control Manager. His computer skills are relatively limited, so I don't want him to use full crystal to run it - mostly I don't him to have the power to change it, or otherwise mess it up, but I DO want him to be able to get fresh...

I want the users of my report to be able to assess the results of an individual driver, or a short list of drivers (such as those on their three month trial probation period) but I don’t want them to have to type it in. I’d like to use a drop down menu. When I work in CREATE PARAMETER FIELD...

I have two questions I have a date time field set to Prime Meridian time, that I have adjusted to New England’s time zone via the following formula; {START_DATE/TIME} – 300 When I looked up old archive threads to get the answer to (what is now) my second question, I found a reference to...

[morning] The following error occurs when I try to add a paramenter to the date field of my report. ODBC error:[Oracle][ODBC][Ora]ORA-00936:missing expression Thing is, when I refresh my report I see all the data going back months. I close my report and open it again, I can still refresh, but...

Good morning all from cold and windy Massachusetts! :o) I’m using Crystal to design reports that will get used by a Crystal reports “viewer” in a specialty software suite called UPS Logistics. This is a fleet management and tracking tool distributed by UPS, the same company that brought us...

Golly! Thanks for the answer to my last question! I thought I’d push my luck a bit, and ask about a weird sort of running total problem. Our database shows the arrive and depart times for each of the stops on each of our routes. We want to figure out the stop times for each customers, and the...

I’m new to the Group, and somewhat new to Crystal. I hope the question isn’t too stupid, but for the life of me I can’t figure out how to do it. I’m tracking on-time dispatch. I look up dispatch time, and compare it to another field showing actual depart time. By comparing the two, and...