Search results for query: *

Assuming that you have a field called Year, then put this in the Record Selection formula: {DB.Year} in ["2010", "2011", "2012", "2013", "2014"] or you could use greater than/less than. >= and <= . If you have an actual date field you can use: {DB.Date} in Date(2010, 01, 01) to Date(2014, 12...

I don't have the exact coding, but you should be able to use two Parameters. Call them Start and End. The customers enter the request dates there. Then in the Report/Selection Formula/Record you have something like: {Table.field} in Date(?Start) to Date(?End) HTH. Bob

Hi, I have Crystal 2008 version 12.0.0.683. I have a field called {EQUIP.SAFETYNOTE} that is a Long Character Object. I want to delete 1 - 5 standard lines. Then only if there is any data left, export to word. My initial Record Selection Formula omits null and blank fields. What I want...

Thank you LB. I beat my head against this on and off for two days. I appreciate you and all the rest here at tek-tips.com . I search the threads frequently for solutions to my question. Thanks again !!! ~Bob

Hi, I have Excel 2007 I'm looking to select data for a graph based on a formula. Not graphing a formula. I have Excel 2007. I have a data set where each row represents a date, then work closed out by hour (6 times a day). The relevant data I use is below: Row 2 is 4/4/11 , 50 , 75, 20, 110...

Hello: I'm using CR 2008 version 12.0.0.683 I have two running totals, #OT-Hrs-room and #Reg-Hrs-room. This measures labor hours, Overtime and Regular. The running totals work, print and reset the way I want. I'm trying to add the two together with the formula @Tot-Hrs-Rm. My problem is...

Thanks LB ! Also thanks to everyone who post solutions here and the folks who hosts Tek-Tips. I frequently find solutions to my report problems when searching Tek-Tips. Plus I learn a lot from reading the solutions to other people's posts. I do appreciate all you experts who keep helping...

I need to find elapsed time between when a work order was requested and completed. Searching Tek-Tips I've found elegant solutions to this. (Thanks everyone!) However due to how our data is stored I need to combine a date field with a time field. A sample of the data is: {WO.COMPLETIONDATE}...

Update. I just realized that in my Design section I'm trying to print the EQUIP.EQNUM Which if it does not exist, will of course not print. So how do I print the Equip Numbers from my list that is not in the table?

Hi, Using CR 2008 version 12.0.0.683 I have a single table and a list of records. I want to find which records are not in the table. I've tried: (Equip number list greatly shortened) // No Equipment record {EQUIP.SITEID} = "BJH" and ({EQUIP.EQNUM} in ["NE00020283", "NE00020310"...

Try setting your paper size to legal or larger. I normally set my page size to legal or sometimes a custom 36" so I can export vast number of columns to Excel. Anyway at some point I changed the size to letter. Whenever I ran the report the mystery fields would appear. I couldn't see them in...

Thank you Hilfy! That's exactly what I needed. Bob

Hi, I'm using CR 2008 version 12.0.0.683. I'm trying to find data from one table that is not represented in a second table. Given table {Equip} and table {Tasks} I want to find all {Equip.EquipNum} that is not included in {Task.EquipNum}. My left table is {Equip}. I do have some Record...

Thanks elsenorjose! That did the trick.

Hi, I have CR 2008 Developer 12.0.0.683 I'm trying to find the most recent date record in a group. I have two linked tables {Equip} and {WO}. In Report/Selection Formula/Records I've selected the Equipment I want by {Equip.SiteID} = "mysite" AND {Equip.LSCode} = "L" I have over 7000 records...