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

    Value at Max Date for each month of the year

    I'm using Crystal XI I am wanting to create a report which shows the inventory value of a product for each month of a given year. The value of the product will change randomly depending on when goods were sold. For example, a product valuation for January 2018 could return the valuation from...
  2. JasonKaufman

    Pulling data out of a string

    I have a field, {tblProduct.Description_1} where "Pk" or "pk" or "PK" may or may not exist somewhere withing the string. If it does exist, I want to pull out that 2 character string along with the the 2 characters to the left of the 'pk' string as this data would be a number (such as 1,2,10, 11...
  3. JasonKaufman

    CSV export of field problem

    I am needing to create a CSV file using a long description field that can be of various lengths and could look something like the following bold type: bt boys basics gry 0-6 months Product Testing Required-CPSIA Protocols-Lead in Substrates Section 101 CPSIA, Phthalates Section 108 CPSIA...
  4. JasonKaufman

    Splitting Name field with non-standard data

    I have name data that needs to be split into first and last name. However, the data in this field is not standard. Some data just has the first name, some is standard with first name, space, last name. Others have standard with first name, space, last name with either a "/" with no space after...
  5. JasonKaufman

    Pulling previous data - 2nd stab

    I am using CR XI My data is a csv file looks like the following with "<07>" as the delimiter: B.HL.HL: HL<07>3<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00806 B.HL.HL: HL<07>4<07>3<07>26 B.HL.N1.N1: N1<07>SN<07><07>93<07>00809 B.HL.HL: HL<07>5<07>1<07>25 B.HL.N1.N1...
  6. JasonKaufman

    Pulling Previous Data

    I am using CR XI working with 816 EDI data My data looks like: B.HL.HL: HL<07>3<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00806 B.HL.HL: HL<07>4<07>3<07>26 B.HL.N1.N1: N1<07>SN<07><07>93<07>00809 B.HL.HL: HL<07>5<07>1<07>25 B.HL.N1.N1: N1<07>WH<07><07>93<07>00810 B.HL.HL: HL<07>6<07>5<07>26...
  7. JasonKaufman

    CSV export with header row problem

    I have CR XI, CR developer, product type: full I have a report that must be exported to CSV for upload of records to a website. The main data is in a group header with the headers on the Page Header section. I want the export to look like the below two rows...
  8. JasonKaufman

    Text box across Header/Detail sections

    We have a customer who wants a pack list with database items on the left side of the page and Return information on the right, as part of a text box. Based on the picture they provided this would cross the Group Header, through the Detail section and into the Group Footer. The Header is...
  9. JasonKaufman

    Carriage return generating formula

    I am using Crystal XI and I have the following quandary. I have a field called 'Remark' which for a particular customer will have a maximum of 5 subsections where the separator is '[.]' For Example: You can check the status of your entire order in the My Account section of our Website.[.]This...
  10. JasonKaufman

    formula for selection of months/year where it rolls from one year to next

    I am using CR Developer, version 11 Sales info is in monthly buckets of an array: 0;0;0;0;0;0;1203;72;99;96;75;111;0 The Year is a selectable field by itself The idea is to have a report where the end user can choose a month number. This selection would then pull the sales data for that month...
  11. JasonKaufman

    How to obtain previous year data in an array

    I am wanting to create a report that will look at the last 3 months of sales. The data is held in an array. I want the end user to be able to select the 1st month and the year for that starting month. My problem is how do I deal with a month selection of either January or February as the...
  12. JasonKaufman

    Crystal drilldown length

    I am trying to link to pics that are buried within multiple folders. I know that I get an error because it is too long a string. So I am needing to find out the max length of the searched string For example it could be Q:/CustomerA/Spring 2011/Product xyz/front pics/pic.jpg The error message...
  13. JasonKaufman

    Dynamic Graphic Location

    I am using Crystal XI I want to be able to create a report that will take the location of a product's jpg file from our system The application software stores the location such as "Q:\Product Master\Cads\0232_15_6_72_Houndstooth_Pink\0232_15_6_72_Houndstooth-Pink.jpg" and then would have...
  14. JasonKaufman

    Position of data within a string

    I am using Crystal XI I am wanting to create a report that takes the db string of data and looks at each section of the string and determines the position within the string (for eventual numerical month value) of the section. So when it looks at the data below, it would see the first section...
  15. JasonKaufman

    Month indicator from Year of data string

    I am using Crystal XI I am wanting to create a report that takes the db string of data and looks at each section of the string and determines the numerical month value of the section. So when it looks at the data below, it would see the first section (789.6) and indicate that this is month 01...
  16. JasonKaufman

    Reading an Array question

    Hi, I am drilling into a table in our software and the field is an array. I am using Crystal XI. The data held there is sales numbers for each month. I want to be able to for any month of my choosing be able to pull the data that relates to that particular month. So in the data below, if I...
  17. JasonKaufman

    using Previous in formula

    I am using the following formula for all sales orders within a group of the same item number (for all item numbers) and am wanting to take the OnHand qty minus each individual Sales Order Qty and then take that total and use it for the next sales order # qty. This formula seems to work for the...
  18. JasonKaufman

    making date from a field of text

    I am removing date from a string by using the following formula: (Left({PO1_PurchaseOrderEntryHeader.ShipToAddress1},8)) information in the field could be as 04/14/06 or as 04/14/06C and so i use the formula to leave it as 04/14/06 either way. However, when i use this new formula (as its...

Part and Inventory Search

Back
Top