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

    How to split 2nd delimiter in string? CR 9.0

    Ha! I found a simple solution. IF {MaterialCode.Width} < 10 THEN (stringvar matcodereversed := Mid(strReverse({MaterialCode.MatCode}),6); strReverse(matcodereversed)) ELSE (stringvar matcodereversed := Mid(strReverse({MaterialCode.MatCode}),7); strReverse(matcodereversed))
  2. Digitalcandy

    How to split 2nd delimiter in string? CR 9.0

    Thanks Ibass, but it only works for some of my data. On others I get a substring error. On 98% of my data, it ends with a size. The trailing 18X24 in the data L41-0080H1/H1-18X24 is a size, so if I could somehow delete the last 5 or 6 characters of every field, that should give me what i...
  3. Digitalcandy

    How to split 2nd delimiter in string? CR 9.0

    I have some data such as the following: L41-0080H1/H1-18X24 L43-0050H1/H0-9X12 I'd like to be able to split it at the second hyphen so that it reads... L41-0080H1/H1 L43-0050H1/H0 I have the following formula, but it splits at the first hyphen, not the second. Stringvar array MatCode :=...
  4. Digitalcandy

    Defaulting Today's Date at a Prompt

    uh...the default is the current date.
  5. Digitalcandy

    Text fields in CR XI are being compressed

    Not for all fonts. I know it does it for arial too, but I tried some others, and it shows up fine.
  6. Digitalcandy

    Text fields in CR XI are being compressed

    I just installed XI and then put SP4 on. I immediately notice all of my text fields are compressed. Anyone see this happen? Even creating a new report, text fields come out looking compressed. In the image below, the text box contains "Hello World," but as you can see, it is unreadable due...
  7. Digitalcandy

    Where to get updates for CR XI?

    I found a link that has many updates and patches for several versions of CR; however, my next question.... Can I install SP4 without installing previous service packs?
  8. Digitalcandy

    Where to get updates for CR XI?

    I have a copy of version XI, but I don't know where to get the updates for it. SAP only has updates for XI R2. Does anyone know where to get updates for XI? Does XI become R2 from an R2 patch, or is XI R2 a version of it's own?
  9. Digitalcandy

    MAS90 vs MAS200....what is the major difference?

    I may be taking a job where I'd have to administer and draw reports from MAS200. I'm familiar with MAS90, but I can't find a whole lot of difference on the internet between the two. At my current employer, we use MAS90 among 10 networked users, but it seems MAS200 tries to sell itself on being...
  10. Digitalcandy

    2008 Install - no DVD drive!

    Uh... Insert the Windows 2008 DVD while you are in your current Windows OS environment. You can do the install from there. No need to boot to the disk. This type of install will render your current OS inoperable, but it will preserve the file/folder structure of your current OS drive letter...
  11. Digitalcandy

    How to convert mail.yahoo.com into yahoo.com?

    On MS SQL 2000, I have a field that stores host names from Microsoft ISA logging. I want to pull out the domain name portion of the host for .com and .net domains only. Sample data would end up looking like so... US.f840.mail.yahoo.com --> yahoo.com www.yahoo.com --> yahoo.com...
  12. Digitalcandy

    Reinstall NAV 8.1 on reimaged server...what to do?

    I'm only concered about the affects of NAV server software not anything else. I understand the implicatiosn of reimaging a server as it pertains to drivers, Windows SID, and other such things.
  13. Digitalcandy

    Reinstall NAV 8.1 on reimaged server...what to do?

    I have ~80 clients on version 8.1 connecting to one physical server. I need to reimage the server for various reasons, and I'd like to know if I need to back any of the NAV data up on the server. Do I need to do anything in regards to the NAV server software such as backup and restore any type...
  14. Digitalcandy

    MAS90 integration with our SQL MRP package

    So is MAS500 the way to go instead of MAS200 SQL?
  15. Digitalcandy

    MAS90 integration with our SQL MRP package

    Hopefully someone can give me some insight. We have an MRP system that runs on MS SQL 2000, and we are running MAS90 for accounting, purchasing, sales orders...etc.. We'd like to synchronize applicable data between the two systems, but the software vendor for our MRP says he can't do it...
  16. Digitalcandy

    Visual Basic noobie...calculator question VB2003

    ...As Integer OP = CDbl(txtOP.Text) PD = CDbl(txtPD.Text) NoIP = CInt(txtNoIP.Text) DPPI = DiscountPrice(OP, PD) OC = OriginalCost(OP, NoIP) DC = DPPI * NoIP If PD >= 1 Then PD = PD / 100 End If txtDPPI.Text = FormatCurrency(DPPI) txtOC.Text = FormatCurrency(OC) txtDC.Text =...
  17. Digitalcandy

    General Crystal XI questions

    You can no longer have blank values for your parameters. Another stupid design change by Business Objects. Again...way to go guys.
  18. Digitalcandy

    display current date in parameter date field Crystal X1

    This was such a stupid change in CR. Way to go Business Objects.

Part and Inventory Search

Back
Top