Search results for query: *

Formula 2 is working! Thank you for all the guidance and instructions. Have a great holiday weekend! (I know I can now that I can deliver my reports!) :-) Appreciate all the guidance and patience.

I think I originally misread your question. The field has a limit of 4000 characters. Within the field, this IP address I'm trying to redact can be multiple showings. I've seen up to 8 occurrences so far. I wasn't sure if it's the loop within the field itself or the volume of the data I was...

LB - I ran your suggestion in a small sampling and it was perfect. Running it against my full collection of ticket extracts, I'm running into this error "A loop was evaluated more than the maximum number of times allowed" Any suggestions?

LBASS OMG. THANK YOU..THANK YOU..THANK YOU. You’re a GENIOUS! working as suggested above. You have saved me hours’ worth of manual data scrubbing! HUGE “Thank You”!

lbass - yes, an IP address will allows contain multiple "." whereas any other numeric value may contain a single 'dot' such as dollar amount or perhaps end of sentence ie - $1500.37 or "My account balance is 197.60." (not allows in proper $ format) yes - my data is ugly!

Thank you lbass for the idea. To answer your question, yes, more often than not there will be other numeric values in the 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...

Thank you for the nudge pmax9999 - unfortunately, I was redirected on a different priority and have not had a chance to try the suggested solution. When I do, I will update accordingly.

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

Your the best. Just had a chance to walk through the recommendation. Brilliant. I have worked sub-reports in the past and completely escaped me to even try that option. Thanks so much for the help.

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

Thank you Gordon.

Thank you both for your suggestions. Gordon - got your idea working. Only problem left would be the ability to have column headings. I have content in the row section, and content in the summarize section. Nothing in the column. Any thoughts on how I can get labels in place for the 4 new...

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

Thank You Deniall! Appreciate the help.

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

Thank You Very Much! Appreciate the help!

Thank You Charliy - worked great as you have described. I made a slight modification to have 2 independant columns one for dependant and one for provider, also removing reference to the server name. my only remaining item is, how to i remove the comma that is showing up as the first charater...

Charliy - Thank you for this idea. Can you offer a sample on how to do this?