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 Chriss Miller 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: *

  • Users: jpstrzoch
  • Content: Threads
  • Order by date
  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

    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"...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. jpstrzoch

    PS File - NonPPDFeature Color vs Black & White

    I presently create PS files individually for use in my automated print on demand fulfillment process. When creating an Adobe Postscript Driver I simply select the PPD for the intended output device. The PS file is generated in ASCI and is then hyperlinked at an Item ID level within our WMS...
  12. jpstrzoch

    Batch PS File Generation Using Custom PPD

    I am generating PS files individually using an Adobe Postscript Driver which itself was created with a custom PPD. The PPD is specific to the targeted device the PS file will be spooled to. This approach allows me to identify finishing characteristics driving POD via my WMS application. Is...
  13. jpstrzoch

    Error when loading Condition for a Report Alert

    Using Crystal XI and while constructing a Report Alert, I pulled into the Condition a report field that is itself a formula. The formula, "AdjustedDate" considers a createdate field and compares that date to an array of holidays, if it finds a match it adds a day to the date. It then considers...
  14. jpstrzoch

    Crystal Pie Chart Data Label Overlap

    I have a simple question. I have a Crystal XI report that uses Proportional Multi Pie Charting as an election while under Chart Expert. The report is automated and returns varying amounts of data. Restated, when pulled in the AM it shows 6 pie charts. Mid-day, 9. PM, 2. Etc.... The...
  15. jpstrzoch

    Stacked Barchart - Order of Data

    I am using Crystal XI. I have created a Stacked Barchart. Within the Data tab of the Chart Expert I have entered two formulas under the "on change of" election. One will return the number of orders per hour to be depicted in the bar chart. The second formula identifies the orders recieved...
  16. jpstrzoch

    Null Field Excluded

    I am using Crystal XI with an SQL 2005 DB. I need to exclude within my selection criteria a string field called CUSTOM_DATA7 when it contains a "K". Simple enough......{CUSTOM_DATA7} <> "K". But I notice that when records have a "null" value, they do not appear on the report. I need to...
  17. jpstrzoch

    Date Range Formula to Include Specific Cut Off Time

    Using Visual Cut I am executing a Crystal XI report extracting from an SQL 2000 DB. Today I am using the following formula to capture specific date ranges of activity. Please note that the report is executed programmatically via Visual Cut on Monday through Friday. if {@Day of the Week} = 2...
  18. jpstrzoch

    Crystal XI SQL RPT - Need to Fetch XLS Data

    Hello, I am using Crystal XI to run a report linked to an SQL DB. I have created the report to show specific item IDs that meet the Selection Expert criteria. GH1 is grouped on the Item ID field. I have an administrator that would like to maintain an XLS file with "status" codes for...
  19. jpstrzoch

    Access/Excel - String Limited to 255 Characters

    Using Crystal XI I am tapping into and XLS file. Most of the fields within the file are being considered by Crystal as Strings and when viewed in Crystal's Field Explorer all of the Database String fields have a [255] following the field.... example: Form_Submitted_By: String [255] I have...
  20. jpstrzoch

    Access/Excel (DOE) - String Cutoff

    Hello, I am using an Excel file as a DB and connecting to that file using Crystal XI via an Access/Excel (DOE) connection. I am selecting Excel 5.0 when establishing that connection. When I review the available database fields within Field Explorer I see that one particular field is listed as...

Part and Inventory Search

Back
Top