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

There is a lot of help on line but it's not all completely helpful. I have been messing around and got the field from the subreport to show up and I'm sure this is something silly but my end formula is off by a line. I think it has to do w/ the detail b section but I'm not sure what to do. I'm...

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 Skip, Where do I get to these options? Under Create New Connection - Access/Excel (DAO)? I am looking all over :). I did go under OLE DB (ADO) but I don't see Microsoft.ACE.OLEDB.12.0 as an opion. Thank you in advance!

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 was actually looking through other threads after i posted this and i came across one and tried it and it works. i have no idea why it works though. i've never used ubound before. i'm using it for the Stop # part of the field split. Split({oeeh1.route}," ")[Ubound(Split({oeeh1.route}," "))]

It was that easy!? Why didn't I think of the "and". I'm such a dork. I totally overthought it. Thank you! I'm all set...and need a vacation I think. :)

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

Thank you both! I'm all set!

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

Thank you for the reply Charliy. I tried that and get a true/false result but I think I might have done it wrong or explained it wrong. Table 1 has two units of measure in two different fields (unitstock and unitsell are the actual field names). I wasn't able to create the exact formula you...

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

Mid worked. I walked myself right through that one :)

I thought I had it with: Right({arss.route}, 5) But there are spaces in the field so it varies. The field can be up to 7 characters. But there are spaces and / or dead spots. MW WF TH I would like to grab the WF TH of this string. Sometimes it could be: MW WF R I think maybe mid would...

I have another field where I have to get rid of the first 3 characters? BAY4895 and I need 4895.

You rock! Thanks!

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

That is perfect! Thank you!