Search results for query: *

Yes, I knew there would be a lot of work in creating look-up tables for translation. I'm half way considering doing this using SSIS and a ODS. However, the same principle for translation of the old system to the new applies using those tools as well. However, I can't, for some reason, get any...

Unfortunately there is not any rhyme or reason to the parent (sales kit) SKUs in regards to the components that make them up. For instance the component part numbers of: 73868 (top) 67152 (legs) create the sales kit 220015-BBLURE3072-TBLKBLK don't beat me up over part numbers :) the powers...

oops...I left out in the do while portion firstPart = next({partMaster.IPROD}); secondPart = next({partMaster.IPROD});

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

Fixed

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

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.

Nevermind - this is not possible. The member and memberOf fields in AD are arrays.

Write a function that replaces all spaces with the equal sign (=) to represent a space.

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

lbass, Thanks for the help. I created the SQL expression and formula as suggested. For whatever reason the results of the summation of the @qtytest where not what was to be expected. I cannot figure out why it is off. I inserted a distinct cout of @qtytest and did a group selection to show...

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

flapeyre... I appreciate your suggestions. While I'm new to sys. admin world (and even newer to AS400/iSeries) I've made my almost all the suggestions you listed to my "higher-ups." Perhaps its my negotiation skills that need upgrading ;) Once again, thanks all to all of you have helped.

No...unfortunatly BPCS doesn't. Basically the iSeries username is passed to BPCS, and access to the BPCS modules and/or CL programs is set within BPCS. To this point I don't think its even possible to pass a group profile (which would make my job tons easier). I have come across a few articles...

We are using BPCS, and yes it has it's own security. I did CHGMSQ MSGQ(QSYSOPR) DLVRY(*BREAK)in hopes of my terminal showing me when users log on and off. That doesn't seem to be working, or not working in the way I was hoping. I am learning very fast and, yes, I do know about WRKUSRPRF *ALL...

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

Thanks LB! I have not tried it out, but I will. I just got the notification around the same time that I took a different route successfully. I ended up just using: numberVar zeroValue := 15 - length({ICTL02.CTPROD}); Select zeroValue Case 14: {ICTL02.CTPROD} & "=============="...

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

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

Great! I was trying to DSPUSRPRF USRPRF(*ALL) STATUS(*ENABLED) but the system was yelling that it didn't like that :) If you could help me take this one step further, it would be much appreciated. Is there a command that will tell me when the last time an account was logged into? That way, all...