Search results for query: *

I didnt say it was a perfect solution, it will get you close.

I've done something very similar in the past. What I did was strip out all of the punctuation, spaces, and in your case you'd need to strip the numbers as well. That would get you pretty close. I used a series of loops to accomplish this.

Right, but if you were to do the running total on the same field that is being used for the summary in the grouped section but placed it in the report footer it would only sum/count the records that were included in the top 5 groups. This works because of the evaluation time of the running total.

Why wouldn't a standard running total work in this situation?

Spider thing worked GREAT. It was funny because when my boss answered the phone he picked it up so fast the spider went over his shoulder. He didn’t see it till he started to hang the phone up then he dropped the phone and the back-pedaling started. He didn’t scream like I was hoping but he...

I might have to give that spider thing a shot. Right now we have tons of those things lying around as Halloween decorations.

What are some key points to include in it? TIA, Brad

How about this; (If {?strBusinessUnits} <> "***ALL***" then {Command.BUSINESS_UNIT} = {?strBusinessUnits} else If {?strBusinessUnits} = "***ALL***" then true)

You can right click on the label and select Edit Axis Label. This will change it on the chart and the legend.

I'm not familiar with Crystal 8 but if you have the truncate function you could use this; Truncate(MyField,1).

I've done something similar to this before by creating a formula that has the text of the hyperlink and then insert your database fields where they need to be. Something like this; "www.mysite.com/" & table.field & "blahblahblah...". You are just concatenating the link using the database...

jsaxe - That's beautiful. We had a guy write a script that would display a "You have a virus" message when any MS games were launched on a PC. Push that out to some PC's and let the fun begin. We never actually did but it sure would have made for a good laugh.

Tried the bells and whistle thing, it just became the norm and now I am continually raising the bar for whats expected from me. Not that that’s a bad thing but it kind of takes the "fun" out of it.

Thanks for your suggestions. I ended up writing a little algorithm to manipulate and reconstruct the address. Then used the result of that to group the like addresses together and determine a "household".

I’ve been with my current employer a little over a year and like what I do but every now and then you need something to make it interesting. What do you guys/gals do to make work more enjoyable and break the monotony of day to day operations? Thanks

I’m looking for ideas on analyzing addresses to determine if they are the same so that I can combine groups of individuals with the same address together and assign them a single “household id”. As you can imagine with all of the variations of address data there are several possibilities for...

Are you looking for these; PreviousValue(field) and NextValue(field)?

Worked like a charm!

SQL Server 2000 Standard Edition We have large table (a few million records) that has been storing a column as an incorrect data type. This column is supposed to be storing interest rates but the data is being stored as an integer. What would be the best way to convert it to the numeric data...

I've never had to ask for a raise before and was hoping for a little input on the best way to handle it. Thanks in advance, Brad