Search results for query: *

SharePoint & Outlook 2013 I have a Contact List that has been synced with SharePoint. When in Outlook I can make changes to the info (ie Job Title) and when viewing in SharePoint the changes are made. When in SharePoint I can make changes to the info (ie Job Title) and when viewing in...

I have a cell with a sting of data in it. C4: SR-305, SR-192, SR-193, SR-194, SR-225, SR-18 I have a table with a list of values that I am looking for within that string A 1. SR-10 2. SR-11 3. SR-12 4. SR-18 5. SR-19 What I want is to look in the cell string of data and if it...

Crystal 2008 I have a report grouped by ID# some ID's have 1 contract some ID's have multiple contracts. I want a single field display of all of the contracts for the ID#. Example: ID 1 Contract #1 ID 2 Contract #1 Contract #2 Contract #3 ID 3 Contract #1 Contract #2 What I want it to...

CR2008 We have a user that is trying to combine two reports into one report. The reports are almost exactly the same with the exception of two fields. Both reports work great independentaly but they now want them to be one report based on the parameters that are selected. The issue I have is...

Crystal 2008 I have a formula for the date range parameter {Date Range Title} that I am displaying in the report header. "From: " & Minimum ( {?Date} ) & " To: " & Maximum ( {?Date} ) Now what I am stuck on is when the Min & Max date meet a specific critiera I want to display the...

Excel 2010 I am creating a tab on a spreadsheet that you can type in a Report # in one cell and get all of the information listed to display on that tab. I know filtering could do the same thing but I am also bringing over other information in which I am calculating on. The end result should...

Excel 2007. I need to find a way to move data in a row to the next available cell in that row. Not sure if that makes sense so here is an example. A B C D E F G C1003 LF NX NP C1004 NP C1005 NS...

Crystal 2008 I am not sure a shared variable is what I need but I think it is I just can't seem to make it work. I have a main report that groups reservations and calculates the a total for records and revenue. I have a sub report that groups the reservations the same way as the main...

CR 2008 I have built a report to calculate the difference between the currenttime and the time a record was made. When using the actual Crystal Report if I change my system time to eastern time the report works fine. However when I load the report on the Business Objects website and run the...

I have been handed over the task of modifying the custom Crystal reports that have been created in Symposium. The company terminated the employee that knew how to build the reports. Since I know a little about Crystal they have come to me on the modification of the reports. 1. How can I...

CR 2008 I have a report that pulls from two databases lets just say Table1 and Table2 they are linked using two fields. Everything seems to work but only if the Table2 database has info in it. If a certain field in Table2 is blank and it meets all the other criteria then I want to see the...

Excel 2003 I have played around now with the several functions WORKDAYS, NETWORKDAYS, that can add in my holidays. The functions above only calculates the WORKDAYS, is there a function or formula that can count the totals days but if it falls on a weekend or holiday push it to the next...

Excel 2003 I am working with Two Sheets one that has the Data on it that is entered manually. The other is a like a Contract where if I fill out the Data sheet it will populate the contract. The problem I am having is when I insert a row that copies my formulas the formulas on the contract...

CR 2008 I am trying to convert a number to a time ex(920 to 9:20AM, 1330 to 1:30PM). Once converted I would want to round the time up or down in 30 minute increments 8:00 AM 8:30 AM 9:00 AM using 7:45 - 8:14 = 8:00 AM 8:15 - 8:44 = 8:30 AM 8:45 - 9:14 = 9:00 AM and so on. Thanks, KC

EXECEL 2003 In the mentioned thread if gave the formula =0+(LEFT(Q3,2)&":"&RIGHT(Q3,2)) to convert 1440 to 2:40 PM The problem I am having with this formula is when I try to covert 920 to 9:20 AM for some reason it goes to 8:20 AM some other numbers it goes to are strange as well 726 12:26...

Crystal 2008 ODBC Connection Not sure I can even explain this intelligently. This is for a Housekeeping Report for a Hotel. I am linking 3 databases {RMP}-->{LMGEP}-->{GIP} in that order as Left Outer Joins. The report works like I want except it doesn't pull the room when 2 or more people...

I am constantly getting spreadsheets with arrival times on them that my boss wants broken down into 30min intervels. I have been doing this manually and was wondering if a formula could be used to do this quickly. I get the data 8:10 AM 8:20 AM 8:35 AM 8:53 AM I would like to create another...

Crystal XI I have a date field that is a number 12207 = 1/22/07 and 123107 = 12/31/07. How can I get {Date} to show as mm/dd/yy? I saw in this for to convert a sting to date but my field is a number and the ones I found the number was 20070122 so the formula didn't work. KC

Crystal XI I keep building reports that sort the same data in different ways. I know there has to be an easier way so the end user can choose how they want the report displayed. Example: Departures Report - This report the user can select the Group and a Range of Dates to see Departures. I...

Crystal XI I am working on a report that will show me the last record for a room. My Time comes from iseries in military time as a packed number 152129 is basically 3:21.29pm I really don't even need the seconds just the military time formatted 15:21. I only want to see the last record for...