Search results for query: *

I use this function a lot but have always wondered if it's possible to import an excel file with 2 different tabs to make them into 1. I have some data (.xls) that has two tabs. It's continuous data so I would like to bring in the 2nd tab and merge it w/ the 1st tab (like you can do in sql) but...

Hi there! I have googled this and am trying to follow the instructions but I can't get it to work. My main report is a pricing file, my subreport is the cost file. I need to pull cost from the subreport into the main report so I can calculate the margin. Can this be done?

Hi there! I'm not sure if anyone else has come across this but it's driving me bonkers. I am constantly imported excel (.xls) files into Crystal so I can manipulate them, run formulas, etc. I did this on 10/30/17. When I went to do the same thing on 11/6, I got this error (and am still getting...

I have a report that is pulling on when an order was picked. It's running daily at 6am. I want it to pull anything picked today and yesterday. For some reason I cannot think of how to do this. I did a quick formula but it's taking the report a big longer to run which I think is because I don't...

I have a field where the spacing in the middle could change. Example 1: 332 31 Example 2: 332 9 Example 3: 041 12 I need to split this field into 2 parts. The space in the middle is what I was trying to split on but my example # 2 is returning a space then the 9. I need it to just return the...

I have a report that has a year field that I am pulling from our system. I want to pull the current year and one year ago (17 and 16). Every year I have to go in and add the current year and get rid of of date 2 years ago. For example, at the beginning of 2017, I had to go in and remove 15 (for...

I'm not sure if this can be done or if it would end up being a formula & a subreport but I thought I would ask before I start. I have two tables that have a few common fields to link on - Item # for one. However, one table has two different unit of measure fields. One is the stocking unit of...

Good morning! I have a string field where the data can vary in length & I need to remove the last character of the field. Example: table.field value is currently 12548798 I need to return in my formula: 1254879 Thank you in advance for any assistance!

I'm not sure if anyone has had this issue. I've searching all over online and tried all these different things (aligning the boxes, making sure the headings line up w/ the data, etc). This report exports perfectly if I do it xls. If I export to CSV, it prints the suppressed lines. My CSV...

I don't know if this can be done. I have a report header that I would like to show the current months date range in. I would like it to say 10/1/2013 - 10/31/2013. Then next month it would say 11/1/2013 - 11/30/2013. I want it to use the date I am refreshing the report and put in the date...

Good morning! I have a report that needs to have a "Claim Start Date" and a "Claim End Date". This report currently runs the first day of the month for the LastFullMonth. Right now I have it emailing to me so I can make the Claim Start Date 20130801 and the Claim End Date 20130831. Is there...

I have a formula in crystal and it’s not matching the result I’m getting in excel. Excel Results: Cost: $6.29 Sell: $8.89 Margin: 29.25% Excel: I'm figuring this by sell-cost = diff then the diff/sell Crystal Results: Cost: $6.29 Sell: $8.89 Margin: 29.23% Crystal – if {db.Cost} = 0 then 0...

I have a field that I would like to split. Right now it looks like: cono=1 orderno=1255193 ordersuf=00 lineno=5 I would like to split those into 4 separate fields. I just need to see the data: 1 1255193 00 5 The words and = are always the same: cono=, orderno=, ordersuf= & lineno= Can you...

I am pulling an order file and looking for a specific item number. If I find that item number, I want to display all of the lines on that order. I can't think of how to do this. If I narrow it down by the specific item number, then I only get that line, not all of the lines on the order. Can you...

I have reviewed some of other posts and tried a few different formulas, but I still can't get this to work. I have a string field that looks like this: Janitorial Restroom ~ 1011-4 ~ Jan/San I need it to be split into three separate fields using the tilda as a split. CategoryName...

I don't know if this can be done. I am looking at transactional data for a specific date range by customer. I wanted to create something like this: Cust# Name 01/01/12-01/31/12 02/01/12-02/29/12 0123 ABC Co $15,523.12 $20,123.78 Right now I'm running a...

My goal is to create a lost business report. The data I am using is by customer, by year, by month, by product ($'s and Qty). My groups are: customer, then product then year. My file has shipto level data so it gives me a line per item per shipto. I've added a summary that adds up each item by...

I have a phone / fax field and need to pull out the "/" and "-" in the field. The field currently displays: 518/555-0010 I need to display: 5155550010 Any help is appreciated! Thanks

Good morning! I have an array field that has sales information in it. For example: 0;0;1;2;25;3;0;0;12;20;30;0 Each split represents a month (Jan-Dec respectively)...so in November they purchased 30. I did the split of each section so I have each month broken out. I want to get a ytd total...

I have a field (customer PO#) that has a 4 digit # which means nothing to us, then a “-“ dash, then a 2 character alpha-numeric code. I want to capture the 2 characters after the dash, not the entire #. PO# 5200-C3 5200-H6 I want the report to show: PO# C3 H6