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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: smmedeiros
  • Content: Threads
  • Order by date
  1. smmedeiros

    Removing or replacing IP address from text field

    Has anyone been successful with removing an IP address from a text field of varying size with the IP address itself being of varying formats For example. line1 line2 some type of text information 11.1.111.1 line3 line4 desired output line1 line2 some type of text information xx.x.xxx.x line3...
  2. smmedeiros

    Conditional Row Suppression

    Appreciate any ideas or guidance. I want to conditionally suppress rows based on current record compared to previous or next record. Whatever is easiest. Explored several write-ups using next and previous and can't seem to get this working. My sample data is attached. I have 2 columns, server...
  3. smmedeiros

    Reading UP and Down and how to surpress unwanted rows

    Help or Ideas - please I reach configuration items and trying to create a customer report where I can display the relationships. I have a PRIMARY CI (i'll call it CI Search) I'm trying to display all the associations. dependant & provider I have 3 examples (attachment shows content) 1st...
  4. smmedeiros

    Cross Tab and Grouping

    I'm working on a cross tab report where i have 4 variables I've placed in a crosstab Manager Name Door Access Flag in the row section Manager Name in the column section Door in the summarized Section Mode of Access Flag The results are what I expect, simple table showing Manager --> name...
  5. smmedeiros

    Business Ojbects Central Management Console - dynamically addressing based on report data results

    Looking for guidance (or confirmation if this is possible) I'm using Crystal Reports 2008. I have a report that provides me inflight change tickets with the association of the group in which it has a pending workflow. I want to be able to schedule the report for daily execution via Business...
  6. smmedeiros

    Date Differences - multiple dates, with blank values

    Looing for help. Not good with nested statements. i have 3 date values active decom today() need formula to calculate date difference if active populate and decom blank, date value is today()-active if active populated and decom populated, date value is decom-active if active = blank and...
  7. smmedeiros

    Use of multiple accum/display/reset fields

    Looking for guidance. I have a need to pull configuration item (CI) information. I have many CI's with multiple providers and dependants. I want to display on single row a provider field (comma delimited) and a dependant field (comma delimited) ex. server1 - dependant1,dependant2 -...
  8. smmedeiros

    Extracting portion of varying lenth field - everything except last character

    Can anyone share a method to extact all characters of a varying length field.. ALL but the very last character - mixed character type alpha & numeric For example abcd1234 results desired -> abcd123 abcde results desired --> abcd 123ab45 results desired --> 123ab4 Thanks
  9. smmedeiros

    Networkdays - differnce between 2 dates in Minutes; excluding weekend days

    Looking for help to calculate the difference between 2 dates timestamps in number of minutes. I have a need to exclude weekends (Saturday & Sundays). I'm familar with the use of Networkdays - however, that shows in days I'm familiar with simple calculate =(b1-a1)*1440 .. however, this does not...
  10. smmedeiros

    Replacing a portion of text field

    Looking to replace a portion of a text field. Sample -> Database Oracle ~PATCHING WINDOW,MONTHLY,WEEK2,SATURDAY,23:00-05:00,~ Results desired is to remove the contents between the tilde marks to have new field as "Database Oracle" Sample2 ~PATCHING WINDOW,BIMONTHLY,WEEK4,SUNDAY,11:00-15:00,~...
  11. smmedeiros

    ability to apply an indentation in multiple groupings

    Does anyone have insight how to apply an indentation on multiple groupings sample: group1 group2 group3 group4 i have 15 columns of data in each of the group rows. i want the values in column1 (the group name) to be indented at incrementing intervals as displayed in the sample and...
  12. smmedeiros

    Crystal Viewer-subreport/drilldown not viewable

    Looking for guidance. I created a Crystal report (v12) with a subreport. Main report contains ticket details...ticket#, date, etc. Subreport linked by ticket# contains multiple lines of activity data (date/time, comments, updated by, etc.) Subreport is set as 'OnDemand' Subreport is placed in...
  13. smmedeiros

    Extracting everything to the right of a value

    I'm trying to extract everything to the right of a particular field value example: 1 of 2 servers to replace the existing Sterling Gateway and backup server PATCHING SCHEDULE 7/13/12 5PM -7/14/12 5AM [2AM-5AM reboot window] I want my results to be: PATCHING SCHEDULE 7/13/12 5PM -7/14/12 5AM...
  14. smmedeiros

    Use of PageBy in Cross-tab expert

    Does anyone know if it's possibly to apply a 'pageby' methodology to a cross tab? I have 4 rows/1 summarized field in the cross tab and looking to see if i can force a new page with the data change for contents of the first row. Appreciate any/all ideas. Thanks using cyrstal reports 2008, v12.
  15. smmedeiros

    Extracting Portion of String

    I have an issue simliar to thread767-1008457. I have this field --- (note single quotes are included in the extract) Transfer group from 'MGTI GL Data Center Ops' to 'MHRS US Middleware Eng' I want to be able to extract "from" and "to" information 2 variables - so, formula1 contains...
  16. smmedeiros

    selectively extracting data from multiple entries

    Looking for guidance. I have an issue similiar to posting thread181-27567 - which did not offer a solution. I have 3 variables Act.log.type Act.log.date Chg.number Sample data: 234123 Closed 10/01/09 17:01 234123 Resolved 10/01/09 15:45 542314 Resolved 09/28/08 16:45 433671 Closed...
  17. smmedeiros

    Cross Tabs - Anyway to merge 2 into 1?

    Can anyone offer ideas for a solution. I have 4 variables. ServerName Decommission Date Create Date Company Name I currently have 2 independent cross tabs that represent the # of servers added by quarter using company as the row, create date (formatted by Mon-YY) as the column and count of...
  18. smmedeiros

    Processing Efficiencies

    I have been reading through many threads looking for ideas for processing efficiencies. I found an old thread that was similar to my issue and want to explore it in more detail. (thread767-1198959) I have a database of millions of records that I’m reading through. Unlike the thread...
  19. smmedeiros

    Date Difference on Single Date - multiple entries

    Can anyone offer guidence on how I would calculate the difference between a datetime variable whereas it's a single field in the database. I have 3 2 variables directly from the database: contact and activity date. The 3rd variable i create based on the contact details ManagerSort ( if member...
  20. smmedeiros

    Number of Hours between 2 business dates

    Looking for some guidance. Does anyone have a formula sample that will calculate the difference in TIME between 2 dates that is business days only? I've been all over the postings. I can easily calculate the difference in days between 2 dates and exclude weekends, but, the results is in...

Part and Inventory Search

Back
Top