Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RedHeadedStepITChild

    Iteration formula help

    I apologize if the subject was not concise enough, but was unsure how to word it. I also apologize if this question has been answered before, but after searching this forum quite extensively, I didn't find any posts that quite helped me out. Background of the issue: We have recently...
  2. RedHeadedStepITChild

    Not all details/sections printing on report

    This is probably an easy fix that I am just not seeing. I am working on an inventory tag report that is built into my ERP system (Epicor 9). I'm making changes to the report, but not everything on the report is showing up. I can see a gray box in the design view, and when print previewing the...
  3. RedHeadedStepITChild

    Actions menu from Tool Bar - Epicor 9

    Just noticed that the ACTION menu in the tool bar is grayed out in the capabilities module. Is this normal? I don't remember this happening on Vantage 8. The action menu is available almost everywhere else.
  4. RedHeadedStepITChild

    AD reporting

    I've searched the net and this site hi and low, but have been unable to piece an answer together that gets me what I need. I am trying to create a report, that shows me the user's name, telphone number, and department in a particular group in Active Directory. I have no problem getting the user...
  5. RedHeadedStepITChild

    Need help with group selection

    I need help with a group selection. I cannot seem to get this to work, and at this point I think I've been working the issue too long. Background info on the report. Using Crystal XI and a DB2 database on AS400 v5r3. The report shows Shop order information. It is grouped in the following...
  6. RedHeadedStepITChild

    AS400 security nightmare

    Somewhat long post, but want to give as much info as I can... I've recently inherited an iSeries to admin (V5R2). As any decent admin. would do, I've gone through the system and ERP security and have updated to what it needs to be. As you can imagine, this has upset some end-users as they no...
  7. RedHeadedStepITChild

    Formula to add zeros to a string

    Hello all, I hope this post finds you all well. I am using Crystal v.11. Connected via ODBC to a DB2 database on an AS400 v.5 r.3. In the past we have used a report that I created to print out for inventory tags, which were manually filled out by the counters. This year we are attempting to...
  8. RedHeadedStepITChild

    Report Schedule on Database Change

    I am using Crystal Reports and Crystal Reports Server XI connecting to DB2 (AS400) database via ODBC (IBM Client Access driver). I have a report showing open PO's for items sent out to be chromed. This report is scheduled to run once a day (in the morning) and is exported to .PDF and emailed to...
  9. RedHeadedStepITChild

    Help with user list

    I hope this message finds everyone well. I think the answer to my question will be pretty simple, however I cannot seem to find the answer anywhere. Is there a command I can execute to dump a list of enabeled users to a printer? I've tried coming up with a CL program, alas, I'm a nOOb and...
  10. RedHeadedStepITChild

    Math Formula - Creating Record

    I've run into a bit of a problem with a report. I am using CRXIr2 connecting to DB2 (AS400) via OBDC Two tables: IIM(item master) :: FSO(shop order) Link: FSO.SPROD == IIM.IPROD (item number = item number) Formula to find LabelQty: RoundUp(TotalQty/QtyPerLabl) TotalQty comes as an entry in the...
  11. RedHeadedStepITChild

    steps to connect to a openedge 10 (progress) database

    Hello, I am a bit of a loss how to connect to an OpenEdge 10 (Progress) database with Crystal XI. The database resides on a server. Does anybody know the steps that are needed to be able to write reports from this database. I did a search here on this site, but didn't really see anything that...
  12. RedHeadedStepITChild

    Loop Syntax

    Having trouble with a loop in CRXI My report lists all the employees in the company. It is sorted by division and then by hire date. Currently, the Employee ID numbers are all over the map. I need to create a new employee ID number based on division and hire date to sequentially list the new...
  13. RedHeadedStepITChild

    Easy formula - I just don't know syntax

    I am using Crystal XI - DB2 database. I am doing a database conversion project, and using Crystal report to export as a CSV for the new database. The new database has two separate fields for the employee name, where our current database just has one field. The data in our current database is...
  14. RedHeadedStepITChild

    Using an unlinked table in report

    I have a report showing all the scrap and reject transactions in my company's ERP. This report links "Item Master" (IIM) table to the Item Transaction History" (ITH) by Item Number (IIM.ITEM#)--->(ITH.ITEM#) This report shows various things like what was scrapped (item number), when, actual...
  15. RedHeadedStepITChild

    Help with Twin-Ax printer issue

    I have two 4234 IBM printers (one is a model 12 and the other is a model 2) that have sat idle (turned off, and disconnected from the system) for quite some time while an office was being renovated. Upon hooking the twin-ax back to the printers and turning them on, I am not able to succesfully...
  16. RedHeadedStepITChild

    Formula for Tag Number

    I am using CR to create tags for inventory of our finished goods. I need to be able to put a tag number on each tag. The tag consists of information (item number, location, ect) listed in the detail section. I added a Detail B section, and copy/pasted the same information into that section. The...
  17. RedHeadedStepITChild

    One field, multiple records, displayed horizontally. How???

    I have searched this site, and have found a couple of threads of the same issue, however, I was not able to get the answers posted there to work. I am intermediate user of Crystal, and a beginner programmer (VB). I do understand logic pretty well, so I hope I'm not 100% worthless ;) So...Here...

Part and Inventory Search

Back
Top