Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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