Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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