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

    ZT411 Zebra - Fails to Print Specified Number of Labels

    Greetings, I am implementing a new WMS software platform. We identify printers within the WMS using the print path to a network shared Zebra printer. The driver resides on the application server where the WMS is installed. The Zebra ZT411 printer is connected via WiFi. When printing from...
  2. jpstrzoch

    Variable Length String - Extract Middle Portion Multiple Delimeters

    Greetings, I gave a formula that returns a string value. Typical results are shown below. The variable length nature of the formula is that it has a sales representative's first and last name following the warehouse identifier. Example: {@Burst Conditional Formula} WHSE 101 - James Pstrzoch...
  3. jpstrzoch

    Formula to Determine if a String Value is Even or Odd

    Greetings, I have a warehouse storage location code. Example, "BUGG11F". This field is a string. I've used the following formula to return a portion of the location code. MID({Sheet1_.bin_num},5,2). This returns an "11" result, itself a string value. How do I write a formula to consider...
  4. jpstrzoch

    Crystal Formula Clean-up

    Thank you very much!
  5. jpstrzoch

    Crystal Formula Clean-up

    Greetings lbass, I was hoping to return to this topic for just a moment. When I thanked you for your time, I knew that I had an additional question and yet didn't know how to propose it to you. My follow-up question is this. Directly below are two portions of the above formula. This formula...
  6. jpstrzoch

    Crystal Formula Clean-up

    Greetings lbass, Thank you for your response. I appreciate your time. jpstrzoch
  7. jpstrzoch

    Crystal Formula Clean-up

    Greetings, Long time Crystal Reports formula novice. I wrote the below formula, it works, but wondered if there was a better way to represent the variation that are shown below? Your assistance would be greatly appreciated! Thank you! if {Sheet1_.wh_num} = "703" and {@Zone} = "RK"...
  8. jpstrzoch

    Greetings, I have a Roles and Re

    Greetings, I have a Roles and Responsibilities manual that is in PDF format. I want to add a button on each page to assist the reader in navigating throughout the document. Often times I provide a link to navigate to a specific page but when the reader lands on that destination, I want them to...
  9. jpstrzoch

    Export to PDF with Embedded Hyperlinks from Crystal Reports 2016

    Greetings, I have a .RPT that I've created in Crystal Reports 2016. Presently connecting to an XLSX file using OLE DB. My report has four subreports. I export to PDF using VisualCut. I would like the PDF to include hyperlinks to network stored PDF files. Is this possible? If so how...
  10. jpstrzoch

    Formula to Return Future Date

    Greetings, I am an amateur Crystal Reports user. I manage a box printing operation in Chicago, IL. The Chicago, IL location is known systemically as WHSE-101. Box orders are placed that are relational to geographical locations where we have additional warehouse locations. Example, Iowa...
  11. jpstrzoch

    Dynamic Global String Array Used in Formula

    Greetings, I am a long time amateur user of Crystal XI. I have a report that I believe I need to create an Global StringVar Array but I need your assistance. Below is the structure of my report. GH1 {ORDRHDR.SOLDTOCUSTID} GH2 @WaveBatchIfThen // When we schedule orders in our WMS...
  12. jpstrzoch

    Manual Running Total Formula Does Not Appear in Alerts!

    Good morning Charliy, Thank you for all your efforts! I greatly appreciate your time! I was unable to make the Alert work but no need for concern I solved it another way. Thanks again!
  13. jpstrzoch

    Manual Running Total Formula Does Not Appear in Alerts!

    Good evening Charliy! Thank you for the post! Very much appreciated. I added Group Footer 3B and moved the reset formula to that section. My formula was correct in the RPT.....I just did a typo when posting within the original thread. Unfortunately I still cannot see the formulas as an...
  14. jpstrzoch

    Manual Running Total Formula Does Not Appear in Alerts!

    Greetings, I created four formulas in hopes of being able to use them in an Alert!. I placed the formulas in the sections of the report as shown below. Why am I not able to see the formulas when attempting to construct an Alert? GROUP HEADER 3 @Formula Reset WhilePrintingRecords; Global...
  15. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Will do! Thanks again! It is working properly! James J. Pstrzoch
  16. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Good afternoon Mr. Hamady! That did the trick! I was able to add a new Alert!, but you're correct in stating that I had to create the brand new Alert! to avoid the error message! I was able to add two and three detail rules alerts along with a single subtotal without the error but again, it...
  17. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Sir, Can you clarify when you say 2 detail rules and one subtotal rule.....restated, are you saying that the below would work: {ORDRHDR.SOLDTOCUSTID} = "VRTX" and {ORDRHDR.CLIENTDIVISION} = "GPS" and Sum({@EnvCounter},{ORDRHDR.ORDERNUMBER}) = 0 But not the following: {ORDRHDR.SOLDTOCUSTID} =...
  18. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Good morning Mr. Hamady, I just now had the chance to exercise your recommendation above and I'm having a little difficulty. Let me provide additional clarification regarding the report structure in hopes that it may help to decipher what the cause of my difficulty may be. The report has...
  19. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Good morning Mr. Hamady! Thank you for your time and your reply post! I appreciate it very much especially during the holiday weekend! Continued success and I wish you and your family a Happy New Year's! Warm regards! James J. Pstrzoch
  20. jpstrzoch

    Alert! Condition - How to exclude a result when a Detail record is true.

    Greetings, I am trying to construct an Alert for one of my reports. I am using Crystal XI connecting to an SQL DB. The report is constructed such that Item ID's, Detail Records, are returned in the detail section of the report grouped by their respective Order Number, Order Header records...

Part and Inventory Search

Back
Top