Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kcoleman26

  1. kcoleman26

    Sharepoint & Outlook contacts

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

    Excel find or lookup in a string

    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?
  3. kcoleman26

    Excel find or lookup in a string

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

    Concatenate Multiple Rows

    Thanks ianoctdec that worked perfectly KC
  5. kcoleman26

    Concatenate Multiple Rows

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

    Combining 2 reports into one

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

    Display text if a certain parameter is met

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

    VLOOKUP Retuning same value

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

    VLOOKUP Retuning same value

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

    Excel Move Data to Next Avaliable Cell

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

    Excel Move Data to Next Avaliable Cell

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

    Excel Move Data to Next Avaliable 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...
  13. kcoleman26

    Excel Move Data to Next Avaliable Cell

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

    Shared Variable from Subreport

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

    Shared Variable from Subreport

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

Part and Inventory Search

Back
Top