Recent content by HardJeans

Sorry, I'm using SQL Server 2000 (though I hope to be on 2005 sometime next year). -- "I'm not talking to myself, I'm just the only one who's listening." - JCS

I'm working on cleaning up some of the data our company has in its databases, and I need to quantify how similar two text fields are. e.g. Database1 has a table with employee information, one of the columns has name stored as "Susan Smith" Database2 has a table with employee information, one of...

I understand they're not the same thing. I'm sorry for even posting an option that may have not been thought of. It was explicitly stated as a month, and even showed the output for comparison. Yes, the parens affect it...

I was just giving options, and hadn't realized you already posted {?StartDate}+30 for the 30 days ahead. There was a small error with parenthesis. If you want to do it they way you mentioned do the following: dateserial(year({?Start_date}),month({?Start_date}),day({?Start_date})+30)

Unfortunately, that would be attempting to do the following in your example: Cdate(2007,5,52) When that happens, it loops back to the 1st again, so the output of that would be 5/21/2007. If you want to add 30 days and the parameter is a date, simply do the following: {?StartDate}+30 output...

If you don't want to show other years, use the select expert to select just the years in the parameter. If you want to show multiple years, group it by the year, and put the formulas in that group instead. This way it will show: AcmeCo 2006 - 500 2007 - 600 GenCo 2006- 200 and so forth...

I'm guessing you want to add the hours if the client has 2 records. If it's grouped by client name then replace the formula as follows: If {tbl_BgtYrHrs.budget_yr} = Year(CurrentDate) Then "Grand Total (" & CStr(sum({tbl_BgtYrHrs.total_hrs },{tbl_BgtYrHrs.client_name}),0) &"): " -- "I'm not...

In the group header of the store place a formula that resets the shared variable to '0'. Just my opinion, but wouldn't a comparison of the monday of the 34th week this year compared to the monday of the 34th week last year be a better comparison? Not trying to complicate the report. This...

I knew there was something I was missing. For some reason the formula option had the default values for nulls. Thanks Ken!

I can do the {@Null} on formulas that return text, but it seems to just returns zeroes when the formula otherwise returns numbers.

Thanks for the response Ken. I've found your website very handy on many occasions. I already have a group on the appendage: Group1: Kingdom (animal/plant) Group2: Type (dog/cat/human) Group3: Appendage (Leg/Arm) then for example dog leg chart does this: average({# of}, {type}) - outputs 2...

You say you imported the excel file originally. Did you import it into a SQL database, or did you actually use crystal reports to pull data from the excel file? If SQL, just import the new data into SQL, if not, add the rows to the current excel file. Then simply refresh the Crystal Report.

We would need to know what the variable is used for. If the variable is counting something for example, use: Max(variablename) in a formula, and use the formula in the graph.

Sorry...forgot all about this...Crystal 11.

With the way the database is normalized, this is how the data is returned to Crystal. Kingdom|Type|Appendage|# of| Animal|Dog|Leg|4 Animal|Dog|Arm|0 Animal|Cat|Leg|4 Animal|Cat|Arm|0 Animal|Human|Leg|2 Animal|Human|Arm|2 Animal|Caterpillar|Leg|100 Animal|Caterpillar|Arm|0 Plant|Carrot|Leg|0...