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

Close what is happening now is it is returning SR-19 from the SR-192 entry so it doesn't recognize the comma. Is there a way to make it look between the commas?

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

Thanks ianoctdec that worked perfectly KC

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

Might have to go with a Macro. Guess I gotta dust off those skills sometime it has been a while. Thanks

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

The .CSV got me thinking I saved as a .txt file then opened in Excel I had a comma for every column there is a check box in excel that says Treat consecutive delimiters as one so that worked

It is a one time operation. I was hoping to avoid doing that mostly because I have 88 columns that I would have to Concatenate. Unless there is an easier way to Concatenate 88 columns with a delimiter between each cell.

Fantastic that is what I wanted it to do in excel was to take out my spaces. Anyway does hopefully this makes more sense. Sorry A__________B_________C________D_________E__________ C1003 ______________LF________NX________NP C1004 __________________________________NP C1005 ____NS...

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

Thanks lbass that did get the result and of course they want to see one and average. Is there anyway to divide the summery in the sub report by a summery in the main report. I may need to rethink this entire report. I went this way because of the way my data pulls in this report. I am...

In My SubReport WhilePrintingRecords; Shared NumberVar myTotal :=sum ({@f_Room Nights}) In My Main Report WhilePrintingRecords; Shared NumberVar myTotal; myTotal I have my subreport in the report header of the main report I am getting a total when I insert that formula field into the report...

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

That is exactly what I wanted. Thank You Milesprower

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

lbass It worked beautifully... Thank you KC